Get only a set of task custom_fields

Hi there.

First of all, hello to everyone. This is my first post, so let’s see what happens :slight_smile:
I would like to get all tasks from a project with specific fields. In particular, I need only three out of all custom_fields that a task may have. As I am importing data to a Google Sheet, I need a fixed number of fields coming. The problem is when a task belongs to several projects (each one with its own custom fields) and inherit all of them.

It would be something like

https://app.asana.com/api/1.0/projects/{project_id}/tasks?opt_fields=name,completed,completed_at,created_at,due_on,notes,parent.name,projects.name,assignee.name,memberships.section.name,custom_fields.name,custom_fields.enum_value.name

but with some kind of filter with specific custom_fields gid to filter by.

Any ideas?

Thanks in advance.

Alfredo M.

Hi @Alfredo_Martin and welcome to the forum!

Not possible, I’m afraid. You’ll have to retrieve all of the task’s custom fields and write some intermediate code to extract the field data you need, or write a Google Sheets script to do that.

Thanks a lot @Phil_Seeman.
I will try with Google Sheets script.

Alfredo

1 Like