hi,
There is a store available and there are some exisiting reports in that shop.
Client is giving the name of the reports and Access token, shopurl etc.
We have to download those reports using API. These reports data will then be used for ETL process.
There is no shopify QL or table names that client is aware, beccause they are business people.
how to proceed? Please help on this..
You can’t currently access report results via the API. Shopify QL is being brought back, but only for Plus stores.
If you can give more details about what will happen with the data once retrieved, someone might be able to suggest a solution.
We require that reports data for ETL processing, We are pulling this data into AZure.
WE will be using those data in Azure DW and generate reports in PowerBI.
Kindly help with more details how to get the data.
Or Is it possible to get the SQL query for those reports?
There is no way to get the reports directly yourself via the Shopify API. The only way yo do this is to call the orders API and compile the numbers yourself.
we have an app that could help with this if you are interested. Let me know.
Hello @Santhi ,
If you are looking for a tool to create your own dashboard/reports with all your data (e.g., Shopify, Facebook Ads, Google ads), feel free to check our app → Dive analytics
Dive is a BI software tailored for eCommerce merchants where you can:
Quickly run personalized analyses that fit your needs (or use our templates)
Build your own dashboard in a no-code environment
Track specific KPIs with our Goal component and align your team.
Collaborate within Dive to get your whole on the same page.
And we offer a 14-day free trial
Use the Shopify Admin API with the given access token and shop URL to fetch report data. Start with the Reports API endpoint to list available reports. If navigating the API is complex, Skyvia can help streamline data extraction for your ETL process.