Import a file to Servicenow from MID Server

Sathwik1 · ‎11-07-2020

I need to import a csv file from MID Server daily... Daily once the 3rd party will place a csv file in the MID Server...when ever they place I need to place that file in our MID Server...

Can anyone help me with this? I referred previous community questions but I didn't get complete clarity...so please help me to understand clearly

Ankur Bawiskar · ‎11-08-2020

@Sathwik

Please find responses below

Question 1: Regarding First Script [Background Script ]

Should I run this in our instance is enough ? (or) should I login to Server in which MID Server is located and there I need to login to my developer instance and run?

- you should run this from your instance which is configured with the mid server

Question 2 : Regarding Business rule..

By this business rule..where my CSV file will get stored? It needs to attach to a import table in our instance

- you can attach it to the data source which you require to be transformed

- remember you need to trigger the transform as well once file gets attached to data source

Question 3 : This Process needs to run daily at certain time..

- create a schedule job which runs daily and uses the script shared above

Regards
Ankur

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

View solution in original post

RobertM2 · ‎08-03-2021

Thanks for your quick reply! I am not seeing any new records in the ecc_queue related to the import so I don't think the file is being imported. I do see nearly 1000 of the error messages above on each execution:

SOAP Msg Outbound - SOAPMessageClient : Exception initializing Soap Message functionAttachment Creator.insert Message: Unable to find SOAP Message Record with Name: Attachment Creator: no thrown error

Ankur Bawiskar · ‎08-03-2021

then try to check that first

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

RobertM2 · ‎08-03-2021

I am new to SOAP messages. Does this mean I need to create one for Attachments? If so, what would be the name, WSDL, and is it okay to have this scoped or must it be global?

RobertM2 · ‎08-03-2021

Okay I guess I missed a step in creating the ECC queue record. I was able to do that successfully. The output shows processed and input shows ready.

However, when I run the scheduled script, I am still getting the SOAP Msg error above. Not sure what that means or how I resolve that.

Thoughts?