How to import excel file data from third party app to servicenow?

Rudranarayan P2
Tera Contributor

We need to import excel file into servicenow from a third party tool once in a week. Then transform the data in to servicenow table using transform map.

Can any one help with the solution?

3 REPLIES 3

PraveenkumaM
Tera Contributor

@Rudranarayan P2 

 

Hope you are well.

 

If the file can be accessed via FTP/HTTP, then you can create a scheduled import with the required execution frequency and link with a data source (Type: File). Add a Transform map as required.

 

If the file is accessible only via API, then you can go with REST integration and schedule it.

 

Hope this gives you a starting point. Let me know if any further help needed as you progress.

 

Regards,

Praveen

Rudranarayan P2
Tera Contributor

Thanks Praveen for your quick response.

 

If I need to use rest api, can you mention the solution in few steps? I.e whether I need to create Rest message and GET the file or the third party app can send the file to SNOW etc.

PraveenkumaM
Tera Contributor

@Rudranarayan P2 

 

It is better to make an API call to the 3rd party app rather than allowing write access to the 3rd party app within ServiceNow.

 

You can gather the required details such as API Endpoint, Authentication mechanism with required credentials, and configure an outbound REST message. Then, create an action to call the REST message. This action can then be called within a flow with the trigger set to scheduled and executed at regular intervals.

 

Regards,

Praveen