Asana API PHP：按经办人（assignee）列出所有任务及自定义字段

Hey Alexis, let's break down why you're hitting null results when trying to list tasks by assignee and pull their custom fields. Here are the most common pitfalls and fixes to get this working smoothly:

1. Double-check your task filtering logic #

First off, make sure you're filtering tasks using the correct assignee identifier for your tool (like Jira, Asana, etc.). Many APIs require using a unique ID (e.g., accountId in Jira) instead of a display name or username—using the wrong value will return empty results.

• For example, in Jira's JQL, you'd use assignee = "<user-account-id>" instead of assignee = "Alexis" (since usernames might duplicate or not map correctly).
• Quick sanity check: Manually verify in your task tool that the assignee actually has assigned tasks—sometimes null results just mean no tasks exist for that user!

2. Explicitly request custom fields in your query #

Custom fields almost never come included in default API responses. You need to explicitly specify which custom fields you want to fetch, usually by their unique ID (not the human-readable name).

• If you're using Jira, for instance, first call the /rest/api/3/field endpoint to get a list of all fields, then grab the ID of your target custom field (it'll look like customfield_12345).
• When querying tasks, add this ID to your fields parameter. Example Jira API call:

  GET /rest/api/3/search?jql=assignee=123&fields=id,summary,customfield_12345
  

  Skip this step, and your custom field values will always be null.

3. Fix variable binding in your user loop #

It's easy to accidentally hardcode an assignee value or pass the wrong variable in your loop. Double-check that you're dynamically using the current user's identifier when querying their tasks.

• Bad example (pseudocode):

  for (const user of users) {
    // Oops—using a fixed ID instead of the current user's ID
    const tasks = api.fetchTasks({ assigneeId: "123" });
  }
  

• Good example:

  for (const user of users) {
    const tasks = api.fetchTasks({ assigneeId: user.id });
  }
  

  Make sure the assignee filter is tied directly to the loop's current user object.

4. Verify API permissions #

Your API credentials might lack access to either the tasks assigned to certain users or the custom fields themselves.

• Test manually: Log into your task tool using the same account linked to your API token, then try to view the assignee's tasks and their custom fields. If you can't see them there, your API won't be able to either—reach out to your admin to adjust permissions.

Example working code (Jira + Python) #

Here's a quick snippet to illustrate the correct flow:

from jira import JIRA

# Initialize Jira client
jira = JIRA(server="https://your-jira-instance.com", basic_auth=("your-email", "api-token"))

# Get your list of users (adjust query as needed)
users = jira.search_users(query="")

# Loop through each user and fetch their tasks + custom fields
for user in users:
    # Use the user's unique accountId for filtering
    jql_query = f"assignee = '{user.accountId}'"
    # Explicitly request standard fields + your custom field ID
    tasks = jira.search_issues(jql_query, fields=["summary", "customfield_12345"])
    
    print(f"\nTasks assigned to {user.displayName}:")
    for task in tasks:
        custom_value = task.fields.customfield_12345
        print(f"- {task.key}: {task.fields.summary} | Custom Field: {custom_value or 'N/A'}")

内容的提问来源于stack exchange，提问作者Alexis