Select messages where user *doesn't have* FooBar role?
Objective: Create message list of messages posted by non-employees. SELECT yada, yoda FROM messages WHERE depth = 0 ** AND USER DOESN'T HAVE EMPLOYEE ROLE ** ORDER BY conversation.last_post_time LIMIT 100 From the LiQL reference, I don't see a constraint that will allow this. Is this possible?114Views0likes2CommentsCan we Bulk Import "Category Expert" Contextual Roles?
I have over a hundred "Category Experts" to add to 26 boards. (different experts per board.) In the documentation, I do not see anything on Bulk Import supporting contexts, so I'm assuming it's not possible. https://community.khoros.com/t5/Roles-and-permissions/Import-user-roles-from-a-CSV-file/tac-p/731416#M194 Does anyone know otherwise?78Views0likes2CommentsHow to create API accessible user account with Community
I am new to Khoros platform and want to crawl data from community. For that I did signup process with one lithium community and got my username and password. I am trying to authenticate myself with via retrieve-the-session-keybut api response says curl --location --request \ POST 'https://community.alteryx.com/restapi/vc/authentication/sessions/login' \ --form 'user.login=dshrm' \ --form 'user.password=****' <response status="error"> <error code="302"> <message> User authentication failed. </message> </error> </response> I am trying to get user details via LiQl basic query `select * from users limit 1` What exactly process do I need to follow to authenticate myself ?521Views0likes11CommentsCan I assign signatures to everyone who doesn't have one?
I'd like to - by default - set users' signatures to their name (First Last) Our users' First & Last names are getting passed in by our IdP/SSO. I'm under the impression this can't be done automatically, BUT, is it possible to create a script to run periodically that'll do: for each user{ if (signature == ""){ signature = First Last } } If so that'd be sweet105Views0likes1CommentPermissioning for Limited Access Areas - am I about to do it wrong?
I'm about to configure boards for our partners & customers, who will have limited access....and the method I'm about to try seems too extensive to be the right way. For most of our community, we have an internal/external parallel structure, like: Product Forums Product A (category) Product A Forum [internal] Product A Forum Product A TKB Product B (category) Product B Forum [internal] Product B Forum Product B TKB etc. Objectives: Employees have access to everything. Partners & Customers don't have access to anything labeled "[internal]" Role Permissions (as of now) All Registered Users (auto-assign on registration): CAN'T view or participate in Employees (passed in by our IdP): CAN view & participate in all areas So far so good. But, we have a test partner (Dave) with the role "Client/Partner" (as passed in by our IdP). I'd like to open up all boards (except internal) for the Client/Partner role so Dave can hop in and participate. How should I configure this? (without guidance, I'd go into each non-internal forum, and configure the Client/Partner role to be able to view/post/etc. But that seems excessive - it'll involve making the same configuration like 25 times for *each* role that needs permissions, AND having to keep up with this with each new board we launch.)97Views0likes3CommentsHow to update an user role to a user through an API call
Tried updating the user role to an user by using an API call put: {{khoros_base_uri}}/api/2.0/users/295 BODy: "data": { "type": "user", "roles_to_add": ["t:'ECMS 2'"] }} responce: 200 success Now i used a Get call to check the role is updated in the user profile. Get: {{khoros_base_uri}}/api/2.0/search?q=SELECT * FROM roles WHERE users.id = '295' Response : 200 success But the role is not added to the user data in get call please let me know Thanks surendra123Views0likes1CommentWhat permissions are needed for an API call that adds a role which has name spaces for another user
We need to update the user roles (a role which happens to also imply a badge) eg: ECMS 1,ECMS 2 which has name spaces to an user. we tried to do that as below but its showing error message. PUT : http://community.lithium.com/community-name/api/2.0/users/2 BODY: "data": { "type": "user", "roles_to_add": ["t:ECMS 2"] } } HEADERS: session key Response: 403 forbidden { "status": "error", "message": "Permission Denied", "data": { "type": "error_data", "code": 414, "developer_message": "UserRef[id=294] does not have access to RequiredPermissions[(allow_creation_of_external_badges)] on CommunityByDisplayIdRef[nodeType=StandardNodeType[nodeType=lithium.coreapi.community.ICommunity,entityTypeKey=EntityTypeKey[community],entityTypeUid=4,hashCode=1653728538],displayId=yuzje69629]", "more_info": "" }, "metadata": {} } Thanks surendra164Views0likes2Comments