28
Views
7
Comments
XML Records - list of integers
Question

I am creating an XML output which in a subgroup has a list of integers. I would like the output to be like this.

<root>
  <employees>
    <employee>
      <name>alan</name>
      <AllowedList>
        <Allowed>1</Allowed>
        <Allowed>3</Allowed>
        <Allowed>7</Allowed>
      </AllowedList>

    </employee>
    <employee>
      <name>bob</name>
<AllowedList>
<Allowed>2</Allowed>
<Allowed>4</Allowed>
<Allowed>7</Allowed>
</AllowedList>
    </employee>
  </employees>
</root>

But instead I'm getting

      <AllowedList>
<Allowed><Value>1</Value></Allowed>
<Allowed><Value>3</Value></Allowed>
<Allowed><Value>7</Value></Allowed>
      </AllowedList>

I've seen the recordlistmode, and when I set that to "S" instead of "C" then it drops off the "employees" name and the "AllowedList" name, but doesn't get rid of the "Value".

Any ideas.

2021-05-18 02-27-17
Manish Gupta
Champion

Hello Alan

Are you trying with the Component? https://www.outsystems.com/forge/Component_Documentation.aspx?ProjectId=153&ProjectName=xml-records 


Please check its Demo and Integers are getting exported without


In case you are using the same and facing issues, please share the OML if possible. 

2017-04-10 03-24-23
Alan Telford(Maxtel)

Hi. Yes I am using the XmlRecords forge component.
I have created a sample component.
I need to READ the default xml (which i can do correctly.)
But then at another stage I also need to modify and send back the XML.

The XML that I write back out is correct apart from <VisaConditions>.

The Input is of structure:

        <VisaConditions>
          <VisaCondition>1111</VisaCondition>
          <VisaCondition>2222</VisaCondition>
        </VisaConditions>

But the output adds an extra group.

        <VisaConditions>
          <VisaCondition>
            <VisaCondition>1111</VisaCondition>
          </VisaCondition>
          <VisaCondition>
            <VisaCondition>2222</VisaCondition>
          </VisaCondition>
        </VisaConditions>

How do I fix the OUTPUT that is written back out (while still able to read the input)?
See attached OML.

XMLSample.oml
2021-05-18 02-27-17
Manish Gupta
Champion

I cannot access anything in your OML. If you can share the usecase, I can try to share a Sample OML (Reactive) with you. Are you uploading the data and in a form trying to update and then downloading the XML!!

2017-04-10 03-24-23
Alan Telford(Maxtel)

So sorry - I attached the wrong sample. Please try this one.

In the sample I'm just reading the xml, and then creating an xml string straight from it - both displayed in the page for comparison.

In the real work flow, there are two different processes - one for reading the xml which updates various entities. And another one for writing back the xml of any changed records (and sending via FTP).

AlanXml.oml
2017-04-10 03-24-23
Alan Telford(Maxtel)

Hi Manish

I'm still looking for help on this if you have any ideas?

Did you try the second attachment (AlanXml.oml) on my 31-Oct reply?
I was able to successfully install that on a different personal edition, so it should be accessible.

Thanks in advance, Alan

2021-05-18 02-27-17
Manish Gupta
Champion

Hi Alan

I tried to fix your OML with multiple ways but I didn't found any solution for removing that node. I am sorry. 

2017-04-10 03-24-23
Alan Telford(Maxtel)

Thank you for your efforts in trying Manish. Much appreciated. I will keep looking myself ....

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.