topic Re: Qlik Cli Update-QlikUser update custom property in Management & Governance

Qlik Cli Update-QlikUser update custom property

siddharth_s3 — Sat, 16 Nov 2024 06:58:44 GMT

Hello,

I am unable to figure out the syntax for updating the custom property when trying tom Update-QlikUser when using the cli module.

Has anyone managed to update a user's custom property?

Below is the module gallery:

https://www.powershellgallery.com/packages/Qlik-Admin-Utils/3.2.5.1/Content/Update-QlikUser.ps1

Re: Qlik Cli Update-QlikUser update custom property

siddharth_s3 — Thu, 27 Dec 2018 08:54:17 GMT

bump. Anyone?

Re: Qlik Cli Update-QlikUser update custom property

Levi_Turner — Thu, 27 Dec 2018 13:48:44 GMT

@siddharth_s3,

A few thoughts:

What is the work-flow? i.e.
- Are you trying to assign a single custom property to a user? Multiple values of a single custom property? Append a value to an existing custom property assignment?
Example commands with the responses is needed
A basic work-flow is working fine on my end:

Connect-Qlik
Get-QlikUser -filter "userid eq 'test@test'" | Update-QlikUser -customProperties UserCustomProperty=foo

Additionally, Qlik Branch's Slack instance, specifically the #qrs-api and/or #qlik-cli channels may be a more appropriate venue for getting more insight: http://qlikbranch-slack-invite.herokuapp.com/

Re: Qlik Cli Update-QlikUser update custom property

babitaku — Mon, 03 May 2021 13:16:25 GMT

Hi @Levi_Turner ,

How to remove Custom Property value for a particular user? Appreciate you help.

Thanks!

Re: Qlik Cli Update-QlikUser update custom property

babitaku — Mon, 03 May 2021 15:44:43 GMT

HI @Levi_Turner ,

With the below endpoint, we can not append the value. This is replacing all the other value with 'foo'

Get-QlikUser -filter "userid eq 'test@test'" | Update-QlikUser -customProperties UserCustomProperty=foo

How can we append with the existing value?

Re: Qlik Cli Update-QlikUser update custom property

Levi_Turner — Tue, 04 May 2021 22:48:47 GMT

Hey @babitaku ,

Adapted from @Marc 's code here: https://github.com/ahaydon/Qlik-Cli-Windows/issues/133

Connect-Qlik $newCustomProp = "Group=DL-Enterprise Team" $user = Get-QlikUser -filter "userDirectory eq 'ANYDIR' and userId eq 'ltu'" -full [string[]]$customProperties = "" [string[]]$customProperties = $($user.customProperties|%{"$($_.definition.Name)=$($_.value)"}) $customProperties += $newCustomProp $user | Update-QlikUser -customProperties $customProperties

Re: Qlik Cli Update-QlikUser update custom property

Marc — Tue, 04 May 2021 23:14:39 GMT

just a quick update to the above.... if only because I hate using '+=' even if I did perpetrate its use here...

+= has a fairly hefty performance impact, trivial and not worth worrying about for small sets of items, but noticeable when there is a lot of data (like in a production environment)

the better way to do this is using a Generic List object... like so..

Connect-Qlik $newCustomProp = "Group=DL-Enterprise Team" $user = Get-QlikUser -filter "userId eq 'marc'" -full [System.Collections.Generic.List[string]]$customProperties = "" if ($user.customProperties.Count -gt 0) { $customProperties.AddRange($($user.customProperties | ForEach-Object{"$($_.definition.Name)=$($_.value)"})) } $customProperties.Add($newCustomProp) $user | Update-QlikUser -customProperties $customProperties

Example for why not to use '+='

10,000 objects using '+=' takes 11.31 seconds

10,000 object using List.Add takes 0.54 seconds

Re: Qlik Cli Update-QlikUser update custom property

babitaku — Wed, 26 May 2021 09:27:41 GMT

You rock @Levi_Turner

Thank you so much. This saved our tedious work of manually adding Custom Properties 🙂

Re: Qlik Cli Update-QlikUser update custom property

ilyas393 — Thu, 15 Sep 2022 20:30:23 GMT

Hi @babitaku ,

did you figure out how to remove the custom properties using the cli?

I am looking to remove all the custom properties assigned to all the users. i would appreciate any help.

Thank you,

Ilyas

Re: Qlik Cli Update-QlikUser update custom property

Padmini — Fri, 07 Oct 2022 12:58:14 GMT

Hi Levi_Turner,

I 'm facing an issue in updating a custom property for the new stream that was created using windows PowerShell script (Qlik CLI) .Please consider the below example of Custom Property :

Group=AB=QS_ABCD_Developer,CD=Efg,GH=LOB,IJ=PROD,IJ=KLMN,IJ=net where 'Group ' is the Custom Property Name and 'AB=QS_.....=net' is the Value.

Below is the syntax I'm using which is not working.

Update-QlikStream -id $streamid -customProperties @("Group=AB=QS_ABCD_Developer,CD=Efg,GH=LOB,IJ=PROD,IJ=KLMN,IJ=net")

I tried esc character ` for the = and , since other property value without the commas and eq to worked, only this property where the value is in such way is not working for me.

Any suggestion here would be of great help.Thanks,

Padmini

Re: Qlik Cli Update-QlikUser update custom property

Levi_Turner — Fri, 07 Oct 2022 14:05:08 GMT

Something like this works on my end:

Connect-Qlik Get-QlikStream -filter "name eq 'Everyone'" | Update-QlikStream -customProperties QlikGroup='AB=QS_ABCD_Developer,CD=Efg,GH=LOB,IJ=PROD,IJ=KLMN,IJ=net'

Re: Qlik Cli Update-QlikUser update custom property

Padmini — Fri, 07 Oct 2022 14:25:58 GMT

Hi Levi,

thanks for your quick response. But this kind of value to group custom property alone I’m facing issue . I have this value added in the group custom property but when I wanted to apply for stream using power shell it is not working. The same code work for lob custom property where I pass lob value(single word eg: HEALTHCARE

Re: Qlik Cli Update-QlikUser update custom property

Padmini — Mon, 10 Oct 2022 12:43:19 GMT

Hi All,

Any thoughts here ? This is an urgent requirement

Thanks Padmini