Orders
Orders specify products for purchase, along with discounts, taxes, and other settings to apply to the purchase.
Table Specific Information
Select
The connector uses the Square API to process search criteria that refer to the Id column, while other filters are processed client side within the connector.
Retrieve all the orders in your Square account. Only orders that have been successfully charged are included in the response.
SELECT * FROM Orders
Specify multiple Ids in the WHERE clause using the IN operator:
SELECT * FROM Orders WHERE Id IN ('XKKB7LD30TpfNyW3e843ziklKh4vWEvweQyL5l4ESJLH3N2XXNBN8yqnf11qTrg3W3AelXC1kB', 'pxICohrEXPDtoUitiZhG1um5uhp5WI7CRMHknbuKpaj53PXfWNBN8yqnf11qTrg3W3AelXC1kB', '6j8avtXB5fIaPZ9H12beiZP7sCSiqguGhHpwmECsEaENswJnWNBN8yqnf11qTrg3W3AelXC1kB')
Columns
| Name | Type | Description |
| Id [KEY] | String | The order's unique ID |
| ReferenceId | String | A client specified identifier to associate an entity in another system with this order |
| LocationId | String | The Id of the location |
| CreatedAt | Datetime | The time when the location was created in RFC 3339 format |
| CustomerId | String | The ID of the customer associated with the order |
| Discounts | String | The list of all discounts associated with the order |
| LineItems | String | The line items included in the order |
| NetDueAmount | Integer | The amount of money in the smallest denomination of the currency indicated by currency |
| NetDueCurrency | String | The type of currency in ISO 4217 format |
| NetDiscountAmount | Integer | The amount of money in the smallest denomination of the currency indicated by currency |
| NetDiscountCurrency | String | The type of currency in ISO 4217 format |
| NetServiceChargeAmount | Integer | The amount of money in the smallest denomination of the currency indicated by currency |
| NetServiceChargeCurrency | String | The type of currency in ISO 4217 format |
| NetTaxAmount | Integer | The amount of money in the smallest denomination of the currency indicated by currency |
| NetTaxCurrency | String | The type of currency in ISO 4217 format |
| NetTipAmount | Integer | The amount of money in the smallest denomination of the currency indicated by currency |
| NetTipCurrency | String | The type of currency in ISO 4217 format |
| NetTotalAmount | Integer | The amount of money in the smallest denomination of the currency indicated by currency |
| NetTotalCurrency | String | The type of currency in ISO 4217 format |
| PricingAutoApplyDiscounts | Boolean | The option to determine whether pricing rule-based discounts are automatically applied to an order |
| SourceName | String | The name used to identify the place physical or digital that an order originates |
| State | String | The current state of the order |
| Taxes | String | The list of all taxes associated with the order |
| Tenders | String | The tenders that were used to pay for the order |
| TotalDiscountAmount | Integer | The amount of money, in the smallest denomination of the currency indicated by currency |
| TotalDiscountCurrency | String | The type of currency in ISO 4217 format |
| TotalAmount | Integer | The amount of money, in the smallest denomination of the currency indicated by currency |
| TotalCurrency | String | The type of currency in ISO 4217 format |
| ServiceChargeAmount | Integer | The amount of money, in the smallest denomination of the currency indicated by currency |
| ServiceChargeCurrency | String | The type of currency in ISO 4217 format |
| TaxAmount | Integer | The total amount of tax money to collect for the order |
| TaxCurrency | String | The type of currency, in ISO 4217 format |
| TipAmount | Integer | The total amount of tip money to collect for the order |
| TipCurrency | String | The type of currency, in ISO 4217 format |
| UpdatedAt | Datetime | The time when the location was updated, in RFC 3339 format |
| Version | Int64 | The version number, which is incremented each time an update is committed to the order |