How do I run custom reports using the API?

[hila_c]

Hi,

We develp an integration for our customer that wishes to bring data from Shopify custom reports.

Is there an explanation on how to do that?

I understand that I can't work with reports my integration user didn't create, but how do we get past that?

Thanks,

Hila

[CloudlabSam]

Hi there - the Shopify Api does not allow you to return the data from custom reports - only the report definitions themselves.

[hila_c]

Hi CloudlabSam,

Thanks for the answer - I am not sure I understand what you mean, can you please elaborate?

[CloudlabSam]

I'm saying that the Shopify API does not allow you to return data from custom reports. It only allows you to know that the custom report exists and what the parameters are. Not the data itself.

[hila_c]

Thank you!

Is there a work around? Maybe using the GraphQL?

[CloudlabSam]

Depends ion the report data you are wising to retrieve. Shopify QL is now available in beta for Shopify Plus customers, but this is just Sales data for now.

There are a lot of apps in the store that provide reporting functionality.

[wbenjamin]

If you want data from a custom report, you basically have to generate the report yourself using the parameters the report has.

Not much fun..., but doable (it's what I have to do)

[hila_c]

No, no fun. And I can't find one important field - api_client_title. some peope said it can be found in the "channel" field, but I don't see it either

[CloudlabSam]

What are you expecting from api_client_title? Meaning what values are you seeking?