New field in Square connector: payment.offline_payment_details.client_created_at
CompletedConnector name:
Square
Table name:
payment
Column to add:
offline_payment_details.client_created_at
API documentation link:
https://developer.squareup.com/reference/square/payments-api/get-payment
Additional details:
When an order is captured in offline mode, whether due to internet issues at the device, or server issues on Square's side, the order.created_at field represents when Square receives that order, NOT when the device captures the order at location. Once connectivity is restored, all offline orders are sent as a batch to Square's server, and the order.created_at timestmap will be identical for all orders in that batch, even if those orders were created hours or days prior.
Previously you could use tender.created_at to identify the true timestamp for an order captured in offline mode, but due to a change in the behavior on Square's side, the only way to identify when an order is actually captured locally is through payment.offline_payment_details.client_created_at. payment.offline_payment_details.client_created_at.
-
Official comment
Hi Chris, this is live. We added two columns to the payment table: is_offline_payment and offline_payment_details_client_created_at. The second one is the device capture time you were after. Because they’re new columns, run a table resync on payment to backfill history. There’s a changelog entry too. Sorry for the wait, and thanks for the clear writeup.
Best,
Vicky -
Thanks Vicky! I still had a support ticket open for this as well so I was aware of the update. Working on a full resync right now.
Please sign in to leave a comment.
Comments
2 comments