Power BI ACC Connector: How to Resolve assignee_id When Type Is "role" or "company"?

[andresj_brito]

Hi everyone,

I'm using the Autodesk Construction Cloud connector in Power BI, and I'm trying to correctly identify the assignees from the issues_issues table.

There are two fields related to the assignee:

• assignee_type, which can be "user", "role", or "company"

• assignee_id, which stores the corresponding ID

When assignee_type is "user", everything works fine — I can match the assignee_id to the autodesk_id field in the admin_users table to get the name.

However, when assignee_type is "role" or "company", I can't find any matching IDs in the admin_roles or admin_companies tables. The assignee_id doesn't seem to correspond to any existing field in those tables.

So my question is:
How can I retrieve the name of the assignee when the issue is assigned to a role or a company?

I want to display in Power BI who is assigned to each issue, regardless of the assignee type. Any documentation, mapping reference, or advice would be appreciated.

Thanks in advance!

[carlota_zamora7BF6U]

i just had the reversed issue from yours! thanks, this helped me mapped my user assignee type.

for the role assignee type, try finding it under admin_project_roles then role_oxygen_id. hope this helps.