Trimble Connect User Forum

Diego Ortega posted 10-09-2023 06:33

Hi David,

We extract project information using the Trimble API in Python, iterate over projects, and append user info to a pandas dataframe. Ex:

projects = trb.get_projects() #Get project info 
AllUserInfo = []
for project in projects: #Iterate projects
    users = trb.get_project_users(project["id"]) #Get users
    allUsers.append(data) #Append data

df = pd.DataFrame(allUsers)
df.to_excel("user_list.xlsx") 

Regards,

David JOSEPH posted 10-09-2023 06:45

Hello @Diego Ortega,

Thanks for the reply, cool ... but how is the link made from trimble connect?

BR
David

Diego Ortega posted 10-09-2023 09:18

For use the API you need the credentials, you can get it from Trimble Connect support :

Next, introducing and logging your credentials with postman you can get an access token to make requests in python, for more details check AuthGuide.

When you have an access token with python request library, you can use endpoints from TrimbleAPI,

For example, to get all information about your projects where token variable is "access_token [token generated by postman]":

This response of the requests:

Finally, you convert dataframe to excel and get the report by projects of all user. For my case, we also want information about the groups of each user is included. So we request the groups by project Id and add this information.

David JOSEPH posted 10-10-2023 00:16

Hi @Diego Ortega

Thanks a lot for this very complete answer !
the suggestion to TRIMBLE to add this possibility directly in the administration area is still valid :D 

BR
David