Hello @channel Anyone with an idea how i can track...
# suitetalkapi
w
Hello @channel Anyone with an idea how i can track deleted records from the NetSuite UI using the REST record API. I'm having an incremental refresh kind of ETL pipeline for several NetSuite records "Tables", however for item fulfillments records for instance, deletes are a big challenge for a complete synchronization between source and destination. Any leads will be highly appreciated
m
There is a
deletedrecord
table you can query via SuiteQL
w
Hi @michoel, does it capture deleted records for all record types like salesorder, transferorder... etc even though this records do not share the same schema\
m
Yes, but only has metadata about the deleted record such a record type and id, time deleted, not the underlying record data
w
okaay great....getting the id is what i actually need...
let me try it then... Thank you soo much