Trying to load a Post request on QlikSense using Rest Connector

Anonymous — Tue, 06 Feb 2018 19:12:50 GMT

Dear all,

I am struggling to load more than the first line on a post call.

In order to help a association of customer, I am trying to connect to the API of the rail services, to check the delays of the trains. In the past they had a restful api, now they changed it to a post call made in a hideous way, design in my point of view to block any attempt of automatic get the data.

So to share more details with, I activated the Developer tools of my google chrome and tried to sniff the calls being made by the browser.

I set up the connector and I am being able to get the first line, but I dont understand, why I dont get the remaining lines.

URL

http://www.belgianrail.be/fr/service-clientele/attestation-de-retard.aspx

Timeout

Method

POST

POST /fr/service-clientele/attestation-de-retard.aspx HTTP/1.1

Host: www.belgianrail.be

Connection: keep-alive

Content-Length: 41745

Origin: http://www.belgianrail.be

User-Agent: Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safari/537.36

Content-Type: application/x-www-form-urlencoded; charset=UTF-8

X-Requested-With: XMLHttpRequest

Cache-Control: no-cache

X-MicrosoftAjax: Delta=true

Accept: */*

Referer: http://www.belgianrail.be/fr/service-clientele/attestation-de-retard.aspx Accept-Encoding: gzip, deflate

Accept-Language: en-GB,en;q=0.9,pt-PT;q=0.8,pt;q=0.7,fr-BE;q=0.6,fr;q=0.5,en-US;q=0.4

The body is a huge and horrendous thing, but to create an automated procedure i only need to change two parameters in the body txtTrainNumber=768 and txtSelectedDateTrain=06%2F02%2F2018, like that I can interate by the trains and by the dates.

It would be great an extra hand just to understand why I dont get full expected csv attached, and I just get the first row.

Thank you

topic Trying to load a Post request on QlikSense using Rest Connector in Integration, Extension & APIs

Trying to load a Post request on QlikSense using Rest Connector