Can I export a list of records from a table in ServiceNow as an Excel file to a SharePoint folder

[matthew_hughes]

We've been given a requirement of automating a process that involves exporting all of the records within a table and exporting them as an Excel file to a folder within SharePoint. This will be used to backup any data that we have for our particular table before we make any changes. We are looking to try and automate this to save time.

I thought I'd ask is it possible to take an export of an Excel file and automatically put it in a folder within SharePoint?

[Dr Atul G- LNG]

Hi @matthew_hughes 

I read some where in community and it is do able but 

1. How many times you want to run this?

2. Is it good to have manual or automation provide more value.

3. Need a connection of SN and Share point and need full authentication.

Have a look here

https://www.servicenow.com/community/developer-forum/can-you-use-export-set-to-export-data-to-a-shar...

[Ankur Bawiskar]

@matthew_hughes 

no OOB solution is present for this.

The best way I could suggest is this

1) Use Export set feature which pushes the excel file to mid server location and you can also schedule it

Export sets 

2) then ask SharePoint team to pick the file from that mid server location

OR

You will have to use custom solution using export set and write mid server script include (java+javascript) to push to sharepoint. This I won't recommend due to heavy code maintenance.

If my response helped please mark it correct and close the thread so that it benefits future readers.