API guide: Exporting team membership

In-app Team membership download

To download a list of team members:

1. Click Settings in Flow's top navigation bar.
2. In the left navigation under User management, click Teams.
3. Click the download teams button on the top right. A CSV file of your team members will download.

back to top

How to export team membership data using the API

Follow the directions below to export the following information by team:

• User ID
• Author Name
• Author Email

If you're logged into Flow you can paste the below API call into a browser window. You can also use an API client like Postman with an API key.

https://HOSTNAME/v3/customer/core/users/?limit=1000&team__name=YOUR_TEAM_NAME

• HOSTNAME: The IP address or URL for the Flow application. If you’re using the cloud instance of Flow, this will be flow.pluralsight.com. If you’re using an on-premise version of Flow, this will be something other than flow.pluralsight.com.
• YOUR_TEAM_NAME: This is the Flow team for which you’re trying to get user information.

The above API call will return all available fields for each member of the team. You can further refine your results so that you’re only grabbing the data you want to extract using the fields= parameter as show below:

https://HOSTNAME/v3/customer/core/users/?limit=1000&team__name=YOUR_TEAM_NAME&fields=id,name,email

• fields=id,name,email: Using the fields parameter will only return these specified fields in your query.

Your results will look something like this:

{    "count" : 20 , //total number of Users that met your criteria
    "next" : null , // NOTE: If you had more than 1000 Users,
                    //this tag would help you get the rest of them
    "previous" : null ,
    "results" : [
        {
            "id" : 20812395 ,
            "name" : "Sally Smith"
            "email" : "sally.smith@mycompany.com"
        },
        ...
        {
            "id" : 3335303 ,
            "name" : "Jess Palmere"
            "email" " jess.palmere@mycompany.com"
        }
    ]
 }

back to top

Export using the Team_Membership API

Alternatively, you can use the Team_membership API to obtain all teams and their memberships with a single query. You may also use the team name or ID endpoints to narrow your query to a single team.

Once you have identified which fields you would like to export you can append the following parameter to the end of your query to export it via a CSV file.

• format=csv

Your final query will look something like this:

https://HOSTNAME/v3/customer/core/users/?limit=1000&team__name=YOUR_TEAM_NAME&fields=id,name,email&format=csv

back to top

Import your data into Excel

The format=csv argument causes the API to return CSV formatted results that you can then import into Excel.

1. Open Microsoft Excel
2. Click Data then Get Data and finally, click From Text/CSV. The data open in the query window.

   

3. Locate the downloaded file.
4. Select the Load To… option located at the bottom of the window as shown below:

   

5. Select Table from the list of options:

   

6. The data loads in the current workbook

back to top

If you need help, please contact Pluralsight Support.