Skip to main content
Solved

XML Templater to read a List

  • August 26, 2024
  • 5 replies
  • 87 views
laxmi_2590
Contributor
Forum|alt.badge.img+2

Hi Everyone,

 

I have recently started with FME. I have a case where I have to format an XML from a list. 

I am using XMLTemplater Transformer to build a request xml which looks like below

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:wnb="http://sample.com.au">
   <soapenv:Header/>
   <soapenv:Body>
      <wnb:fetchNotificationDetails>
         <!--1 or more repetitions:-->
         <notificationNo>121</notificationNo>
         <notificationNo>131</notificationNo>
     <notificationNo>141</notificationNo>
      </wnb:fetchNotificationDetails>
   </soapenv:Body>
</soapenv:Envelope>

 

 

 I am passing some ten notification numbers to a XML templater and they are coming out individually like below 

 

   <soapenv:Header/>
   <soapenv:Body>
      <wnb:fetchNotificationDetails>
         <!--1 or more repetitions:-->
         <notificationNo>301</notificationNo> 
      </wnb:fetchNotificationDetails>
   </soapenv:Body>
</soapenv:Envelope>

 

 <soapenv:Header/>
   <soapenv:Body>
      <wnb:fetchNotificationDetails>
         <!--1 or more repetitions:-->
         <notificationNo>302</notificationNo> 
      </wnb:fetchNotificationDetails>
   </soapenv:Body>
</soapenv:Envelope>

 

I used a listbuilder transformer and then passed it to XMLTemplater .

 

What is the option I should select from the below to read a list to form request XML mentioned below


I want a single output from XML templater which looks like below

 

 <soapenv:Header/>
   <soapenv:Body>
      <wnb:fetchNotificationDetails>
         <!--1 or more repetitions:-->
         <notificationNo>121</notificationNo>
         <notificationNo>131</notificationNo>
     <notificationNo>141</notificationNo>
      </wnb:fetchNotificationDetails>
   </soapenv:Body>
</soapenv:Envelope>

 

Any help would be appreciated. Thanks

 

 

Best answer by s.jager

II would solve this by using a creator for the root element, then inside the root element use process-features to get your list of notification ID’s. So something like this:

where the Root Template Expression is this:

<Body>
  <fetchNotificationDetails>
    {fme:process-features("NOTIFICATION_IDS")}
  </fetchNotificationDetails>
</Body>

And the Sub Template NOTIFICATION_IDS looks like this:

<notificationNo>{fme:get-attribute("NotificationID")}</notificationNo>

When I run this, this gives me the following XML Result:

<?xml version="1.0" encoding="UTF-8"?>
<Body>
  <fetchNotificationDetails>
    <notificationNo>0</notificationNo>
    <notificationNo>1</notificationNo>
    <notificationNo>2</notificationNo>
    <notificationNo>3</notificationNo>
    <notificationNo>4</notificationNo>
    <notificationNo>5</notificationNo>
    <notificationNo>6</notificationNo>
    <notificationNo>7</notificationNo>
    <notificationNo>8</notificationNo>
    <notificationNo>9</notificationNo>
  </fetchNotificationDetails>
</Body>

