
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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:
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");
Accepted Solutions


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
WITH CONNECTION (QUERY "filter" "objectType eq 'sheet' and published eq true")
This works for me.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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'.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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'");


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
WITH CONNECTION (QUERY "filter" "objectType eq 'sheet' and published eq true")
This works for me.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
It works great! thank you

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
what would happen in case of handling null value? If I want:
Where objectType is not null
TIA
