How to deal with Integration that does not return lisible reply

Certified Senior Developer

Hi,

I'm calling an external Integration which works fine, but when I try to set the "Convert JSON to Appian value" option, the Integration returns the error below.

1/ How would you do to deal with that error ? do I have no other choice to deal with the raw response ?
(it is an old API, and we can not ask any update)

error-result-guidance
The response body could not be converted to an Appian value The jsonText parameter was not valid JSON. Received: <...



2/ In raw mode, the API response is like this (please see below). It contains XML not really practical, and there are a lot characters to escape.
How would you do to extract informations in a clean way (or to convert it in Json) ?

We've tried functions such a "tojson" but without satisfactory results. Of course using "extract" function works, but I'm looking for the best way to do it please.

<?xml version='1.0' encoding='UTF-8'?> 
	<SOAP-ENV:Envelope xmlns:SOAP-ENV='http://schemas.xmlsoap.org/soap/envelope/' xmlns:ns1='http://ldap.xxxxxx.fr/LdapWS/client/'>
	<SOAP-ENV:Body>
		<ns1:listeUsersResponse>
			<response>
				<demandeRecue>true</demandeRecue>
				<xml><?xml version='1.0' encoding='UTF-8'?>
					<data>
						<listeUsers><titre><![CDATA[M.]]></titre><nom><![CDATA[DUPONT]]></nom><prenom><![CDATA[Nicolas]]></prenom><color><![CDATA[Red]]></color><size><![CDATA[10]]></size></listeUsers>
						<listeUsers><titre><![CDATA[M.]]></titre><nom><![CDATA[DURAND]]></nom><prenom><![CDATA[Pauline]]></prenom><color><![CDATA[blue]]></color><size><![CDATA[15]]></size></listeUsers>
					</data>
				</xml>
			</response>
		</ns1:listeUsersResponse>
	</SOAP-ENV:Body>
</SOAP-ENV:Envelope>
 

Regards

  Discussion posts and replies are publicly visible