File is placed in SharePoint from there to import that file into ServiceNow and transform.

[Syed zabiullah]

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 

[Sohail Khilji]

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...

[Syed zabiullah]

Thank You @Sohail Khilji 
Do you have another approach using midserver ?  

If it so that would be helpful for me.

[Ajit Kumar2]

If you don't have license for spoke, try to automate using email integration and read attachment from email and transform data.

[Ravi Kand]

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.