Hi,
I am trying to create something like a Billing Statement that shows the actual list of sessions per Company for a given month.
Each company will receive a separate email that contains just the list of sessions.
I have an array aggregator that groups sessions by Company resulting in the data structure of the below screenshot.
The problem I have is that I can’t figure out how to access both the company name and array of sessions for each in downstream modules.
I’ve place an iterator immediately after the array aggregator and it seems I can iterate the list of keys OR the separate Company arrays.
If I iterate by Company (key), then I can’t figure out how to “reach back” and get the array (value) associated with that company.
If I iterate by Value (array of sessions) then while I will get the array of sessions, I won’t know for which company this array is for.
All i want is construct a set of emails that are mostly structured like the data in the screenshot (A company and its list of sessions.)
Scenario - Only top row of modules are connected.
Any help/guidance would be appreciated it.
Thanks!
Data Bundle here if helpful
[
{
“IMTKEY”: “Company 1”,
“array”: [
{
“id”: “rec42owHQ8BQTtMw6”,
“Duration”: 1,
“Event Date”: “2024-10-21”,
“Event End Time”: “10:30”,
“Event Start Time”: “09:30”
},
{
“id”: “recFkvSdyaQbgDCqp”,
“Duration”: 1,
“Event Date”: “2024-10-07”,
“Event End Time”: “10:30”,
“Event Start Time”: “09:30”
}
]
},
{
“IMTKEY”: “Company 2”,
“array”: [
{
“id”: “recLZ7Xw3eMUht0E8”,
“Duration”: 1,
“Event Date”: “2024-10-14”,
“Event End Time”: “17:00”,
“Event Start Time”: “16:00”
},
{
“id”: “recM0RAq2rRWbTA25”,
“Duration”: 1,
“Event Date”: “2024-10-14”,
“Event End Time”: “16:00”,
“Event Start Time”: “15:00”
},
{
“id”: “recQxZeihA9kd4KnN”,
“Duration”: 1.4166666666666667,
“Event Date”: “2024-10-11”,
“Event End Time”: “11:55”,
“Event Start Time”: “10:30”
},
{
“id”: “recRryqPRTiqzyp5d”,
“Duration”: 1,
“Event Date”: “2024-10-08”,
“Event End Time”: “11:00”,
“Event Start Time”: “10:00”
},
{
“id”: “recS9Klo1gz0LXpvt”,
“Duration”: 1,
“Event Date”: “2024-10-30”,
“Event End Time”: “17:00”,
“Event Start Time”: “16:00”
},
{
“id”: “recWd2rspDg89cspx”,
“Duration”: 1,
“Event Date”: “2024-10-29”,
“Event End Time”: “14:00”,
“Event Start Time”: “13:00”
},
{
“id”: “recb9LqXMFWmpmhjp”,
“Duration”: 3,
“Event Date”: “2024-10-28”,
“Event End Time”: “16:00”,
“Event Start Time”: “13:00”
},
{
“id”: “recev9GtrRIQWuEak”,
“Duration”: 1,
“Event Date”: “2024-10-22”,
“Event End Time”: “11:00”,
“Event Start Time”: “10:00”
},
{
“id”: “rech521BU0FWIuUr6”,
“Duration”: 1,
“Event Date”: “2024-10-03”,
“Event End Time”: “10:00”,
“Event Start Time”: “09:00”
},
{
“id”: “recnCeBxnQ2DdSd0R”,
“Duration”: 1,
“Event Date”: “2024-10-15”,
“Event End Time”: “11:00”,
“Event Start Time”: “10:00”
},
{
“id”: “recrb7v184UK98RU4”,
“Duration”: 3,
“Event Date”: “2024-10-21”,
“Event End Time”: “16:00”,
“Event Start Time”: “13:00”
},
{
“id”: “recsxnX8qVw8xBGjG”,
“Duration”: 0.5,
“Event Date”: “2024-10-15”,
“Event End Time”: “11:30”,
“Event Start Time”: “11:00”
},
{
“id”: “rectASwrsT1kiGs0o”,
“Duration”: 1,
“Event Date”: “2024-10-24”,
“Event End Time”: “13:00”,
“Event Start Time”: “12:00”
}
]
}
]