You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Insert CDATA into XML in a mapping

Received Response
37
Views
3
Comments
edited Dec 10, 2019 8:00PM in Integration 3 comments

Summary

Insert CDATA into XML in a mapping

Content

I am using OIC to call quickBase API. Trying to insert CDATA in xml ,output should look like below.

<qdbapi>
 
   <records_csv>
      <![CDATA sid,sflag

                  1234,1

                   4321,1

                   4567,1


         ]]>
   </records_csv>
  
</qdbapi>

Trying with below in xslt:

<nsmpr9:records_csv xml:id="id_92">
<xsl:value-of disable-output-escaping="no" select='concat("&lt;![CDATA["," ")'/>
 
<xsl:text> sid,sync</xsl:text>
<xsl:text disable-output-escaping="yes">&#13;</xsl:text>
<xsl:for-each select="$v1/nsmpr1:testResponse/nsmpr5:testbapi/nsmpr5:record">
 
<xsl:value-of select="concat(@sid, ',', '1')"/>
<xsl:choose>
<xsl:when test="position()!=last()">
<xsl:text disable-output-escaping="yes">&#13;</xsl:text>

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!