Joey_Sturgis
New Member
Contact Me
Status
Offline
Last Activity
‎03-23-2023 07:14 PM
Topic Started
2
Topics Started
Topic Solutions
0
Solutions
Post Count
12
Posts
Post Kudos
0
Likes

Community Badges

No content to show

User Activity

I was informed a while ago by Shopify that this only works on Shopify Plusaccounts. This may or may not still be true.
The "needs to be a plus merchant" was the missing piece here. Thank you.
I still need help with this. The other reply is invalid (the example is from the documentation so the syntax isn't an issue).
I'm running ShopifyQL Queries through the GraphQL API on a live merchant store with the Advanced Shopify plan. The query returns a response but the data in the response is not correct.  Query: {shopifyqlQuery(query: "FROM orders SHOW sum(net_sales) A...
It would be better if I could structure the query to return a single number as a response. I only need the Month to Date sales, as a number or text. Additional returned information makes it more difficult to then parse the response.
Ok, now I'm getting results returned. But I can't figure out how to write a query that just gives me a single point of data (current month to date sales).
I'm finally getting an answer from the server, but no idea how to structure the query. { shopifyqlQuery(FROM orders SHOW sum(net_sales)) { # ShopifyqlResponse fields } }
Ok after a lot of experimentation, I actually figured out that what I want to do has nothing to do with reports. What I need to do is send a shopifyqlQuery to my shopify app with a Zapier Webhook Custom Request. My call gets rejected with error 400 w...
My goal is to create a Zap that fires every single day, creates and then gets a report of current month to date sales, and then posts this value in a Slack Channel. I already have the following setup:1. I have created a "Private app" in my Shopify Ad...
This widget could not be displayed.
This widget could not be displayed.