OrderEntries
A list of OrderEntries that fit the query conditions.
Table Specific Information
Select
The add-in uses the Square API to filter the results by the following columns and operators while the rest of the filter is executed client-side within the add-in.
- LocationId supports the following operators: =, IN.
- CreatedAt supports the following operators: =, >=, <=, >, <.
- UpdatedAt supports the following operators: =, >=, <=, >, <.
Retrieve all order entries found in your Square account:
SELECT * FROM OrderEntries
Columns
| Name | Type | Description |
| LocationId | String | The Id of the location. |
| CreatedAt | Datetime | Created timestamp. |
| LineItems | String | Order Line Items. |
| OrderId | String | The Id of the Order. |
| Source | String | The origination details of the order. |
| UpdatedAt | Datetime | The time when the location was updated, in RFC 3339 format |
| Version | Integer | The version number, which is incremented each time an update is committed to the order. |