Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Insider: SaaS capabilities for Data Integration and Analytics, May 25th! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
balrajahlawat
Champion
Champion

Custom Properties for Users using QRS API's

Hey Qlikers,

Can anyone help me to get the list of custom properties for the users using QRS API's.

Using following API's we can fetch Custom Properties and User Lists seperately:

GET /qrs/custompropertydefinition/full

GET /qrs/users/full


But can we combine both the result into one API which can give me Custom Properites assigned to each and every users on Qlik server?


Please suggest.


Regards,

Balraj Ahlawat

3 Replies
balrajahlawat
Champion
Champion
Author

Hey Guys,

Can anyone suggest?

Any possibility?

Regards,

Balraj Ahlawat

tmackay2015
Partner
Partner

have you inspected the data from user/full closer?postmanquery.png

In april 2018 ( maybe earlier)  it seems they property definition is returned as part of the Json.

I Implemented some code on the App/full to do something similar, i am not sure i can share the code yet.

The way the rest connecter spits back data you may have to meddle with the Select statement as well as use the peek function.

The rows are sparse / not joined so you will have to  use peek to fill in the null values and filter out rows that are null in places.

you will understand when you see it.

I would also suggest filtering down to one individual first  till you get the select statement for the REST connection right

add to the connection a query token or use the 'With Connection' Key word'

here is what i used to filter to myself: query=Name eq 'Mackay, Thomas'


jpjust
Specialist
Specialist

Hi Balraj Ahlawat - were you able to  get the list of custom properties for the users using QRS API's.?

Thanks