There doesn’t seem to be a field called
Payment Reference that can easily be retrieved using our Pull from Shopify step. I do know that field does exist when exporting your orders, so we’ll have to find a workaround.
When you import your orders, select include
all columns. There should be a column called
Order: Checkout Id. Does that match the value you’re looking for? It likely won’t include the
You can also pull in your orders to get the
Order: Id and use the Enrich with an API step and insert those values into your URL using the column name and curly brackets. This will target the transaction endpoint.
You’ll need to generate an API key by creating a new private app. Insert those in the
Authentication fields and select
Show Updated Results. You can then set
transactions as the
Top Level Key.
We can use the Expand JSON step to flatten the
receipt column. Once that’s been flattened you can select
receipt > charges > data to be expanded into new rows.
You should now have a column called
Hopefully, that’s the value you’re looking for!