SharePoint Integration

Re: Copied Infopath form looks like HTML instead of XML

Hilary Stoupa — Thu, 10 Aug 2017 23:18:32 GMT

I'm glad you posted this, now we have the info here, where hopefully others will be able to find it. :)

Re: Copied Infopath form looks like HTML instead of XML

CCBSMF — Thu, 10 Aug 2017 15:41:38 GMT

You beat me to it! I was just about to log in and give the answer! :) Thanks Hilary.

Re: Copied Infopath form looks like HTML instead of XML

Hilary Stoupa — Thu, 10 Aug 2017 15:31:21 GMT

Hey - I think I've run into this before downloading XML from SharePoint in C# code. If I recall correctly, adding the parameter ?NoRedirect=true to the end of the URL solved the issue - maybe give that a try?

Re: Copied Infopath form looks like HTML instead of XML

CCBSMF — Thu, 10 Aug 2017 03:34:22 GMT

Hi Shaun. Did you ever figure out an answer to this? I'm running into the same problem using SSIS to move the files from sharepoint to an archive. :(

Shaun789:
I am using some automation software that makes components available to aggregate and process data. One of the components is a Web DAV copy component, which copies files from say, a Sharepoint document library to the automation server. From there, it can process these files using other components. The WebDAV copy component works well to copy Excel files, and text files from Sharepoint. However, it does not work well to copy Infopath XML files.

The Infopath forms I am trying to copy are a pretty standard implementation of an XSN tied to a Sharepoint document library, where the user picks a New form, and saves it as an XML in the document library. Then I want to copy these XML files and process the data.

When the WebDAV component copies the file to the automation server, I can open the file in a notepad, and it starts with an <HTML> tag instead of an XML header. Going through the copied <HTML> code, I don't see any of the XML structure. In scanning the HTML code, it looks mostly like CSS and Javascript.

If I use the Sharepoint interface to copy the same XML file, I can open it in a notepad and see the expected XML data, instead of the HTML.

Is there some other way of copying an Infopath file from Sharepoint (such as SOAP) to get the actual XML instead of HTML? Or some box to tick in the Infopath form design that I am missing?

I am very familiar with promoting Infopath fields as Sharepoint columns, and this works well with the automation software. However, I would like to use repeating tables in Infopath, which seems to be incompatible with promoting Infopath fields as Sharepoint columns due to the unknown number of rows in the table.

Thanks for your help!

Shaun

Copied Infopath form looks like HTML instead of XML

Shaun789 — Sun, 07 Feb 2016 18:34:53 GMT

I am using some automation software that makes components available to aggregate and process data. One of the components is a Web DAV copy component, which copies files from say, a Sharepoint document library to the automation server. From there, it can process these files using other components. The WebDAV copy component works well to copy Excel files, and text files from Sharepoint. However, it does not work well to copy Infopath XML files.

The Infopath forms I am trying to copy are a pretty standard implementation of an XSN tied to a Sharepoint document library, where the user picks a New form, and saves it as an XML in the document library. Then I want to copy these XML files and process the data.

When the WebDAV component copies the file to the automation server, I can open the file in a notepad, and it starts with an <HTML> tag instead of an XML header. Going through the copied <HTML> code, I don't see any of the XML structure. In scanning the HTML code, it looks mostly like CSS and Javascript.

If I use the Sharepoint interface to copy the same XML file, I can open it in a notepad and see the expected XML data, instead of the HTML.

Is there some other way of copying an Infopath file from Sharepoint (such as SOAP) to get the actual XML instead of HTML? Or some box to tick in the Infopath form design that I am missing?

I am very familiar with promoting Infopath fields as Sharepoint columns, and this works well with the automation software. However, I would like to use repeating tables in Infopath, which seems to be incompatible with promoting Infopath fields as Sharepoint columns due to the unknown number of rows in the table.

Thanks for your help!

Shaun