Hi,
we are trying to query the ShopifyQL orders table to get the net_sales via:
curl -L -X POST ‘https://REMOVED.myshopify.com/admin/api/unstable/graphql.json’
-H ‘Content-Type: application/graphql’
-H ‘X-Shopify-Access-Token: REMOVED’
–data-raw 'query {
shopifyqlQuery(
query: “FROM orders SHOW net_sales GROUP BY day SINCE 2022-12-19 UNTIL 2022-12-23”
) {
__typename
… on TableResponse {
tableData {
rowData
columns {
name
displayName
}
}
}
parseErrors {
code
message
range {
start {
line
character
}
end {
line
character
}
}
}
}
}
’
and we are getting a 200 response with INTERNAL_ERROR:
{
“errors”: [
{
“message”: “Internal error. Looks like something went wrong on our end.\nRequest ID: 13e52c6a-c083-4889-8db5-03489a15d411 (include this in support requests).”,
“extensions”: {
“code”: “INTERNAL_SERVER_ERROR”,
“requestId”: “13e52c6a-c083-4889-8db5-03489a15d411”
}
}
]
}
Could you please advise what is wrong here? thanks you!