Shopify Flow: using Get Product Data, exclude null values from published_at search query

Shopify Plus
1

I have an advanced query on “Get Product Data” that looks like this.

published_at:* AND published_at:<='{{ scheduledAt }}' AND published_at:>'{{ scheduledAt | date_minus: "2 week" }}'

The search query syntax docs state that I can exclude null values with the * wildcard. Whether I include the published_at:* or not, I still am retrieving null values.

Any way I can only search for non-null values in my query?

1 Like
2

Interesting, have you tried running that query in the graphql app? I used the field:* syntax recently for another query, I believe it was for tags, and it worked.

1 Like
3

The wildcard syntax works in the graphql app. Actually what I think might be happening is that published_at is not supported because Shopify Flow is using an older version of the GraphQL Admin API. It looks like published_at was added as part of the 2024-07 (Latest) version. Not sure how to force Flow to use the latest API version.

1 Like
4

Oh yeah flow uses 2024-01 currently. There’s no way to change that. It will likely be upgraded some time soon.

1 Like