Get the role of a user in a user field

ChayceDuncan
Qrew Captain
9 months ago
I'm not sure I understand. Are you asking how you grab the role value to log back into Quickbase?

If that's correct - then you need to target the right part of the JSON response and put that into your update record. So lets say your trigger is on the new record - then you look up the user and then you want to update the value of 'Assigned To Role' in the original record then you would just do a regular update record action, and in the input for Assigned To Role you would do something like;

{{b.json.qdbapi.user.roles.role.name}}

Where b is the request step to get the role. The json.qdbapi.... is the key path structure to get the name of the role.

------------------------------
Chayce Duncan
------------------------------
- CarolMcconnell
  Qrew Captain
  9 months ago
  Yes, that is exactly what I'm wanting to do. I'm getting an error, this field contains invalid jinga references. {{b.json.qdbapi.user.roles.role.name}}
  
  ------------------------------
  Carol Mcconnell
  ------------------------------
  - ChayceDuncan
    Qrew Captain
    9 months ago
    Can you screenshot or download the yaml to post here to look at? The jinja I provided is based on the key path for a single role in my example and works for me - you should be able to confirm by looking at the activity log and specifically under the request to get the role you should get something like this in the log:
    
    ------------------------------
    Chayce Duncan
    ------------------------------

Forum Discussion

Get the role of a user in a user field