ContributionsMost RecentMost LikesSolutionsAPI_GetUserRole | Multiple Roles Hello, Hopefully this is simple for a jinja2 master. I have a pipeline that is running the API_GetUserRole. I have everything working, except for when a user has multiple roles. When that happens, I get a blank value for role_id and role_name. I shortened the jinja2 to pull all data so I can see what is happening. Here is the jinja2 to pull everything: {{ b.json.qdbapi.user.roles }} Here is the output on the QuickBase record: OrderedDict([(u'role', [OrderedDict([(u'@id', u'45'), (u'name', u'Claims - Processor (Incela/Hawaii Legacy)'), (u'access', OrderedDict([(u'@id', u'3'), ('#text', u'Basic Access')]))]), OrderedDict([(u'@id', u'55'), (u'name', u'EUTF Add/Edit'), (u'access', OrderedDict([(u'@id', u'3'), ('#text', u'Basic Access')]))])])]) This is what I hope to accomplish and see within the record: Role_ID: 45 ; 55 Role_Name: Claims - Processor (Incela/Hawaii Legacy) ; EUTF Add/Edit This was my last attempt at Jinja which output the value of "No roles assigned": {% if b.json.qdbapi.user.roles %} {% if b.json.qdbapi.user.roles.role %} {{ b.json.qdbapi.user.roles.role['@id'] }} {% else %} Role ID not available {% endif %} {% else %} No roles assigned {% endif %} Any ideas? ------------------------------ QuickBase Administrator2 ------------------------------ Re: Auto Deselect to show in User Pickers when user has no access or is on the Deny List. Hey Chayce, Do you have documentation for the api_removeUser? I searched and only found api's which remove users from groups, or change a user's role. I didn't find anything on removing a user from an Application however ------------------------------ QuickBase Administrator2 ------------------------------ Re: Price Per Read First off, I am so sorry. I appreciate you being vulnerable and bringing this up in the discussions. We are currently on a user-based plan and are due to renew this year. I will be confirming with my account executive about whether or not QuickBase forces a plan change from user-based to reads-based. If it's true, we likely need to move to another platform prior to our renewal. I would be greatly disappointed with QuickBase if they didn't allow one to be grandfathered into their old plan and keep it how it was. Even shady phone carriers allow users to keep their old plans that are no longer available to the public. ------------------------------ QuickBase Administrator2 ------------------------------ Re: Pipelines | search records | make request api Nice! If it's not too much trouble, would you be able to take screenshots of that pipeline and their respective steps so I can hopefully recreate it? I would make it easier and ask for the YAML, but I haven't had success with reading that language and recreating what it says quite yet - it's a bit hard to follow ------------------------------ QuickBase Administrator2 ------------------------------ Pipelines | search records | make request api Hello, I have a table called Access that is populated via the access admin console. I am utilizing 4 fields from this table, [User ID] and [App ID] (used for data within the URL API_GetUserRole) and [Role ID] and [Role Name] (which is populated after the api runs). My pipeline that is doing this works (thanks to help from @SamuelTrachy with the jinja2), but is not optimized well.. Currently the pipeline is: A. Search Records on the Access table for each A record found... B. Make Request (https://.....?a=API_GetUserRole.....) C. Update record A with role name and role id As mentioned above, this works, however, I am just looking to see if there is a more efficient way to run this. ps. I am confident with pipeline things, but am a rookie with API/ make request/ json/xml things. So I may need things dumbed down a bit when speaking about these things. Thank you ------------------------------ QuickBase Administrator2 ------------------------------ Re: Scheduled Pipelines url Thank you! ------------------------------ QuickBase Administrator2 ------------------------------ Re: Scheduled Pipelines url Okay, that makes sense. That's a cool idea! Are you able to showcase your pipeline grabbing users and roles so that I can view the structure and try to understand how it works? ------------------------------ QuickBase Administrator2 ------------------------------ Scheduled Pipelines url Hello, In simple terms, I have a code page which is triggered by a user clicking a formula url button. Once this happens, the application is updated via api's. My question is, is there anyway to utilize pipelines to automatically "click" this button (there is only 1 record on this table) or run the same formula within the formula url button to trigger the code page on a scheduled basis? This button needs to be pressed on this record since it captures some data from the record/ table it lives in. Eventually there may be one or two records more, so I would like to keep this aspect of it dynamic Thank you for your time ------------------------------ QuickBase Administrator2 ------------------------------ Re: extracting parts of text for the purposes of new date fields Worked perfectly! Thank you ------------------------------ QuickBase Administrator2 ------------------------------ extracting parts of text for the purposes of new date fields Hello, I have a field that imports in the following manner every single time with no variation to the format: [statement_dates] = 20230731-20230814 My question is, how do I split this up into: [Date one] =20230731 [Date two] =20230814 These would also be recognized as dates by QuickBase Thank you in advance ------------------------------ QuickBase Administrator2 ------------------------------