Extract XML from a Sharepoint site

[TomBI]

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 documentation on how to extract a local XML file. I haven't found any information on a combination of the two though. 

Is it possible to extract an XML file from a Sharepoint site? It could be either using a folder or by extracting the file directly. 

Thanks! 

[christinepayton · Accepted solution]

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