EventOrders
Returns data from the EventOrders table.
Table Specific Information
SELECT
The Cvent API allows you to filter by certain fields when querying for data. The following fields can be filtered by the API:
- Id supports =,!=
- EventId supports =,!=
- AttendeeId supports =,!=
- Type supports =,!=
- Created supports =,!=,>,<,>=,<=
- LastModified supports =,!=,>,<,>=,<=
All other filters are handled client-side.
The following is an example of a SELECT statement:
SELECT * FROM EventOrders WHERE EventId='3a366031-7541-4a44-9fde-bc0f81d3e940'
Columns
| Name | Type | References | Description |
| Id | String | The Id of the EventOrders table. | |
| EventId | String | The EventId of the EventOrders table. | |
| AttendeeId | String | The AttendeeId of the EventOrders table. | |
| Number | String | The Number of the EventOrders table. | |
| Cancelled | Boolean | The Cancelled of the EventOrders table. | |
| Type | String | The Type of the EventOrders table. | |
| InvoiceNumber | String | The InvoiceNumber of the EventOrders table. | |
| AmountOrdered | Decimal | The AmountOrdered of the EventOrders table. | |
| AmountPaid | Decimal | The AmountPaid of the EventOrders table. | |
| AmountDue | Decimal | The AmountDue of the EventOrders table. | |
| DiscountName | String | The DiscountName of the EventOrders table. | |
| DiscountCode | String | The DiscountCode of the EventOrders table. | |
| DiscountType | String | The DiscountType of the EventOrders table. | |
| DiscountValue | String | The DiscountValue of the EventOrders table. | |
| PaymentMethod | String | The PaymentMethod of the EventOrders table. | |
| ReferenceNumber | String | The ReferenceNumber of the EventOrders table. | |
| Created | Datetime | The Created of the EventOrders table. | |
| CreatedBy | String | The CreatedBy of the EventOrders table. | |
| LastModified | Datetime | The LastModified of the EventOrders table. | |
| LastModifiedBy | String | The LastModifiedBy of the EventOrders table. |