Rest connector to QRS with Query filter gives 400 error

GustavLindstrom — Tue, 12 Oct 2021 09:22:45 GMT

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))))")

topic Rest connector to QRS with Query filter gives 400 error in Integration, Extension & APIs

Rest connector to QRS with Query filter gives 400 error