How to identify only modified records from table ?

udhayakumar — Thu, 25 Oct 2018 04:11:06 GMT

Hi,

Anyone can help me out here. I'm integrating Method API to my web application. In my web application I can create, update & delete a contact. After that these contacts were pushed to Method CRM. There again I can create, update, delete these.

Now I want to sync back with these updates to my DB. So I need to identify which all records have been modified on COntacts table in Method CRM. I pulled list of columns from Contacts table there I can see Cretaed Date column but not modifed date. So always I can't pull all the datas and can't update my DB thats not Ideal one.

I got AuditTrail table but there also some limitations. So How I can get only modified records / rows from contacts table in method CRM.

Thanks,

Udhaya

Search results by user ID 19021

How to identify only modified records from table ?