Using Collections / Nested Lists - my guide

Hi all - I wasn't able to find any documentation which specifically tells you how to use collections in a view or report. By using the API explorer and looking at some other examples of nested columns on the support site, I worked it out and made the following notes which may (or may not) be useful to others....excuse the terminology in places! How to use a collection (this example is to list all Job Roles for each User in a user report): View the API Explorer at https://developers.workfront.com/api-docs/api-explorer/ Find the object you want to get the list of items relating to (project, task, issue, user etc). Click on the Collections tab. Click on the data type you want. Copy the API Key into the green field below: displayname=Call this whatever you like listdelimiter= listmethod=nested( roles ).lists textmode=true type=iterate valueexpression={ name } valueformat=HTML 6. Click on the URL to the collection object and click on the field you want and copy the API Key in the blue field above. 7. Add a new column to a view or report and paste the above in text mode.