0 Replies Latest reply: Feb 6, 2018 2:12 PM by Marco Pincho RSS

    Trying to load a Post request on QlikSense using Rest Connector

    Marco Pincho

      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.










      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