EcommerceSyncErrors
Get errors from previously processed sync messages.
Table Specific Information
Because sync messages are processed asynchronously, problems with processing are not surfaced at the time of submission. Instead, you can use the sync errors endpoint to retrieve all errors related to the processing of ecommerce data.
SELECT
When selecting sync errors, they can only be filtered by the AppId and only one AppId at a time. Otherwise they can be selected without a filter, which will cause all settings in your HubSpot account to be listed. For example:
SELECT * FROM EcommerceSyncErrors
SELECT * FROM EcommerceSyncErrors WHERE AppId = '123456'
Columns
Name | Type | References | Description |
PortalId | Long | The Id of the portal for this sync error. | |
ObjectType | String | The specific object type. | |
IntegratorObjectId | String | The ID, from your system, of the object that is being created or updated. | |
ChangeOccurredTimestamp | Datetime | The timestamp of the last change occurred. | |
ErrorTimestamp | Datetime | The timestamp of the error when occurred. | |
Type | String | The type of the error which classifies the error. | |
Details | String | Detailed description of the error. | |
Status | String | Status of the sync error. | |
AppId | String | The app ID in which the error occurred. |