Web API - POST XML

Kevin-M — Mon, 08 Feb 2021 23:24:21 GMT

Hi,

We have used the Rest API successfully when using the Get method but are now working on XML response to a POST. The connection is successful, but the results are in a single 'output' field in CSV format which is truncated due to field length as we are reporting on multiple records.

The Post method template is similar as follows :

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

<account code='<Account Code>' isAssumption='false' includeDescendants='true'></account>

</accounts>

</filters>

</dimensions>

<rules includeZeroRows='false' markInvalidValues='false' markBlanks='false'

timeRollups='false'>

</rules>

</call>

And the load script is as follows:

RestConnectorMasterTable:
SQL SELECT
"attr:success" AS "success",
"output"
FROM XML "response";

[response]:
LOAD [success],
[output]
RESIDENT RestConnectorMasterTable;

DROP TABLE RestConnectorMasterTable;

Does anybody have any experience or suggestions in formatting the XML response in table format or how we could export entire output to a CSV file to then load into Qlik Sense?

Appreciate any help provided.

topic Web API - POST XML in App Development

Web API - POST XML