Problem Accessing Report Data Using API

amolkankane
Tourist
3 0 0

Hi there,

 

I am trying to use the Report API to fetch data from a specific custom report created using the App. The report creation is successful using the REST API. When I try to read it using GET /admin/api/2020-07/reports/{report_id}.json, all it returns is the report definition - 

{
    "report": {
        "id": {report_id},
        "name""Report-API",
        "shopify_ql""SHOW total_sales, orders, gross_sales, discounts, returns, net_sales FROM sales SINCE -1y UNTIL -1d ORDER BY \"day\" ASC LIMIT 1000",
        "updated_at""2020-09-01T16:42:46-04:00",
        "category""custom_app_reports"
    }
}

Is there some way I can get this data using REST API, maybe using the ShopifyQL?

Any help is really appreciated.

 

Thanks,

Amol

0 Likes
pujaparekh
New Member
7 0 0

hi,

Did u find answer to your question? I am facing the same problem.

0 Likes
amolkankane
Tourist
3 0 0
Yeah, it was just not supported. You can only get report metadata but not the data inside. Not sure if that has changed in the past 2 months. Will appreciate if you can post on this thread if you find anything different.

Best,
Amol
0 Likes