Error: Purchase Order Endpoint Skip
Issue
The PURCHASE_ORDER table is missing from the destination. The following warning appears in Fivetran:
purchase_order Endpoint Skip. We are skipping the purchase_order endpoint because it returns a 400 response error, indicating that the search field [updatedDate] is not found or configured for the entity. Please contact Deposco support team to resolve this issue.
Environment
Connector: Deposco
Resolution
To resolve this issue:
- Contact Deposco Support and ask them to enable
updatedDateas a searchable field for theOrderentity, also known asOrder Header. - After Deposco confirms the change, go to your Deposco connection page in Fivetran.
- Select the Schema tab.
- Find the
PURCHASE_ORDERtable, then click Re-sync. - In the confirmation pop-up window, click Start re-sync.
Cause
We use updatedDate to incrementally sync purchase order records. When the field is unavailable for search, the Deposco API returns a 400 response, and we skip the purchase_order endpoint.