How to retrieve an excel sheet from Sharepoint/box into servicenow table?

[Vishnu V Reddy]

We need to retrieve an excel/csv from Sharepoint/box and import it into a cmdb using import set. I want to know how can we get the data/excel into servicenow. Please help.

[atilioandres]

Hi Vishnu,

Is the excel/csv a file that has been exported from Sharepoint or box? If so then using the import feature in ServiceNow will get it to an import set table and then a transform map can move it into the CMDB table you require.

If this is something you need to automate you could take a look at Perspectium Replicator and setup a real time replication of excel or CSV files into ServiceNow.

ReplicatorDemo - YouTube

[Vishnu V Reddy]

Hey Atilio,

Thanks for the response. Basically we want to retrieve the file directly to servicenow through sharepoin/box. Import table part is simple, but firstly we should get the data in from outside in excel format. That excel file is located in sharepoint/box.

[miked_jones]

You should be able to do this with a Data Source and a Scheduled Import

Create a Data Source to actually do the work of pulling in the file and importing: http://wiki.servicenow.com/index.php?title=Data_Sources#gsc.tab=0

Then create a Schedule Import to call the Data Source at whatever interval you need: http://http://wiki.servicenow.com/index.php?title=Scheduling_Data_Imports#gsc.tab=0

I haven't tried from Sharepoint specifically, but this works for "Drop box" like locations, etc.

[Vishnu V Reddy]

Can we import files from BOX to servicenow through FTP data source? Is there any other way to import from BOX?