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