How to import excel file data from third party app to servicenow?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-05-2025 06:19 AM - edited ‎05-05-2025 06:21 AM
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-05-2025 08:09 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-05-2025 08:18 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-05-2025 09:32 AM
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