1 Reply Latest reply: Jan 4, 2018 10:25 AM by Sandeep Roy RSS

    REST connection fails

    Robert Brink



      I have a problem connection with REST to a web API hosted by a ITSM system. I can make REST connections through other tools (Powershell using Invoke-RestMethod, and Advanced REST Client) and extract the data, but when setting this up with Qlik Sense Desktop, it fails:

      Load Statement

      LIB CONNECT TO 'NilexTest-GetEntityListByQuery';












      FROM "Data" FK "__FK_Data")

      FROM JSON (wrap on) "root" PK "__KEY_root";



      LOAD [Id] AS [Id],

      [Type] AS [Type],

      [CreatedDate] AS [CreatedDate],

      [EntityType] AS [EntityType],

      [Type.Id] AS [Type.Id],

      [__FK_Data] AS [__KEY_root]

      RESIDENT RestConnectorMasterTable

      WHERE NOT IsNull([__FK_Data]);

      DROP TABLE RestConnectorMasterTable;


      From the error log:

      Error: QVX_UNEXPECTED_END_OF_DATA: HTTP protocol error 400 (Bad Request):

      2017-12-21 16:47:00  

      2017-12-21 16:47:00      {"Data":null,"Errors":[{"Message":"Invalid json: 'Error reading JObject from JsonReader. Current JsonReader item is not an object: String. Path '', line 1, position 12.'","Code":21,"MessageDetails":"Newtonsoft.Json.JsonReaderException: Error reading JObject from JsonReader. Current JsonReader item i...


      I can browse and select the data, so the connection is working up until I press Load Data, and the error above appears.



      I have seen other community discussions regarding similar issues, but my Sense scripting skills are limited so I haven't been able to transform them successfully to match my needs.

      REST CONNECTOR, Override request body


      Can anyone assist in this issue?