Connecting to webservices API and pulling data into QlikSense

[Swetha2401]

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>

<viewSettings>

<forcelogoutsession>yes</forcelogoutsession>

<rollingPeriod> Minutes30</rollingPeriod>

<shiftstart>28800000</shiftstart>

<statisticsRange>CurrentWeek</statisticsRange>

<timeZone>-25200000</timeZone>

</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>

<columnnames>

<values>

<data>username</data>

<data>FullName</data>

</values>

</columnnames>

</ser:getstatistics>

</soapenv:Body>

</soapenv:Envelope>