401 when fetching shopifyQL

federicolopeze
Shopify Partner
1 0 0

I'm fetching shopifyQL with the query detailed below.

 

When I do it on staging environment it works well, but testing it in production it returns this error: "errors": "[API] Invalid API key or access token (unrecognized login or wrong password)".

 

What could be happening?

 

query {\n shopifyqlQuery(\n query: \"FROM products SHOW sum(gross_sales) AS gross_sales, sum(net_sales) AS net_sales, sum(ordered_product_quantity) AS ordered_product_quantity, sum(taxes) AS taxes GROUP BY month WHERE product_id=8048261660946 OR product_id=8048314679570 OR product_id=8146430656786 SINCE -7m ORDER BY month\"\n ) {\n ... on TableResponse {\n tableData {\n unformattedData\n }\n }\n parseErrors {\n code\n message\n }\n }\n }\n " }

 

 

Replies 0 (0)