Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
GustavLindstrom
Contributor II
Contributor II

Rest connector to QRS with Query filter gives 400 error

 

Connecting to https://localhost/qrs/user/full and getting a 400 error se below, seems to have started when I upgraded our Qlik Sense to August 2021 Patch 1. Any ideas why?

The following error occurred:

HTTP protocol error 400 (Bad Request):

The comparison expression does not consist of three elements: attributes.attributeType+eq+%27group%27+and+attributes.attributeValue+eq+%27.ad.group%27

The error occurred here:

RestConnectorMasterTable:

  SQL SELECT 

      "id" AS "id_u0",

      "createdDate" AS "createdDate_u0",

      "modifiedDate" AS "modifiedDate_u0",

      "modifiedByUserName" AS "modifiedByUserName_u0",

      "userId",

      "userDirectory",

      "name",

      "inactive",

      "removedExternally",

      "blacklisted",

      "deleteProhibited",

      "privileges",

      "schemaPath" AS "schemaPath_u0",

      "__KEY_root",

      (SELECT 

          "@Value",

          "__FK_customProperties"

      FROM "customProperties" FK "__FK_customProperties" ArrayValueAlias "@Value"),

      (SELECT 

          "@Value" AS "@Value_u0",

          "__FK_roles"

      FROM "roles" FK "__FK_roles" ArrayValueAlias "@Value_u0"),

      (SELECT 

          "id",

          "createdDate",

          "modifiedDate",

          "modifiedByUserName",

          "attributeType",

          "attributeValue",

          "externalId",

          "schemaPath",

          "__FK_attributes"

      FROM "attributes" FK "__FK_attributes"),

      (SELECT 

          "@Value" AS "@Value_u1",

          "__FK_tags"

      FROM "tags" FK "__FK_tags" ArrayValueAlias "@Value_u1")

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

  WITH CONNECTION (QUERY "filter" "((((attributes.attributeType+eq+%27group%27+and+attributes.attributeValue+eq+%27.ad.group%27))))")

 

0 Replies