ContributionsMost RecentMost LikesSolutionsRe: Unable to change SSO ID of user with the API Hi Aman, Thanks for your response! Much appreciated the help on this. So I am assuming we need write a custom component even it's for a one time data update? If yes, we need to execute the script and then delete the component ? as we won't be needing this after this one time data update/cleanup? Also, to execute this in prod instance where studio tool is not available, what would be the triggering point for this code in custom component once we deploy this to production? is it right after a successful deployment of the component? Thank you, Swetha Re: Unable to change SSO ID of user with the API Thank you! Where do we write this code? if I create a custom component with this code what triggers or calls this code in order this to be executed? Re: Forcefully assign SSO_ID to a user via API Hi TariqHussain Can this be used within Studio code editor for a one time update of bulk user sso or this freemarker code to call restapi has to be written using a custom component ? trying to understand where can we execute this piece of code for one-time update? Thanks Swetha Re: Unable to change SSO ID of user with the API Hi jeffshurtliff , I have a similar requirement to update SSO IDs of bulk users. Can the above method be called for bulk update within khoros studio tool without using Python or SDK ? Re: How to retrieve all the users data using LiQL/API with email/SSO_id filter? Thanks akshays I am looking for a solution for one time bulk update of users is and work arounds for limitations/restrictions around of SSO_ID and email fields in the LIKE and WHERE clause of LiQL. I cannot use SSO_ID with LIKE and email in WHERE of LIiQL. I need this to query/update the data based on filter criteria. How to retrieve all the users data using LiQL/API with email/SSO_id filter? Hi All, New to Khoros and I am trying to figure out how to retrieve and as well as update the bulk users data. How can I retrieve all the users data using LIQL/ API calls? I need to retrieve all the users to update the email of bulk users (replacing invalid emails with valid emails). How can I query all the users in our community? also how to use SSO_ID or email with LIKE or MATCH in LiQL to query users that has email/SSO_ID with certain pattern (query all user with email or sso ends with "@company.com"). It seems like email cannot be user in where and SSO_Id cannot be used with LIKE, are there any other ways to apply filter for these two columns? I do see that API 2.0 results in only 25 records when I execute with below API https://community.mycompany.com//api/2.0/search?q=select+*+from+users. Appreciate any direction Re: Can we show the event calendar component only on group hubs with event discussion style enabled? Appreciate it thank you! From the first part of the comment, were you able to hide the event calendar side component on your group hub page for certain group hubs? Re: Can we show the event calendar component only on group hubs with event discussion style enabled? Thanks Akenefick We are using the standard group hub page for all our group hubs and looking to see if there are options to toggle off the even calendar side component on some and show it on others. Can we show the event calendar component only on group hubs with event discussion style enabled? Can we scope the calendar event component ONLY on those group hubs that have Event discussion style enabled? For Example: Group Hub1 (with all four discussion styles enabled) forum Article Suggestion Event Group Hub2 (with only Article discussion style enabled) Article So, when the even calendar component is added on group hub page, the component is displayed on all the group hubs on community (in above case it's added on both group hubs with and without event discussion style enabled). Can we scope it to only group hubs with Event discussion style enabled ? In the above example we would want it to be displayed only on Group Hub1. Is there a parameter that can be configured to toggle this setting on this component? <component id="occasions.widget.calendar" />