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) an...
Forum Discussion
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
------------------------------
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
------------------------------See attached. For my own process it ends up being (2) pipelines - the first is the loop that processes each app - and it send the JSON response to Pipeline (2) where it actually processes and loads the data. It's not the most clear and one day I may optimize it but you will notice that the actual user pipeline has 2 paths. Path one is for users that only have 1 role in the app - path two is for users that have multiple. In the majority event where people have only one role I put them into a bulk import to load together. For the other path where they have multiple roles I carve them out and do a jinja loop to import them right then given that the JSON format is different when QB passes it along. It wasn't ideal - but it was a reaction to an audit request and needed the most efficient way that needs to be revisited one day.
------------------------------
Chayce Duncan
------------------------------
