Missing parameter value(s) when using "WITH CONNECTION QUERY"

[HilitDrori]

Hello,

I'm new to Qlik Sense and I'm trying to load a Json file using rest.

I need to load in advance only part of the rows from the file, where the field "objectType" equals "sheet".

I used the script from the connection and tried to add  WITH CONNECTION QUERY but get the message:

HTTP protocol error 400 (Bad Request):

Missing parameter value(s)

The script I'm using:

LIB CONNECT TO 'monitor_apps_REST_appobject';

RestConnectorMasterTable:
SQL SELECT
"id" AS "id_u2",
"createdDate",
"modifiedDate",
"modifiedByUserName",
"engineObjectType",
"description",
"attributes",
"objectType",
"publishTime" AS "publishTime_u0",
"published" AS "published_u0",
"approved",
"sourceObject",
"draftObject",
"name" AS "name_u2",
"appObjectBlobId",
"engineObjectId",
"contentHash",
"size",
"privileges" AS "privileges_u2",
"schemaPath",
"__KEY_root",
(SELECT
"id",
"userId",
"userDirectory",
"userDirectoryConnectorName",
"name",
"privileges",
"__FK_owner"
FROM "owner" FK "__FK_owner"),
(SELECT
"@Value",
"__FK_tags"
FROM "tags" FK "__FK_tags" ArrayValueAlias "@Value"),
(SELECT
"id" AS "id_u1",
"name" AS "name_u1",
"appId",
"publishTime",
"published",
"stream",
"savedInProductVersion",
"migrationHash",
"availabilityStatus",
"privileges" AS "privileges_u1",
"__KEY_app",
"__FK_app",
(SELECT
"id" AS "id_u0",
"name" AS "name_u0",
"privileges" AS "privileges_u0",
"__FK_stream"
FROM "stream" FK "__FK_stream")
FROM "app" PK "__KEY_app" FK "__FK_app")
FROM JSON (wrap on) "root" PK "__KEY_root"
WITH CONNECTION (QUERY "objectType" "sheet");

[Levi_Turner]

Give a go to this:

WITH CONNECTION (QUERY "filter" "objectType eq 'sheet'")

From the Repository API docs, the expected syntax is filter=filterType <operator> 'condition'.

[HilitDrori]

It works. Thank you very much.

Now I'm trying to add another filter

WITH CONNECTION (QUERY "filter" "objectType eq 'sheet' and published eq 'true'");

Also tryed:

WITH CONNECTION (QUERY "filter" "objectType eq 'sheet'", QUERY "filter" "published eq 'true'");

[Levi_Turner · Accepted solution]

WITH CONNECTION (QUERY "filter" "objectType eq 'sheet' and published eq true")

This works for me.

[HilitDrori]

It works great! thank you

[GHasan]

Hi, 

what would happen in case of handling null value? If I want:
Where objectType is not null

TIA