Writing data to an SQL database

Legacy Contributor

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