Hi, yes I do use the GET API to pull a JSON response. You wont be able to use groups or filters as easily as drawing down the data and manipulating it yourself. you should be using: " https://mrc.my.workfront.com/attask/api/v10.0/issue/search?" then your filters, custom fields, projectID's etc. Then...

Kathy, thank you ! It Worked! You are a WorkFront ninja! Thank you, Nick Patel

I tried this as well... displayname=MANAGERS querysort=IF(ISBLANK(valuefield=assignedTo:homeTeam), valuefield=team:owner:name, valuefield=assignedTo:homeTeam:owner:name) textmode=true valueexpression=IF(ISBLANK(valuefield=assignedTo:homeTeam), valuefield=team:owner:name, valuefield=assignedT...

This is what I have. It's not working. not sure why. Its just the team Owner's name's where one is blank, fill in the other field. displayname=MANAGERS querysort=IF({assignedTo:homeTeam:owner:name}=blank, {team:owner:name}, {assignedTo:homeTeam:owner:name}) textmode=true valueexpression=IF({assigned...