How to remove records which arent coming in payload? what approach to take?

[surya123]

Hi All,

I am working on an integration with 3rd party system with servicenow which brings in data and we store it in a custom table in ServiceNow. Its a full payload that we will receive. So, based on that we insert into custom table. IN future, some records in 3rd party system will be deleted or removed, we need to remove it in SN aswell. Whats the best way to do it?

[Sohail Khilji]

Yes this is even possible which will required validation on the staging table.

[Ankur Bawiskar]

@surya123 

you will have to expose an API to 3rd party which they can consume and they can send details of which records are deleted in their system

Based on that the API will delete the data in ServiceNow

If my response helped please mark it correct and close the thread so that it benefits future readers.

[surya123]

Hi Ankur, 

Thanks for your response. The payload is a full payload always. Isnt there a way to identify the deleted records i.e the missings one in payload we receive