3 Replies Latest reply on Jul 3, 2020 5:38 AM by Ashwini Ramakrishna

    Require White space in webservice transformation

    Arun Pudipeddi Active Member

      We have a requirement to send empty space " " as one of the value in the webservice request using webservice transformation using cloud data integration Job. The while spaces are getting truncated automatically in the request. We need to send them as is.

       

      Found a similar KB for webservice transformation using power center to set Custom property XMLStripWhitespace. But this article is related to Powercenter settings. We need the same on Cloud Data Integration .

       

      I tried this setting at Agent Server Custom Properties, But it is not working.

      Custom Configuration

      ServiceTypeNameValue
      Data_Integration_Server57.0TOMCAT_JREXMLStripWhitespaceNo

       

        • 1. Re: Require White space in webservice transformation
          Ashwini Ramakrishna Guru

          Hello Arun,

           

           

           

          Its not designed to remove whitespaces,its for removing the trailing spaces.Please see you code page set on the secure agent and if its UTF8 all specila characters will be handled while processing.

          • 2. Re: Require White space in webservice transformation
            Arun Pudipeddi Active Member

            HI Ashwini,

             

            Thanks a lot for the reply,

            We want the request to be sent as <tag> </tag>.

            Instead of the empty space inside the element, It is getting assigned as <tag/> in the request sent to server. The code page in the agent is set to UTF8.

             

            Custom Configuration

            ServiceTypeNameValue
            Data_Integration_Server57.0TOMCAT_CFGmaxDTMProcesses5
            Data_Integration_Server57.0TOMCAT_JREINFA_CODEPAGENAMEUTF-8
            Data_Integration_Server57.0TOMCAT_JREXMLStripWhitespaceNo

             

             

            Thanks

            Arun

            • 3. Re: Require White space in webservice transformation
              Ashwini Ramakrishna Guru

              In order to pass NULL tags in the output XML, please mark the fields as mandatory in the schema or you can follow below approach -

              -        Go to Configure > Runtime Environments.

              -        Edit the Secure Agent where the property needs to be set.

              -        Scroll Down to the “Custom Configuration Details”.

              -        Add an extra custom configuration by clicking on the Green ‘+’ sign.

              -        Select the Type as “Tomcat”

              -        The Name should “XML_OUTPUT_MODE” and set value as "Full"

              -        Click “OK’ to Update the changes.

              -       Please wait for the new DIS version to come up and run the task.