Bubble <> Asana Projects (Tasks) Pagination

Need help APIs
1

Does anyone have a definitive approach to achieving pagination (offset) between Bubble and Asana? I have an Asana Project with 227 Tasks that I need to extract but Bubble steadfastly refuses to accept API Call Data from Asana as a List and insists on treating it as a Text block, instead. I have set up backend workflows to fire off API Calls until the offset no longer appears but Bubble cannot resolve the API Call response as a List to insert records into my local data table.

The premise is simple enough:

How do I extract more than 100 records (Tasks) from an Asana Project, as a best practice?

Thanks!
Adam

2

Are you sure the API Connector validation is correct?

Look at Asana’s API Docs.

It returns an arrary called “data” with a list of task objects:

{
  "data": [
    {
      "gid": "12345",
      "resource_type": "task",
      "name": "Bug Task",
      "resource_subtype": "default_task",
      "created_by": {
        "gid": "1111",
        "resource_type": "user"
      }
    }
  ],
  "next_page": {
    "offset": "eyJ0eXAiOJiKV1iQLCJhbGciOiJIUzI1NiJ9",
    "path": "/tasks/12345/attachments?limit=2&offset=eyJ0eXAiOJiKV1iQLCJhbGciOiJIUzI1NiJ9",
    "uri": "https://app.asana.com/api/1.0/tasks/12345/attachments?limit=2&offset=eyJ0eXAiOJiKV1iQLCJhbGciOiJIUzI1NiJ9"
  }
}

When you validate the call in the API Connector, what does the response look like?

3

Thanks for taking the time to look at this - I am fully aware of the processing that should work - it simply does not. I am asking if anyone has the definitive method to extract and use the pagination/offset provided in the initial JSON payload being returned by my API Call, to allow me to get more than 100 Tasks from an Asana Project.

At present, when I send a GET URL including the offset value, Asana continues to return the first 100 records (N1) - not the second set of 100 records (N2).