Hi,

I need to call the cloud database with json formatted request. I have tried below one.

<dp:url-open target="https://{hostname}/dbapi/v4/sql_jobs" http-method="post" http-headers="$headers" ssl-proxy="client:ssl-client-profile" response="responsecode">

<xsl:copy-of select="concat('{ &quot;commands&quot; : &quot;insert into IEBX.NON_REPO_LOGS(device_name) values(\'123\')&quot;}')" />

</dp:url-open>

in values section, i have tried passing value as 123 / '123' and other ways but none worked. At datapower, the request is failing with error - filename.xsl:25: Operator expected.

not sure how to pass values in the statement. If anyone come across such issue, please reply here.

hello

try this

<dp:url-open target="https://{hostname}/dbapi/v4/sql_jobs" http-method="post" http-headers="$headers" ssl-proxy="client:ssl-client-profile" response="responsecode">

<xsl:variable name="json">

<xsl:text>{"commands" : "insert into IEBX.NON_REPO_LOGS(device_name) values(\"123\")"}</xsl:text>

</xsl:variable>

<xsl:copy-of select="$json"/>

</dp:url-open>

Sorry, it's better

<dp:url-open target="https://{hostname}/dbapi/v4/sql_jobs" http-method="post" http-headers="$headers" ssl-proxy="client:ssl-client-profile" response="responsecode">

<xsl:variable name="json">

<xsl:text>{"commands" : "insert into IEBX.NON_REPO_LOGS(device_name) values(\"123\")"}</xsl:text>

</xsl:variable>

<xsl:value-of select="$json" disable-output-escaping="yes"/>

</dp:url-open>

Hi David,

I tried above one which is for static value but for dynamic values containing " in it throwing invalid json format. And I need to load with soap message which has namespaces. So I serialized the soap message and replaced the " to \" using recursive function so that the json is well formed. Now its working fine.

Thq for your response.