ShopifyQL now available within the Admin API

Announcements
1

Hey developers! :waving_hand:

Excited to share that ShopifyQL is now available as shopifyqlQuery within the Admin API.

Instead of rebuilding Shopify’s entire analytics layer, you can now query our data directly using the same analytics engine that powers Shopify Admin.

What’s new:

  • Direct access to sales, customer, and product analytics data
  • Same metrics merchants see in Shopify Admin
  • No more custom data extraction or modeling required

Who should use this:

Almost every app can benefit. Even if you’re not building an analytics app, showing consistent sales data, customer metrics, or product performance builds merchant trust.

Learn more:

Drop a comment below if you are excited or have questions!

3 Likes
3

Hey @Liam-Shopify

This is great update. I wanted to use but I get the

      "message": "Access denied for shopifyqlQuery field. Required access: `read_reports` access scope. Also: Level 2 access to Customer data including name, address, phone, and email fields. Please refer to https://shopify.dev/docs/apps/launch/protected-customer-data.",

message. I already added the “read_reports” in my access scopes. What can be reason behind this?

4

Hey @Muhammed_Tufekyapan Did you re-authenticate your client key after the scope change?

/N

5

Hey Nicolas,

I did, Shopify shows the scope change and asks for the permission. But it didn’t work. Currently I just built the report with my data. But if this works perfectly, it’ll be a game changer for me and for merchant experience…