BatchOperations
Summarizes batch requests submitted to the Mailchimp API, including processing status and results.
Table Specific Information
Select
The add-in will use the Mailchimp API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client-side within the add-in.
- Id supports the '=' operator.
SELECT * FROM BatchOperations; SELECT * FROM BatchOperations where Id=2;
Columns
| Name | Type | Description |
| Id [KEY] | String | The unique identifier assigned to the batch request. |
| Status | String | The current processing status of the batch request.
The allowed values are pending, preprocessing, started, finalizing, finished. |
| TotalOperations | Integer | The total number of operations included in the batch request. Each paginated GET request counts as a separate operation. |
| FinishedOperations | Integer | The number of operations that have been completed, including both successful and failed requests. |
| ErroredOperations | Integer | The total number of operations within the batch that resulted in errors. |
| SubmittedAt | Datetime | The date and time when the batch request was received by the Mailchimp server, in ISO 8601 format. |
| CompletedAt | Datetime | The date and time when all operations in the batch request finished processing, in ISO 8601 format. |
| ResponseBodyUrl | String | The URL to download the gzipped archive containing the results of all operations in the batch. |
| Links | String | A list of related API links and schema references associated with the batch request. |