Query project user access using api

[Pol Monroig]

I would like to know how can I query the access to each project using the ftrack api. What I mean by access is this https://help.ftrack.com/en/articles/3601282-managing-project-access ,not the roles but the access to each specific project by user. I am using the javascript api but I think python would be the same, the problem is creating the specific query. 

I appreciate the help! Thanks

[Erik LaPlant]

 

You could try:

 

>>> p = session.query('Project where id is "<INSERT PROJECT ID>"').one()
>>> for role in p['user_security_role_projects']:
...     print(role['project']['name'], role['user_security_role']['user']['username'], role['user_security_role']['security_role']['name'])

 

[Pol Monroig]

Hello, thanks for your reply, that seems to work in Python although in javascript I do get an error when running the query. I only get the error when asking for the user attribute, without it it does return me a list of security roles but just with Ids

session.query('select name,user_security_role_projects.user from Project');

"No attribute u'user' exists for schema u'UserSecurityRoleProject'."

[Patrick Boucher ftrack]

Hi Pol,

Off the cuff, it looks like you're missing `user_security_role` in that projection chain. Could you try:

select name, user_security_role_projects.user_security_role.user from Project

Regards,
Patrick

[Pol Monroig]

Hey Patrick, 

 

Thanks you are right!! I got confused by the two types of user_security_roles haha it works now

 

[Patrick Boucher ftrack]

Awesome, Pol. I'm happy you've got things running and thanks for letting us know.

Have a great week!
Patrick