Hi All
I am wanting to write to an SQL database where one of the columns is to contain an XML document
Lets suppose the XML document looks like this: -
<XML_Dcoument>
<Field1>1</Field1>
<Field2>2</Field2>
</XML_Document>
What I am actually getting in the table is this: -
<ProcessAR_COMMS_IN releaseID="9.2">
<ApplicationArea>
<Sender>
<LogicalID>infor.file.connectionpoint_ar_comms_in</LogicalID>
<ComponentID>External</ComponentID>
<ConfirmationCode>OnError</ConfirmationCode>
</Sender>
<CreationDateTime>2020-08-19T06:33:40.342Z</CreationDateTime>
<BODID>infor.file.connectionpoint_ar_comms_in:1597818820342:2af07047-4628-47d3-9dbb-5022e6d13c30</BODID>
</ApplicationArea>
<DataArea>
<Process>
<AccountingEntityID/>
<LocationID/>
<ActionCriteria>
<ActionExpression actionCode="Replace"/>
</ActionCriteria>
</Process>
<XML_Dcoument>
<Field1>1</Field1>
<Field2>2</Field2>
</XML_Document>
</DataArea>
</ProcessXML_Document>
So the BOD wrapper is being included.
Also, When testing the connection point, it seems that the <DataArea> tags have to be there or the testing throws an error complaining about the dataarea missing?
Anybody have any thoughts?
Thanks in advance