question Delta Records pull from ServiceNow Table API in Member Feedback forum

Delta Records pull from ServiceNow Table API

namrataD — Sat, 14 Sep 2024 10:50:44 GMT

Hello I have requirement to pull Service Now Table API Data

e.g. sn_hr_core_case

sn_hr_core_profile

sn_hr_core benefits etc.

What is sys_created_on and sys_updated_on fields ?

9/14 8 AM pulled 1000 records

9/14 11 AM want to pull only changed records or newly inserted records compared to prev load.

Using sys_updated_on data can we pull the Delta Records.

Can you guide us on above query.

Gangadhar Ravi — Sat, 14 Sep 2024 14:44:32 GMT

HI,

You can use table API and add your desired encoded query to get the data.

All you need to do is add filters, copy query and then paste it into REST API explorer to see data is returned or not.

Once this is done, you can utilize this API anywhere

namrataD — Sun, 15 Sep 2024 15:30:47 GMT

Hello Thanks for your reply.

I have already queries the API in POSTMAN and getting result.

But could you help me to get the below info .

FOr below tables want to pull only changed records or newly inserted records compared to prev load.

sn_hr_core_case

sn_hr_core_profile

sn_hr_core benefits etc

Using sys_updated_on data can we pull the Delta / incremental Records.