Expand my Community achievements bar.

SOLVED

Learning External Lookup, need Team members from particular team.

Avatar

Level 2

Hello Community.  I have started to think about switching over our current custom Fields we have that list team member (just values).  that we have to manually manage everytime a user leaves etc.   To using the External Lookup to dynamically display the Team Members.  This way, the Manager of the Team can more easily manage the Team and the list,  And then in my custom forms the list is always up to date.  

However, I can't seem to figure it out. I honestly don't know what I am doing here.   I have been able to write a API URL that will pull a top level item like Portfolio names but I can't seem to get more than that. I keep getting errors in my Projects.  

Does anyone have an example API URL that they are pulling Team member from a particular Team name?

My current attempt is: $$HOST/attask/api/v18.0/PORT/search?ID={62bc509f0078fa8703af0eda89d16e7d}&fields= teammembers

with the JSON Path being: $.data[*]. teammembers

The Errors I keep getting are similar to: 
An error occurred while making a call to the mentioned API endpoint (URL: https://meredith.my.workfront.com/attask/api/v18.0/PORT/search?ID=&fields=+teammembers, Status Code: 422). Please check your parameters and try again.

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

In your current attempt, the "PORT" part indicates that you are still searching for portfolios. I suggest you start with a search for users instead, something maybe like this:

 

$$HOST/attask/api/v18.0/USER/search?teamIDs=______________&teamIDs_Mod=in

 

(please note, no parentheses needed around the team ID)

 

and JSON path would be more like $.data.[*].name -- assuming you are trying to pull the team member names. i.e. try and make this line the individual line item, e.g. I'm trying to pull in a list of X, where X might be the name, email address, ID, DOB, etc.

View solution in original post

2 Replies

Avatar

Level 2

FYI, I forgot to mention that ID number in my URL, is the ID of the Team that I am trying to display the Team Members of in my External Look up Field.

Avatar

Correct answer by
Community Advisor

In your current attempt, the "PORT" part indicates that you are still searching for portfolios. I suggest you start with a search for users instead, something maybe like this:

 

$$HOST/attask/api/v18.0/USER/search?teamIDs=______________&teamIDs_Mod=in

 

(please note, no parentheses needed around the team ID)

 

and JSON path would be more like $.data.[*].name -- assuming you are trying to pull the team member names. i.e. try and make this line the individual line item, e.g. I'm trying to pull in a list of X, where X might be the name, email address, ID, DOB, etc.