MID Server Guidance for Data Transfer via REST/SOAP APIs

RachidB
Tera Contributor

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

1 ACCEPTED SOLUTION

Kamal17
Kilo Sage

@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

10 REPLIES 10

So you want to deploy a MID server that connects you company's ServiceNow instance to a 3rd party's intranet, in the 3rd party's intranet? And the 3rd party agrees? 😲

B.t.w.

we want to transfer data from the app to serviceNow

is just about as useless piece of information in this context as it gets.

Kamal17
Kilo Sage

@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

jack5253
Tera Contributor

 

A MID server is not required if the connection initiator is located within your intranet, as you appear to propose.

Depending on the organization's network security configuration and policies, it might be required to allow the connection in some kind of firewall.

In the event that ServiceNow initiates a connection and wishes to establish a connection with an intranet resource, the MID server is required for communication in the opposite way.

Apart than that, I don't believe the MID server is capable of serving as a REST proxy. Geometry Dash 2.2 APK

 

bilalilyj
Kilo Contributor

A MID server is not required if the connection initiator is located within your intranet, as you appear to propose.

Depending on the organization's network security configuration and policies, it might be required to allow the connection in some kind of firewall.