Skip to main content
Solved

How would I use a loop transformer to be able to get a list of tasks from different projects?

  • December 22, 2023
  • 3 replies
  • 66 views
yjeon
Participant

If anyone is using Asana, please help me. I have the portfolio, projects, and users table in my FME workspace. I am trying to figure out a way to be able to use the project GID to be able to get their tasks but there's a problem with the tasks table. The task api has an endpoint to ONE projects. I am envisioning where I can pick different projects and be able to look at their tasks.

 

Does anyone have any idea? I was thinking about looping but I'm having a hard time understanding how I would loop if the task's api can only GET one project.Screenshot 2023-12-22 151106

Best answer by geomancer

Can you call the Tasks api after reading in the project data? In this way you pass one feature for each project, and I expect you should then be able to read the tasks of each project.

image

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

3 replies

geomancer
Evangelist
Forum|alt.badge.img+60
  • geomancerEvangelist
  • Evangelist
  • Best Answer
  • December 27, 2023

Can you call the Tasks api after reading in the project data? In this way you pass one feature for each project, and I expect you should then be able to read the tasks of each project.

image

yjeon
Participant
  • yjeonParticipant
  • Author
  • Participant
  • January 4, 2024

@geomancer​ 

Few issues I'm seeing is that 1) I get an error with how many request I am making to Asana which is an issue OR 2) I'm having issues with the httpcaller based on Asana API.

 

The end part of this is that all of these will be in Snowflake and that is where I would be pulling different data for reports. The task table is preventing me from moving forward because I'm not sure how I would just connect in order to request the reports. One of the few reports I need to pull would be getting all the data of the projects to see how long each project took to complete and how long each task in each project took.

geomancer
Evangelist
Forum|alt.badge.img+60
  • geomancerEvangelist
  • Evangelist
  • January 12, 2024

Probably you make too many requests at the same time. It may help to set the Number of Concurrent HTTP Requests or the Maximum Requests per Interval in the HTTPCaller.

You can also add a Decelerator transformer before the HTTPCaller.

Community Stats

32,154
Posts
122,047
Replies
39,812
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.