SAP Open Connectors

Netsuite - How to Poll for Deleted Records

The standard polling configuration for the NetSuite connector will not capture deleted records. If accounting for deleted records is important to keeping a dataset up-to-date, then polling for those records is a viable option.

NetSuite's `get_deleted` functionality allows for querying for deleted records by their deleted date:

curl --request GET \
 --url 'http://{CE_ENV}/elements/api-v2/vendor-payments?where=deleted%3Dtrue%20AND%20deletedDate%3E'\''2019-05-04T18%3A17%3A02Z'\''' \
 --header 'accept: application/json' \
 --header 'authorization: User {USER_TOKEN}, Organization {ORG_TOKEN}, Connector {INSTANCE_TOKEN}'

To poll for deleted records of the vendor payments object, update the poller-configuration:

{
 "vendor-payments": {
 "url": "/hubs/erp/vendor-payments?where=deleted=true AND deletedDate>'${gmtDate:yyyy-MM-dd'T'HH:mm:ssXXX}'",
 "idField": "internalId",
 "filterByUpdatedDate": false,
 "datesConfiguration": {
 "updatedDateField": "deletdDate",
 "updatedDateFormat": "yyyy-MM-dd'T'HH:mm:ssXXX"
 }
 }
}

Note: If editing the poller-configuration to support deleted records in the SAP Open Connectors UI, it requires editing the raw JSON for the poller.