Skip to main content
Solved

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

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

View original
Did this help you find an answer to your question?

3 replies

geomancer
Evangelist
Forum|alt.badge.img+47
  • 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+47
  • 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.

Reply


Helpful Members This Week

Community Stats

31,105
Posts
117,925
Replies
38,857
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
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.