CSV file from MIDserver to ServiceNow instance

cnavr_work
Kilo Expert

Hi,

I need to pull the CSV file located on the MID server to the specific table in the ServiceNow.

Any suggestions?

Thanks

Ctirad

1 ACCEPTED SOLUTION

Hi,


finally I used an asset from ServiceNow Share which does exactly what I needed.


There were only some small changes required for running it on Istanbul version.


But after the changes it is working perfectly.



Ctirad


View solution in original post

19 REPLIES 19

Hi Ctirad,



I didn't get the point. The file is stored on mid server so you will have to do something to get connected to servicenow instance from mid server in order to upload that file to particular table record.


You will require a mid server hosted on some machine which keeps the mid server always up. This will involve cost depending where you are hosting this virtual machine and installing the mid server on that machine should not cost anything. Not sure about the pricing information. Just posted as per my experience.



Regards


Ankur


Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

Hi Ankur,


the customer has secure network where he wants to connect to the instance


only by via the mid server. He also insists that only mid server regularly


downloads CSV file to the ServiceNow instance.


Regards


Ctirad



On Fri, Jun 9, 2017 at 11:11 AM, bawiskar <community-no-reply@servicenow.com


Hi Ctirad,



yes mid server will be customer's internal network for security purpose.


But I didn't get the point "only mid server regularly downloads CSV file to the ServiceNow instance."



in your question you have mentioned that you need to get csv file from mid server to service now instance and here you are mentioning that mid server should regularly download csv file to servicenow instance.



Can you be clear on the requirement? which is required to you?


It can be either of these 2


a) MID Server downloads csv file from some servicenow table record periodically


b) MID Server has some csv file and it has to be attached to servicenow table record periodically.



Regards


Ankur


Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

Hi Ankur,


B is our situation.


The customer will have daily update of CSV file located on mid server and


we need to upload the data from CSV to ServiceNow instance (specific table).


regards


Ctirad



On Fri, Jun 9, 2017 at 2:42 PM, bawiskar <community-no-reply@servicenow.com>


Hi Ctirad,



Got the point. So for this case I have already provided the 2 approaches which can be implemented further.



Regards


Ankur


Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader