Shopify Flow Report for Gift Card Amounts Used

[susiebaron]

I need a report that will show the order number, gift card number used to pay order, and the amount of the gift card they used. I am having trouble pulling all of that data in Flow. I know I can only see the last 4 characters of the gift card which is fine. I checked with Shopify for help and they told me to ask on here. 
Thanks for any help!

[paul_n]

Flow just released a "Get Gift Card data" action. It allows you to get a list of gift cards (not gift card products, but the gift cards the customers use).  The data you can access with it is documented here https://shopify.dev/docs/api/admin-graphql/2024-04/objects/GiftCard. The "Order" here is the order where it was purchased and not where it was used. So I don't think that works here, at least by itself.

I think for the data you want, you would need to query orders recently created (Get order data). But then you would need to call the above query to get the amount left on the gift cards, assuming you can get the ID of the gift card in the "Get order data" query. To combine these lists you would need to write some code to match up the IDs.

So to say the obvious thing, this will be quite hard to build from scratch.