Hi,

We do something on similar lines.

What we do it:

1) put data from Sharepoint to MID Server on one location.

2) We have File import in place from MID Server to servicenow in transform maps.

3) We import the raw data nd them fine tune it and push to target table.

Option two:

We have a rest api as well in place for one specific use case to pull data from Sharepoint which brings data to same import set table.

Thanks,
Ashutosh