MID Server Guidance for Data Transfer via REST/SOAP APIs

RachidB · ‎09-26-2024

Hey Community,

I hope your doing well,

I have a requirement to transfer data from our local network which is not accesible via internet to ServiceNow using REST or SOAP APIs, and I plan to use a MID Server for this. Could you confirm if the MID Server supports API calls via REST or SOAP. I don't have a very clear understanding of the MID Server, but I assume I will need to write a script to retrieve the data, I hope you confirm that please. Any guidance on this would be greatly appreciated.

Thank you

Kamal17 · ‎10-01-2024

@RachidB

For your requirement, since your local app cannot reach internet options are limited. I dealt with similar scenario in the past and used following approach to transfer the data to ServiceNow from local app.

1. Setup a MID server in the local network where the application is hosted.

2. Generate a CSV/Excel /XML file with the necessary data.

3. Transfer the file into one of the MID server folders.

4. You can do the transfer from MID server to ServiceNow in two ways.

Option 1: (Method I used) Create a MID server command probe to execute a powershell command in MID server and copies the file from MID server to ServiceNow. (refer to the section "Attaching Files Directly using the Attachment API or MID Command Probes" in this article for more details)

Option 2: Run a scheduled script in MID server and call attachment API in ServiceNow to push the file from MID server to ServiceNow. Once file is attached to a record in SN, then you can import the data from the file. (refer to this article for more details)

Hope you find this information useful.

PS: Hit "Correct", "Helpful" or "Like" depending on the impact of the response.

Regards,

Kamal S

View solution in original post

LeenaMocey · ‎11-27-2024

the 3rd party's intranet and what kind of application?