Which seems to be what you are looking for. Of course my example is a bit simplifed, you’ll need to include the namespaces and stuff, but this should get you going.

 

    This post is closed to further activity.
    It may be an old question, an answered question, an implemented idea, or a notification-only post.
    Please check post dates before relying on any information in a question or answer.
    For follow-up or related questions, please post a new question or idea.
    If there is a genuine update to be made, please contact us and request that the post is reopened.

    5 replies

    s.jager
    Influencer
    Forum|alt.badge.img+22
    • s.jagerInfluencer
    • Influencer
    • Best Answer
    • August 27, 2024

    II would solve this by using a creator for the root element, then inside the root element use process-features to get your list of notification ID’s. So something like this:

    where the Root Template Expression is this:

    <Body>
      <fetchNotificationDetails>
        {fme:process-features("NOTIFICATION_IDS")}
      </fetchNotificationDetails>
    </Body>

    And the Sub Template NOTIFICATION_IDS looks like this:

    <notificationNo>{fme:get-attribute("NotificationID")}</notificationNo>

    When I run this, this gives me the following XML Result:

    <?xml version="1.0" encoding="UTF-8"?>
    <Body>
      <fetchNotificationDetails>
        <notificationNo>0</notificationNo>
        <notificationNo>1</notificationNo>
        <notificationNo>2</notificationNo>
        <notificationNo>3</notificationNo>
        <notificationNo>4</notificationNo>
        <notificationNo>5</notificationNo>
        <notificationNo>6</notificationNo>
        <notificationNo>7</notificationNo>
        <notificationNo>8</notificationNo>
        <notificationNo>9</notificationNo>
      </fetchNotificationDetails>
    </Body>

    Which seems to be what you are looking for. Of course my example is a bit simplifed, you’ll need to include the namespaces and stuff, but this should get you going.

     

    laxmi_2590
    laxmi_2590
    Contributor
    Forum|alt.badge.img+2
    • laxmi_2590Contributor
    • Author
    • Contributor
    • August 27, 2024

    Hi s.jager ,

     

    Thanks for your response and that really helped. I am able to send  all the notifications in a single call.

    Thanks a lot.

    May I ask you another query related to response,  I get a response for the above notification request as below

    <notificationDetails>
                <notificationNo>121</notificationNo>
                <notificationStatus>Found</notificationStatus>
                <jobType>SF</jobType>
                <jobDescription>Test</jobDescription>
                <flNumber>110</flNumber>
             </notificationDetails>
             <notificationDetails>
                <notificationNo>131</notificationNo>
                <notificationStatus>Found</notificationStatus>
                <jobType>SF</jobType>
                <jobDescription>Test</jobDescription>
                <flNumber>111</flNumber>
             </notificationDetails>
             <notificationDetails>
                <notificationNo>141</notificationNo>
                <notificationStatus>Not Found</notificationStatus>
                <jobType></jobType>
                <jobDescription></jobDescription>
                <flNumber></flNumber>
             </notificationDetails>
     

    Is there anyway that I can get the output in to rows like below

     

    NotificationNo notificationStatus jobType jobDescription flNumber
    121 Found SF Test 110


    Is there a transformer I can use to do that ?
    Thanks again for your help. :)

    s.jager
    Influencer
    Forum|alt.badge.img+22
    • s.jagerInfluencer
    • Influencer
    • August 28, 2024

    I’m not sure what you mean by 

    get the output in to rows

    You wanted xml, that’s what you get. And you already have the features with the attributes, so that is already in sort of a tabular format. Do you want to see it in the Data Explorer? Then just add an Inspector right in front of the XMLTemplater. Or do you also want an excel or an html table as secondary output?

    laxmi_2590
    Contributor
    Forum|alt.badge.img+2
    • laxmi_2590Contributor
    • Author
    • Contributor
    • August 29, 2024

    Hi s.jager,

     

    Thanks for your response.

    I want to extract the attributes of the response xml for further processing.

     

    If below is my response xml, 

    <notificationDetails>
                <notificationNo>121</notificationNo>
                <notificationStatus>Found</notificationStatus>
                <jobType>SF</jobType>
                <jobDescription>Test</jobDescription>
                <flNumber>110</flNumber>
             </notificationDetails>
             <notificationDetails>
                <notificationNo>131</notificationNo>
                <notificationStatus>Found</notificationStatus>
                <jobType>SF</jobType>
                <jobDescription>Test</jobDescription>
                <flNumber>111</flNumber>
             </notificationDetails>
             <notificationDetails>
                <notificationNo>141</notificationNo>
                <notificationStatus>Not Found</notificationStatus>
                <jobType></jobType>
                <jobDescription></jobDescription>
                <flNumber></flNumber>
             </notificationDetails>

     

     I have to take each one of these notification IDS and respective job type, job desc etc to query another table and get some other information. 
     

    NotificationNo notificationStatus jobType jobDescription flNumber

    121

    122

    Found

    Not Found

    SF

    SK

    		 Test
    Testq

    110

    112

     

    I tried using AttributeExploder to extract the attribute values. But that is not giving me the expected result,

    I hope I made it a little clear now. 

    s.jager
    Influencer
    Forum|alt.badge.img+22
    • s.jagerInfluencer
    • Influencer
    • August 29, 2024

    Ah, that makes more sense, thank you for clearing that up.

    To create features from the response xml, the XMLFragmenter is probably your best option.

    Community Stats

    32,154
    Posts
    122,043
    Replies
    39,812
    Members

    Latest FME

    Terms & ConditionsCookie settingsAccessibility statement
    A product of
    Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.