Wanting to Import data using external REST service on a schedule using Import Set / Transform Map

[james_whitt]

We're running into an issue where right now we are using Scheduled Jobs to kick off a script include that uses a MID Server to connect to a 3rd party system for importing data into a ServiceNow table directly. What we want to do is use Import Sets and Transform maps also, so that we aren't pulling for 3rd part software using REST and entering data directly into the tables using the script.

With that said, we are stuck on figuring out how exactly how to "Load Data" into the import set and then kicking off then "Run Transform". We know the transform map needs to be asynchronous and that if we were using odbc, file, xml, we would go the Import Sources route, but we can't. Have to be ServiceNow scheduled import using MID server to consume the REST services.

Any help would be appreciated.

[tantony]

Thanks Statcey,I will be using Basic authentication

[ChrisBurks]

Q-In my situation what is the advantage of making the REST call through a MID server?

A.   In this case there probably isn't too much of an advantage using the MID Server other than security. From my experience MID Servers are used mostly for Discovery, RunBook automation, Security, and things that need to be done inside the company's firewall.

Q-Where will the MID server be hosted?

A. Usually anywhere accessible inside your company's firewall. The MID Server is actually a piece of software that installed on a computer or even on a VM. You can run multiple MID Servers on one machine or on different machines. Just be sure it can handle the load. Specs can be found here: system requirements:MID Server - ServiceNow Wiki

Load balancing: Deploying Multiple MID Servers - ServiceNow Wiki

Q-Can I use any existing MID server for my purpose or do I have to   create a new one ?

A. You can do either. Again just make sure it can handle the load for each operation it's doing.

[tantony]

Thanks.

[tantony]

I wish I could mark Chris Burks answer as correct one since it worked for me.I had to use a MID server.I used OOB import table (Location) and a synchronous mode import set for transforming to target table

[ChrisBurks]

Tessy Antony,

I'm just glad I could help out.

Thanks