Forum Discussion

TomBI's avatar
TomBI
Frequent Visitor
1 year ago
Solved

Extract XML from a Sharepoint site

Hi,    I want to extract an XML file which is located on a Sharepoint site. I know how to extract Excel or CSV files from a Sharepoint site (through web or a Sharepoint folder), and I've found docu...
Need Help
  • christinepayton's avatar
    christinepayton
    1 year ago

    Yes, is it a single file? What I like to do for single files is to connect locally first using the XML connector, then just change the path for the file in the source settings to SharePoint. Getting the right path is the tricky bit, you can't use the "copy link" option - you need to go into the file details to get it. I did a tutorial on how to do it here (iirc the example was JSON but the same thing works for XML): https://youtu.be/2HZ8l23RXnc

christinepayton's avatar
christinepayton
Most Valuable Professional
1 year ago

Yes, is it a single file? What I like to do for single files is to connect locally first using the XML connector, then just change the path for the file in the source settings to SharePoint. Getting the right path is the tricky bit, you can't use the "copy link" option - you need to go into the file details to get it. I did a tutorial on how to do it here (iirc the example was JSON but the same thing works for XML): https://youtu.be/2HZ8l23RXnc