EmailConsignments
Returns consignments and their corresponding emails.
Table Specific Information
Select
The connector uses the BigCommerce API to process WHERE clause conditions built with OrderId, which supports the '=' comparison.
For example, the following queries are processed server-side:
SELECT * FROM EmailConsignments WHERE OrderId = 123
Columns
| Name | Type | References | Description |
| OrderId | Integer |
Orders.Id | Identifier for the BigCommerce Order with which this transaction is associated. |
| RecipientEmail | String | The recipient email of the gift certificate. | |
| GiftCertificatesLineItemResources | String | URL where you can use a GET request to get the gift certificate line items for the order consignment. | |
| GiftCertificatesLineItemUrl | String | Path where you can use a GET request to get the gift certificate line items for the order consignment. |