How to import Several XMLs from SharePoint in 1 setup?

user019889

I have more than 5,000 XMLs files in sharepoint folder. I was able to link to DOMO with Sharepoint connector to fetch 1 XML as a test and it worked.

Is there a way to get all XMLs files into just one go through connector instead of re-creating the connector for each file separately?

GrantSmith

You'd need to utilize a scripting language like Python and the Domo and Sharepoint SDKs to programmatically query your folder, pull and parse the data and then ingest it into your Domo instance. There isn't a tutorial on how to do this specific use case but you could reference the documentation for each of the different SDKs.

Alternatively you could attempt to write a custom connector that would support importing multiple files. There's some documentation on this at https://developer.domo.com

Both options are going to be very technical.

GrantSmith

Currently this isn't possible with the direct Share point connector. You'd need to script this yourself to automatically ingest all of the files.

user019889

@GrantSmith can you please elaborate more on the script part? Is there an example or tutorial for it?

GrantSmith

You'd need to utilize a scripting language like Python and the Domo and Sharepoint SDKs to programmatically query your folder, pull and parse the data and then ingest it into your Domo instance. There isn't a tutorial on how to do this specific use case but you could reference the documentation for each of the different SDKs.

Alternatively you could attempt to write a custom connector that would support importing multiple files. There's some documentation on this at https://developer.domo.com

Both options are going to be very technical.