I'm trying to emulate the User Report that lists users, ids, etc & roles like so:
SELECT login, id, topics.count(*), messages.count(*) FROM usersincluding "roles" just gives the implicit join query.
Is there any way to also grab the individual roles of the users from 1 API v2 query?
Yeah, the role is not in users but in roles:
SELECT name FROM roles WHERE users.id = ''
I have made a component that displays the role as well the rank in the avatar section of a message. For non-admin users to see the role, it was needed to perform above query using restadmin instead rest.
I think you can use a Json subquery The Community API v2 request (khoros.com) to get the roles too while still making only one API request. I've had to do something similar to get labels for messages.
Holy **bleep** it worked!
Here's a simple working Python script:
import json
import requests
headers = {
"li-api-session-key": "XXX",
"Content-Type": "application/json"
}
data = {
"users": {
"fields": ["login","roles"],
"constraints": [],
"subQueries": {
"roles": {
"fields": ["id", "name"],
"limit": 20
}
}
}
}
response = requests.post("https://[your community]/api/2.0/search", headers=headers, json=data)
print(response.json())
I'm looking forward to tweaking it a bit and using this in Excel or PowerBI PowerQuery. Thanks!
