"team: Not a recognized ID: 171848739495" Trying to get tasks from the organization into Google Sheets

Purpose: I’m a project manager (not a developer) looking for a way to count tasks due next week for my workspace, so I’m trying to understand the API so I can get all the data into Google sheets and then create a pivot table to count tasks by due date range for each person no the team to predict workload problems.

Task: I’ve tried to get the workspace ID from both the Asana UI (that part of the URL) and from https://app.asana.com/api/1.0/workspaces.

I’m using the “API Connector” add-on in Google Sheets.

I’m getting the following 404 error:
{“errors”:[{“message”:“team: Not a recognized ID: 171848739495”,“help”:“For more information on API status codes and how to handle them, read the docs on errors: https://asana.com/developers/documentation/getting-started/errors”}]}

Can someone help me get a valid workspace id for my organization?

Thanks!

Chris

Hi @Chris_Stadler,

From the error message, it looks like you’re passing the workspace ID in a place where the Asana API is expecting a team ID. I’m not familiar with that connector but can you post a screenshot(s) of it with values filled in? (except don’t show any auth tokens)

3 Likes

Thanks for pointing that out. I conflated “teams” with “organization.” That part is working now.

PS: I don’t suppose there’s a way I can get a list of another user’s task, is there (even though I have access in Asana)? I’m now getting (403) Forbidden.

Thanks!

Chris

2 Likes

Never mind. I just found a possible answer in another thread. Thanks!

3 Likes

Hi Chris,

I have had trouble interrogating the API to build custom reports myself. For what you are looking for, just running a CSV from the project(s) folder then a macro that creates a pivot table with only the required fields you need.

Precisely.

I would add that I need all tasks from everyone for the next 10 days, so I can count tasks that are upcoming.

I really want to learn to do this because I need to do the same kind of thing (API interactions) in order to pull data from Quickbooks and other services.

Zapier might be an option, but I haven’t seen the ability to define a workspace in Zapier or define a user and download all of their tasks.

Have you had luck, Pete?