Additional Setup to Use shopifyqlQuery?

Additional Setup to Use shopifyqlQuery?

gcb0323
Visitor
3 1 0

Curious if there is something I need to do to activate the capability to run the shopifyqlQuery function. I'm successfully running other cURL request examples from the documentation using the unstable version of the GraphQL API no problem but when I try and drop in this function I get a 'Bad Request' response. My personal app has read_reports scope.

 

 

 

-d '{
"query": "{ shopifyqlQuery(query: "from sales show total_sales by month since -1y until today") { __typename ... on TableResponse { tableData { rowData columns { name dataType displayName } } } parseErrors { code message range { start { line character } end { line character } } } } }"
}'

 

 

 

This example is lifted directly from the docs here: https://shopify.dev/api/admin-graphql/unstable/queries/shopifyqlQuery#examples-Get_a_table_data_resp...

Replies 2 (2)

jdpy19
Shopify Partner
3 1 1

Hey, I am receiving the same thing. Were you able to resolve?

denisgarcia
Shopify Partner
4 0 0

It is an old question, but just in case it is useful here my answer. I believe your issue was related to the version of the API used. Try using this one or higher: '2023-04'

https://${SHOP}.myshopify.com/admin/api/2023-04/graphql.json

At the time of writing this question, there was probably a beta version of the api(?)