Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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