Skip to main content

Announcements
Week 2: Presenting "Automate Sucess" and "Integration for Innovation" - WATCH NOW

REST Connector wizard not loading in tags or custom property values when calling QRS API

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
Damien_V
Support

REST Connector wizard not loading in tags or custom property values when calling QRS API

Last Update:

Dec 9, 2020 6:52:00 AM

Updated By:

Sonja_Bauernfeind

Created date:

Nov 5, 2019 7:54:34 AM

REST Connector wizard not loading in tags or custom property values when calling Qlik Repository Service (QRS) API.

Environments:

  • Qlik Sense Enterprise for Windows all versions

 

Resolution:


The REST Connector will load a small sample of data in the wizard when creating the query to be inserted.
For example, when using /qrs/app/full, it will only load the few first records and create the query based on that.

If the first apps in the list do not have a custom property/tag assigned, it will not create a query to extract custom property/tag.

The solution to this issue is to either write the query manually or use orderby as a query parameter with the name of the column to be ordered on, where one of the app assigned a custom property/tag appears at the top of the list. See get /app/full documentation for details. 



Example (PowerShell):

$body = ''
   $hdrs = @{}
   $hdrs.Add("X-Qlik-xrfkey","iX83QmNlvu87yyAB")
   $hdrs.Add("X-Qlik-User","UserDirectory=DOMAIN;UserId=Administrator")
   $url = "https://qlikserver1.domain.local:4242/qrs/app/full?xrfkey=iX83QmNlvu87yyAB&orderby=stream.name"
   $cert = Get-ChildItem -Path "Cert:\CurrentUser\My" | Where {$_.Subject -like '*QlikClient*'}
   Invoke-RestMethod -Uri $url -Method Get -ContentType 'application/json' -Headers $hdrs -Certificate $cert


 

Alternatively, if the REST connector is used in the script load, you can increase the "Preload symbol count" to "No limitation".

Labels (2)