Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
HilitDrori
Contributor II
Contributor II

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

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");
1 Solution

Accepted Solutions
Levi_Turner
Employee
Employee

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

This works for me.

View solution in original post

5 Replies
Levi_Turner
Employee
Employee

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
Contributor II
Contributor II
Author

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
Employee
Employee

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

This works for me.

HilitDrori
Contributor II
Contributor II
Author

It works great! thank you

GHasan
Contributor III
Contributor III

Hi, 

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

TIA