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

-O- · ‎09-26-2024

If the connection initiator is in your intranet (as you seem to suggest) a MID server is not needed.

It may be necessary to authorize the connection in some firewall, depending on organization network security setup and policies.

The MID server is needed for communication in the opposite direction: if the connection initiator is ServiceNow and it wants to connect to something in the intranet.

Other than that I don't think the MID server has a functionality to function as a REST proxy.

It does have web server functionality where it can be used to proxy events or ACC payloads to the instance, but - as far as I am aware of - not arbitrary REST messages.

RachidB · ‎09-26-2024

The app from which I need to retrieve information is in another organization, and we want to transfer the data from it to our ServiceNow instance.

-O- · ‎09-26-2024

Where will the program that does the transfer be? In the ServiceNow instance? In your intranet and what kind of application? In the 3rd party's intranet and what kind of application? Is there a VPN/tunnel between your intranet and the 3rd party's intranet?

RachidB · ‎09-27-2024

The app is not in our intranet, and we want to transfer data from the app to serviceNow, in this case we need MID Server to play the role as proxy because data is not accessible from the internet, I want just to explain to me the process how to implement it.
If you have idea about microservices, we have a gateway which responsible for interacting with external requests than it redirects the request to the right service (The gateway knows the right app, because all apps defined in the discovery service so the gateway can identify each app).
What I need from you is just an explanation how to implement the MID Server.

Thank you