File is placed in SharePoint from there to import that file into ServiceNow and transform.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-11-2024 04:05 AM
I have a requirement is to excel file from SharePoint location, import that excel to ServiceNow and transform the excel using transform map, currently we keep doing this manually, download the file, upload it to data source and transform it, so we want to automate the process by scheduling the import from SharePoint. Anyone suggest me.
Any option:
1.midserver
2.Integration
- Labels:
-
Architect
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-11-2024 04:14 AM
Hi @Syed zabiullah ,
There is a spoke available for SharePoint which can move files from share point to ServiceNow on scheduled basis ( or you can make your flow do that on timely manner).
Once the file is in ServiceNow you can create a schedule job that triggers a DataSource with new excel and execute the transform map.
i hope this helps...
☑️ Please mark responses as HELPFUL or ACCEPT SOLUTION to assist future users in finding the right solution....
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-11-2024 05:37 AM
Thank You @Sohail Khilji
Do you have another approach using midserver ?
If it so that would be helpful for me.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-26-2024 11:29 PM
If you don't have license for spoke, try to automate using email integration and read attachment from email and transform data.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-08-2024 12:11 AM
Dear friends,
I have established connection between ServiceNow to SharePoint.
Now, my requirement is:
HR Profile > Employee Documents > New > Upload > Submit
On submitting the form, the attached document should be moved to Sharepoint folders.
What is the process or configuration to achieve this functionality.
Thanks in advance.