Anyway to upload an excel file via REST or SOAP and then utilized for import set??

[jestep_97]

I would like to be able to "push" a file from an individual server to ServiceNow instance and then have it processed as an import set. Any way to do this??

[jestep_97]

Yea, that was my first thought, but since these files can contain 10k rows it may not be the best way to process. Do you have any experience with load on the server and timing to process via json?

[reedwowens]

The json isn't an issue.   The 10K rows will be.   Do you need to know when they are done?

What type of control do you have with these files coming in?

Can you block and wait for processing to be done before looking/producing another?

This is getting long.   Call me on my cell 301.520.1421 and let's just work out the strategy then post the solution.   I'm on EST.

[jestep_97]

Yea, pretty much. I suggested to maybe send them one row at a time, but that may not be feasible as well.

Attachment makes the most sense currently and your idea will probably be the one we use. Thanks for that!

[reedwowens]

If you can block then you could do an async rest service to start the processing of the uploaded file, then periodically check with another call to see if it's done.   What you'll want to avoid is multiple imports at the same time.

To help others, mark the correct answer and any help responses from anyone.   Let's people use this as a usecase/learning for the future.

[josh_nerius]

Hi John,

One option is to use the functionality described under "Posting CSV or Excel Files Directly to an Import Set": Importing Data Using Import Sets - ServiceNow Wiki

This isn't exactly a REST call, but allows you to directly POST a file to an existing import set and automatically kick off the transformation.