thread How can I see the payment reference id we supply square through the API in our transactions reports? in Archived Discussions (Read Only)

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

joejetta — Thu, 13 Feb 2020 15:50:20 GMT

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?

Re: How can I see the payment reference id we supply square through the API in our transactions repo

joejetta — Thu, 13 Feb 2020 15:53:35 GMT

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

Re: How can I see the payment reference id we supply square through the API in our transactions repo

ashc — Wed, 19 Feb 2020 12:19:53 GMT

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.