topic Re: 400 bad request when using Qlik-CLI in Integration, Extension & APIs

400 bad request when using Qlik-CLI

ryanplkam — Tue, 07 Jul 2020 19:53:57 GMT

Hello all,

I am trying to query for all users with a custom attribute called "professional" = true, using Qlik-CLI

I am able to connect successfully, using certificates.

The command is as follows:

get-qlikuser -filter "professional eq true" -full

This produces the following error message:

Invoke-RestMethod : The remote server returned an error: (400) Bad Request.
At C:\Program Files\WindowsPowerShell\Modules\Qlik-Cli\1.19.1\functions\core.ps1:63 char:19
+ $result = Invoke-RestMethod @paramInvokeRestMethod @params
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : InvalidOperation: (System.Net.HttpWebRequest:HttpWebRequest) [Invoke-RestMetho
d], WebException
+ FullyQualifiedErrorId : WebCmdletWebResponseException,Microsoft.PowerShell.Commands.InvokeRestMethodCo
mmand

Any ideas what I'm doing wrong?

@Levi_Turner

Thank you!

Re: 400 bad request when using Qlik-CLI

Levi_Turner — Tue, 07 Jul 2020 20:08:28 GMT

You're trying to filter on a custom property named professional, yes? If so then this would be the syntax:

Get-QlikUser -full -filter "@professional eq 'true'"

If not, then what is this attribute? A user attribute like a group? Something else?

Re: 400 bad request when using Qlik-CLI

ryanplkam — Tue, 07 Jul 2020 21:08:25 GMT

@Levi_Turner it is an attribute we've pulled in through SQL ODBC connector, like 'email' in this example

https://help.qlik.com/en-US/sense/June2019/Subsystems/ManagementConsole/Content/Sense_QMC/ODBC-example.htm

Running your code does not produce an error, so I assume it's working. However when I try to view the result nothing appears:

$professionalattributeusers = Get-QlikUser -full -filter "@professional eq 'true'" Write-Output $professionalattributeusers

Even though in QMC, I can see two users with this attribute = true.

Not sure if i'm still doing something wrong..

Re: 400 bad request when using Qlik-CLI

ryanplkam — Tue, 07 Jul 2020 21:10:25 GMT

@Levi_Turner I figured it out, this is what I needed.

$professionalattributeusers = Get-QlikUser -full -filter "attributes.attributeType eq 'professional' and attributes.attributeValue eq 'true'" Write-Output $professionalattributeusers

Thanks!