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.

       

      URL

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


      Timeout

      30

       

      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