Our Partner & Developer boards on the community are moving to a brand new home: the .dev community forums! While you can still access past discussions here, for all your future app and storefront building questions, head over to the new forums.

401 when fetching shopifyQL

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)