How can I see the payment reference id we supply square through the API in our transactions reports?

[joejetta]

We use the API to process payments for purchases on our website.  When we post the payment we are supplying the reference_id with the in house identifier so we can link transactions back to our site's order information.  When I go into the square dashboard to view the transactions I can't see how we can view\download that information.  Where can I find it?

[joejetta]

When I download the transactions report I can see a Customer Reference ID column but it is empty.

[ashc]

Hi @joejetta!

Unfortunately reference_id is not available in the CSV transactions report. The reports in the dashboard are not very API-friendly, a lot of times fields are missing and it’s not really recommended to use both the reports and APIs.

If you need to look up the reference_id, you should call the API itself via ListPayments or RetrievePayment for a single payment. This will return the reference_id you’re looking for.