Skip to content

    • Connectors

    Connectors

    How to import Several XMLs from SharePoint in 1 setup?

    Member
    in Connectors

    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?

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Best Answer

    • Coach
      Answer ✓

      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.

      **Was this post helpful? Click Agree or Like below**
      **Did this solve your problem? Accept it as a solution!**

    Answers

    • Coach

      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.

      **Was this post helpful? Click Agree or Like below**
      **Did this solve your problem? Accept it as a solution!**
    • Member

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

    • Coach
      Answer ✓

      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.

      **Was this post helpful? Click Agree or Like below**
      **Did this solve your problem? Accept it as a solution!**

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Quick Links

    Categories