Extracting Data from Collections of Arrays

Hi All,

I’m trying to setup a new scenario so that my team can track time on project effectively, time is tracked within ClickUp.

High Level Breakdown:

  1. HTTP Request - Pulls back all time tracking entries between dates X & Y
  • Response (I’ve updated values for privacy reasons, only one data collection is shown but normally the request returns 20-150 entries depending on date entry):
    HTTP Response Example.txt (4.7 KB)
  1. Each time tracking entry is individual, i.e. multiple entries could be related to the same task. I want to be able to group all of a customers entries together while listing each task entry individually.
  2. I’ve got something working, but I’m not receiving the value from the original request, I’ve detailed this in my screen shots below.

Overall Scenario image:
Screenshot 2024-07-25 at 17.13.52

Iterator Config:
Screenshot 2024-07-25 at 17.14.00

Table Aggregator: (duration & task have been selected but I couldn’t show both)

Example of Table Aggregator Output:
Screenshot 2024-07-25 at 17.17.00

As you can see from the screenshot above all I’m getting from the output is “object Object”, everything else (duration & key) is showing how I’d like it.

Any help would be gladly appreciate, please let me know if I need to provide any further information.

1 Like

Hi @Duncan_Green

Thanks for reaching out to the community. You can use an Array Aggregator module instead of Text Aggregator.

Here too, you can use group by. Once tested, please let us know the results.

Regards,
Msquare Automation - Gold Partner of Make

Book a Free Consultation | Connect Live

Explore our YouTube Channel for valuable insights and updates!

3 Likes

This worked perfectly, thanks very much!

1 Like