Connecting to webservices API and pulling data into QlikSense

Swetha2401 — Tue, 21 Dec 2021 14:01:50 GMT

Hi All,

We are trying to connect to a webservice API to get some statistics. We were able to connect using Rest connector but was able to see only headers or definitions.

We have to establish a session first and then call the method getstatistics to get data.

I am using POST to send the resquest in the body of the rest connector, but I don't see anything except definitions.

API has given us sample set session and getStatistics payload requests which are below:

SetSession:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlsn:ser="http://###.###.ws.###.com/">

<soapenv:Header/>

<soapenv:Body>

<ser:setSessionParameters>

<rollingPeriod> Minutes30</rollingPeriod>

<statisticsRange>CurrentWeek</statisticsRange>

</viewSettings>

</ser:setSessionParameters>

</soapenv:Body>

</soapenv:Envelope>

getStatistics:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"xmlns:ser="http://###.###.ws.###.com/">

<soapenv:Header/>

<soapenv:Body>

<ser:getstatistics>

<statistictype>agentstatistics</statistictype>

<data>username</data>

<data>FullName</data>

</values>

</columnnames>

</ser:getstatistics>

</soapenv:Body>

</soapenv:Envelope>

topic Connecting to webservices API and pulling data into QlikSense in Connectivity & Data Prep

Connecting to webservices API and pulling data into QlikSense