Integration call

[BalkrishnaS]

Hi community,
I need to transfer data form one table to another table in servicenow. please tell me best approach, currently i am using schduled job but not getting result as per my need.

[M Iftikhar]

Hello @BalkrishnaS,

The best way to transfer data between tables in ServiceNow is by using a Transform Map instead of a scheduled job. It allows you to define clear field mappings, handle conditions, and schedule imports. 

Steps: 

• Create a Data Source (your source table). 
• Build a Transform Map to map source fields to target fields. 
• Run or schedule the transform. 

If you prefer real-time transfer, use Flow Designer to copy data on insert/update events. 

Docs & References: 

• Transform Maps – ServiceNow Docs 
• Flow Designer Overview – ServiceNow Docs 
• Create Record action 

 If my response helped, please mark it as the accepted solution so others can benefit as well.