call soap API with xml request body in an API flow

Legacy Contributor

Hi, 

I need to use a soap API in an API flow.

That means I need to use xml request body inside of an API flow.

For now only json request body are allowed, if an xml request body is definied in the swagger file (openAPI), the body field is shaded and cannot be populated:

Apparently, one way to use xml API in an API Flow is to use json request and configure an endpoint policy to convert json to xml.

And set another endpoint policy for the API response that will convert xml to json.

 

I can see the XmlToJson option but not the JsonToXml one, plus I have no idea of how to use it and couldn't find any examples or documentation.

Does anyone have an idea of how to do this ? 

Legacy Contributor

You can refer to the standard product documentation on JSON transformation policy: 

https://docs.infor.com/ionapi/2021-x/en-us/ionapiag_cloud/default.html?helpcontent=fuq1507230874536.html and https://docs.infor.com/ionapi/2021-x/en-us/ionapiag_cloud/default.html?helpcontent=tcu1507239698087.html 

The transformation uses handlebar framework. So you can also refer to handlebar documentation to understand all functions and possibilities. For example: https://handlebarsjs.com/guide/builtin-helpers.html (and other links in the menu). 

I will also share the below code to convert a random XML to JSON. Hope all these helps. 

------ 

Transformation Code:

<?xml version="1.0" encoding="UTF-8"?> 

<jsonTransform continueOnError="false" displayName="JSON transform Policy-example"

                  enabled="true" name="JSON-Tranform-example" version="1.0"

    xmlns="http://www.infor.com/ion/api"

    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

                  xsi:schemaLocation="http://www.infor.com/ion/api jsonTransform.xsd">

    <transformations>

        <transform kind="handlebars" outputType="application/json">

            <![CDATA[

{{#with S:Envelope.S:Body.ListResponse.ListResponse.DataArea}}

[

{{#each Item_v3}}

  {

     "itemGroup": "{{itemGroup}}",

     "itemType": "{{itemType}}"

  }{{#if @last}}{{else}},{{/if}}

{{/each}}

]

{{/with}}]]>

        </transform>

    </transformations>

</jsonTransform>

Example input:

<S:Envelope xmlns:S="http://schemas.xmlsoap.org/soap/envelope/">

   <S:Body>

      <ListResponse xmlns="http://www.infor.com/businessinterface/Item_v3">

         <ListResponse xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="">

            <DataArea>

               <Item_v3>

                  <description>raw material 01</description>

                  <itemCode>000025</itemCode>

                  <itemGroup>100000</itemGroup>

                  <itemType>purchase</itemType>

               </Item_v3>

               <Item_v3>

                  <description>Equipment Group 1</description>

                  <itemCode>001</itemCode>

                  <itemGroup>800000</itemGroup>

                  <itemType>equipment</itemType>

               </Item_v3>

               <Item_v3>

                  <description>Equipment Group 2</description>

                  <itemCode>002</itemCode>

                  <itemGroup>800000</itemGroup>

                  <itemType>equipment</itemType>

               </Item_v3>

               <Item_v3>

                  <description>Std Subcontracting Time</description>

                  <itemCode>100001</itemCode>

                  <itemGroup>900000</itemGroup>

                  <itemType>subcontracting</itemType>

               </Item_v3>

               <Item_v3>

                  <description>Std Subcontracting Quantity</description>

                  <itemCode>200002</itemCode>

                  <itemGroup>900000</itemGroup>

                  <itemType>subcontracting</itemType>

               </Item_v3>

               <Item_v3>

                  <description>main item</description>

                  <itemCode>A</itemCode>

                  <itemGroup>300000</itemGroup>

                  <itemType>manufacture</itemType>

               </Item_v3>

        </DataArea>

         </ListResponse>

      </ListResponse>

   </S:Body>

</S:Envelope>

Output given this input and transformation code :

 

            

[

  {

     "itemGroup": "100000",

     "itemType": "purchase"

  },

  {

     "itemGroup": "800000",

     "itemType": "equipment"

  },

  {

     "itemGroup": "800000",

     "itemType": "equipment"

  },

  {

     "itemGroup": "900000",

     "itemType": "subcontracting"

  },

  {

     "itemGroup": "900000",

     "itemType": "subcontracting"

  },

  {

     "itemGroup": "300000",

     "itemType": "manufacture"

  }

]