Get Deleted Records from NetSuite

I am trying to pull deleted records from NetSuite for a variety of different tables, but I could not find any documentation on how to accomplish this.

Hi @nathan.lang1614377435484​,

It's been several years since I have been out of the Netsuite world so these are merely thoughts that hopefully spark an idea. I remember that you had to be explicit about going after deleted records in NetSuite, which leads me to believe that if you could do it with the NetSuite Query component, you would need to write custom SQL in Advanced mode. You would need to read up on the NetSuite documentation and pair that info with the Matillion NetSuite Query component documentation to have a go at it. I would probably have more info if I was still in that world and had access to NetSuite. Hopefully this helps in some way!

I have an update on this. It is not in the documentation but the NetSuite component has the ability to retrieve deleted records from NetSuite. There looks to be an issue with the validation of the component but it dose run successfully.