Unable to get reports with API

Solved
Visely-Team
Shopify Partner
1835 210 428

@Francis21 as mentioned above, this endpoint will ONLY return the reports (not the data, but the report definition) created using the same API access token. You are getting [] because you didn't create any reports through the API.

Sergiu Svinarciuc | CTO @ visely.io
- Was my reply helpful? Click Like to let me know!
- Was your question answered? Mark it as an Accepted Solution!
- To learn more about the awesome stuff we do head over to visely.io or our blog
0 Likes
Francis21
New Member
2 0 0

Thank you for the reply. As we are creating a internal database for our email campaigns, is it possible to retrieve the total orders and total gross sales metrics for each utm_campaign_name?

 

 

0 Likes
Visely-Team
Shopify Partner
1835 210 428

@Francis21 only by leveraging Shopify Order API (REST or GraphQL) to go through the orders and pick the ones that have the extra information you are matching on (say UTM campaign) in the customAttributes. But this is all assuming the customAttributes are populated when the order is created on the store front (through a third-party integration or an app).

Sergiu Svinarciuc | CTO @ visely.io
- Was my reply helpful? Click Like to let me know!
- Was your question answered? Mark it as an Accepted Solution!
- To learn more about the awesome stuff we do head over to visely.io or our blog
0 Likes
zhangqingxiu
New Member
7 0 0

Hello I have encountered the same problem now, but I always fail to call the creation interface. I am using C# and the interface always returns: “The request could not be understood by the server due to malformed syntax”. I use the post method, The text passed is

{
  "report": {
    "name""A new app report",
    "shopify_ql""SHOW total_sales BY order_id FROM sales SINCE -1m UNTIL today ORDER BY total_sales"
  }
}
Can you tell me what went wrong?
 
0 Likes