How to import data into servicenow table from salesforce ?

luqman2
Giga Contributor

Hi All,

I need to import data into servicenow table using data source. I got the response payload from REST message GET method, data is basically Account records of Salesforce which is in JSON format. Now I want this data to be imported in servicenow table(incident). Can anyone please guide me in this scenario?

 

 

1 ACCEPTED SOLUTION

Sandeep Rajput
Tera Patron
Tera Patron

@luqman2 With a combination of Scripted Rest API https://docs.servicenow.com/bundle/tokyo-application-development/page/integrate/custom-web-services/... and ImportSet API https://developer.servicenow.com/dev.do#!/reference/api/tokyo/rest/c_ImportSetAPI you can integrate your external source within ServiceNow and import data in your staging tables first and then transfer them to main tables via transform maps.

 

Hope this helps.

View solution in original post

4 REPLIES 4

Sandeep Rajput
Tera Patron
Tera Patron

@luqman2 With a combination of Scripted Rest API https://docs.servicenow.com/bundle/tokyo-application-development/page/integrate/custom-web-services/... and ImportSet API https://developer.servicenow.com/dev.do#!/reference/api/tokyo/rest/c_ImportSetAPI you can integrate your external source within ServiceNow and import data in your staging tables first and then transfer them to main tables via transform maps.

 

Hope this helps.

Thanks Sandeep, this gave me idea to proceed ahead. I actually used a schedule job to trigger the REST message and with the response payload I created records in staging table then using Transform map I mapped the records to incident table.

Community Alums
Not applicable

Hi Luqman,

 

Following videos will help you build integration in ServiceNow from scratch. In this video, it shows how to use REST API to being create/update/get data in ServiceNow. Please let me know if you have further questions.

 

Please mark this comment as Correct Answer/Helpful if it helped you.

 

Cheers,

Hardit Singh

 

 

 

Mathieu Lepoutr
Mega Guru

Hello Luqman

 

To import ACCOUNTS of SF to SNOW, you can use webhooks, native integrations, of 3th party tools.


It's my understanding, Exalate would be perfect for this use-case, as Accounts are an out-of-the-box functionality that it provides. Since it is decentralized, both sides can exactly decide what gets send and what not.

 

SF to SNOW is not an easy integration, but Exalate makes the process really smooth.

I suggest you have a look