Pipelines | search records | make request api

Question

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 idAs 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------------------------------

ChayceDuncan · Answer

I do something similar with the realm info but instead of having it run off the access table - I have a series of Pipelines that search for production applications and run API_UserRoles which grabs all the users for a specific app and returns all user/role combinations. I then store that in a different table altogether to better track and report on users that may have multiple roles in the same app.

------------------------------
Chayce Duncan
------------------------------

Sign up

Login to the community