Log in to AnswerLog in to Follow
UserImage.jpg
Sreekanth K
10Views
5Comments
[XML Records] How to add root node in xml generation
Question
SQL
Forge
XML
New to OutSystems
xml-records
Service icon
XML Records
Forge component by Afonso Carvalho

Hi anyone please suggest how to add a root node in XML generation. I am generating an XML file which took values from an OS SQL out put. Also please suggest on the empty tag creation.

1. How to generate the root node <students>

2. How to generate empty tags <ID></ID> 

<students>

    <student>

         <Name>Test1</Name>

         <Email> test1@mail.com </Email> 

         <ID></ID>

    </student>

     <student> 

       <Name>Test2</Name> 

       <Email> test2@mail.com </Email> 

      <ID></ID> 

    </student> 

</students>

0
0
03 Aug
2021-05-18 02-27-17
Manish Gupta
Champion

Hey Sreekant

Are you trying to accomplish the solution through any Extension? If not, please check if this can resolve your issue, 

0
0
03 Aug

Hi @manish Gupta I am using "Record list to XML" extension only. But can you tell me how to set the root node name and empty tags

0
0
03 Aug
2019-06-15 21-39-22
Afonso Carvalho
mvp_badge
MVP

Hello,

I've edited your post, since I believe you're using the XML Records extension. Please let me know if I am incorrect and I will revert the changes.

You should be able to have a <students> root node if your OutSystems structure starts with a "students" list element. Can you share your module so we can take a look?

Regarding empty tags, you can use the Config structures for this:

If you name your record and specify attributes in the AttributesConfig list, you can then use the "ExcludeIfNull" flag to control if empty values are generated in the XML output.

0
0
03 Aug

Thank you for the answer. I have created the structure which is taking the value as an output of sql query and this pass to the record list to xml. can you suggest how to generate the empty tag like

<middle_name />

also i want the attribute and hard corded vlaue as "PUBLIC". Can suggest how to achieve this?

<record_type desc="Public">PUBLIC</record_type>


0
0
12 days ago
2019-06-15 21-39-22
Afonso Carvalho
mvp_badge
MVP

Replying to Sreekanth K's comment on 07 Aug 2022 12:18:11

I don't think the extension is prepared to handle self closing tags. <middle_name></middle_name> is possible with the ExcludeIfNull option, but I can't think of a way to generate <middle_name />.

There's no easy way to hardcode values with the Extension - if you assign the values in the Structure, it should be possible, otherwise you'd have to manipulate the XML string.

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