Need help in configuring scenario of sending email

How To
,
1

Hi Guys,

I Have a glide table called tasks which has task name, Task owner email Id and Due date.
Every day at 6 PM IST the glide table is fetched for tasks and it should send the List of tasks in In progress and Not Started tasks to respective users

I have been able to configure following actions successfully so far.

Schduler to get all rows of Glide table.

Iterator to iterate through each row and Filter to fetch rows with status “In progress” or “Not Started”

Array Aggregator to get Array of items. Grouped by Users name

Need help in configuring next steps

What should I do next so that it iterates through every element in the array and gives the email id and task name as input to my Email module.

PS: only grouped tasks by user name should be sent to email ids

Here is my Array Aggregator data

Screenshot 2024-09-17 at 12.10.20 PM
Screenshot 2024-09-17 at 12.10.20 PM838×1112 95.7 KB

Should I use Iterator module again? Tried doing it but it is returning empty value.

Screenshot 2024-09-17 at 12.17.11 PM
Screenshot 2024-09-17 at 12.17.11 PM1670×1130 157 KB

Returns empty value

Screenshot 2024-09-17 at 12.17.23 PM
Screenshot 2024-09-17 at 12.17.23 PM1076×1006 103 KB

Thank you in advance for your help.

Regards,
Dilip

2

Hi Guys,

I have Used the array Iterator after Arry aggregator for iterating through all Array elements it still gives me Empty array in Array Iterator output.

Screenshot 2024-09-17 at 3.42.45 PM
Screenshot 2024-09-17 at 3.42.45 PM525×549 44.3 KB

Can I pass array Aggregator output as shown below?
Screenshot 2024-09-17 at 3.44.38 PM

Thank you in advance for your help

Regards,
Dilip

3

Hi Guys,

By following various things from community I think I dont need to use Iterator again,

Rather use Text aggregator.

I have constructed text Aggregator as follows

Screenshot 2024-09-17 at 4.14.35 PM
Screenshot 2024-09-17 at 4.14.35 PM1230×1582 202 KB

The Output I get is as follows :slight_smile:

Screenshot 2024-09-17 at 4.14.46 PM
Screenshot 2024-09-17 at 4.14.46 PM1000×1424 117 KB

It does not out put List of email Id’s Nor the tagged things in email body.

Not sure what am I doing wrong.

Thank you in advance.

Regards,
Dilip

4

Hi @Dilip
If you can share the output bundle of get rows module we could further assist you.

How to Share Input/Output bundles

To obtain the input and output bundles for each module:

  1. Run the scenario or retrieve it from the History tab.
  2. For each module, click the white speech bubble located at the top-right corner.
  3. Select “Download input/output bundles” from the dropdown menu.

This will allow you to download the necessary data for further analysis and sharing.

image
image800×449 40.9 KB

Method 1: Attach a Text File

  1. Copy the output data.
  2. Paste the data into a text file.
  3. Attach the text file to your ticket.

Method 2: Direct Sharing

  1. Use the direct sharing option available in the reply section. Please refer to the image below for guidance.

image
image800×178 30.8 KB

Best regards,

Msquare Automation
Gold Partner of Make
@Msquare_Automation

5

HI @Msquare_Automation ,

Thank you for replying.

Please note that After my Get rows I have Data Iterator → filtering data and Data Aggregator which is giving me relevant data.

I am stuck after that.

My Data Aggregator out is as follows

[
    {
        "__IMTKEY__": "umair@aflog.in",
        "array": [
            {
                "Name": "follow up to get confirmation from Chandan",
                "1efVG": "Umair Alam",
                "5FVfD": null,
                "6bd7F": "umair@aflog.in",
                "9RssK": null,
                "FBHdW": "High Priority",
                "O5yhk": "2024-09-17T06:00:00.000Z",
                "V6xmb": "2024-09-17T11:53:08.487Z",
                "aOir0": null,
                "lgfkM": "Not Started",
                "rJdNM": "Chandan Biswal - GreenPly Samet India",
                "t6ioc": null,
                "vFVIH": null
            }
        ]
    },
    {
        "__IMTKEY__": null,
        "array": [
            {
                "Name": "other ideas such as Meet and greet or a round table story (Can be ppc) for; #Beingawoman ",
                "1efVG": "Sanya Menon",
                "5FVfD": null,
                "6bd7F": null,
                "9RssK": null,
                "FBHdW": null,
                "O5yhk": "2024-08-13T17:07:00.000Z",
                "V6xmb": "2024-08-12T17:06:23.572Z",
                "aOir0": null,
                "lgfkM": "In Progress",
                "rJdNM": "Stuti Ashok Gupta - Amrutam",
                "t6ioc": null,
                "vFVIH": null
            },
            {
                "Name": "Send product list to the selected creators and also asking for their correct address",
                "1efVG": "Ashish Krishna",
                "5FVfD": null,
                "6bd7F": null,
                "9RssK": null,
                "FBHdW": "High Priority",
                "O5yhk": "2024-09-17T18:00:00.000Z",
                "V6xmb": "2024-09-16T13:09:44.004Z",
                "aOir0": null,
                "lgfkM": "Not Started",
                "rJdNM": "Sikha Chinee - Pigeon",
                "t6ioc": null,
                "vFVIH": null
            },
            {
                "Name": "add more Bangalore profiles",
                "1efVG": "Pratiksha Sharma",
                "5FVfD": null,
                "6bd7F": null,
                "9RssK": null,
                "FBHdW": "Mid Priority",
                "O5yhk": "2024-09-16T14:00:00.000Z",
                "V6xmb": "2024-09-16T15:11:40.805Z",
                "aOir0": null,
                "lgfkM": "In Progress",
                "rJdNM": "Shalika - Soch",
                "t6ioc": null,
                "vFVIH": null
            },
            {
                "Name": "Get thr brief from Shivani (founder)",
                "1efVG": "Varun Krishnamurthy",
                "5FVfD": null,
                "6bd7F": null,
                "9RssK": null,
                "FBHdW": "High Priority",
                "O5yhk": "2024-09-13T13:30:00.000Z",
                "V6xmb": "2024-09-12T20:58:39.781Z",
                "aOir0": null,
                "lgfkM": "Not Started",
                "rJdNM": "Shivani Soni - Beyoung",
                "t6ioc": null,
                "vFVIH": null
            },
            {
                "Name": "Make a deck to pitch RAf along with community",
                "1efVG": "Umair Alam",
                "5FVfD": null,
                "6bd7F": null,
                "9RssK": null,
                "FBHdW": "High Priority",
                "O5yhk": "2024-09-16T16:01:00.000Z",
                "V6xmb": "2024-09-12T21:10:01.416Z",
                "aOir0": null,
                "lgfkM": "Not Started",
                "rJdNM": "Rajeev Krishnaswamy - Soch",
                "t6ioc": null,
                "vFVIH": null
            },
            {
                "Name": "Send brand the deck and list in a sheet ",
                "1efVG": "Sanya Menon",
                "5FVfD": null,
                "6bd7F": null,
                "9RssK": null,
                "FBHdW": null,
                "O5yhk": "2024-08-26T13:07:00.000Z",
                "V6xmb": "2024-08-26T13:06:50.375Z",
                "aOir0": null,
                "lgfkM": "Not Started",
                "rJdNM": "Joanesca - Licious",
                "t6ioc": null,
                "vFVIH": null
            },
            {
                "Name": "Make a deck to pitch a proporsal of 20 videos ",
                "1efVG": "Neel",
                "5FVfD": null,
                "6bd7F": null,
                "9RssK": null,
                "FBHdW": "Low Priority",
                "O5yhk": "2024-09-21T15:15:00.000Z",
                "V6xmb": "2024-08-08T20:16:32.973Z",
                "aOir0": null,
                "lgfkM": "In Progress",
                "rJdNM": "David Karambekar - Damro",
                "t6ioc": null,
                "vFVIH": null
            },
            {
                "Name": "add additional barter creators from mumbai ",
                "1efVG": "Vinanth",
                "5FVfD": null,
                "6bd7F": null,
                "9RssK": null,
                "FBHdW": "High Priority",
                "O5yhk": "2024-09-17T15:30:00.000Z",
                "V6xmb": "2024-09-12T11:42:48.766Z",
                "aOir0": null,
                "lgfkM": "In Progress",
                "rJdNM": "niyati - BRDG Group",
                "t6ioc": null,
                "vFVIH": null
            },
            {
                "Name": "Take the full download and close milky mist",
                "1efVG": "Neel",
                "5FVfD": null,
                "6bd7F": null,
                "9RssK": null,
                "FBHdW": "High Priority",
                "O5yhk": "2024-09-16T13:00:00.000Z",
                "V6xmb": "2024-09-12T21:01:58.342Z",
                "aOir0": null,
                "lgfkM": "Not Started",
                "rJdNM": "sangamithra@milkymist.com - MilkyMist",
                "t6ioc": null,
                "vFVIH": null
            },
            {
                "Name": "Call subhojeet ",
                "1efVG": "Varun Krishnamurthy",
                "5FVfD": null,
                "6bd7F": null,
                "9RssK": null,
                "FBHdW": "High Priority",
                "O5yhk": "2024-09-13T15:52:00.000Z",
                "V6xmb": "2024-09-12T20:51:52.404Z",
                "aOir0": null,
                "lgfkM": "Not Started",
                "rJdNM": "Ranjan Gyan - Dabur",
                "t6ioc": null,
                "vFVIH": null
            },
            {
                "Name": "Get the deck designed - submit to design team ",
                "1efVG": "Vinanth",
                "5FVfD": null,
                "6bd7F": null,
                "9RssK": null,
                "FBHdW": "Low Priority",
                "O5yhk": "2024-09-22T18:30:00.000Z",
                "V6xmb": "2024-08-13T18:24:04.319Z",
                "aOir0": null,
                "lgfkM": "Not Started",
                "rJdNM": "Ranjani - Proactive For Her",
                "t6ioc": null,
                "vFVIH": null
            },
            {
                "Name": "Varun to call chandan to get mandate from chandan",
                "1efVG": "Varun Krishnamurthy",
                "5FVfD": null,
                "6bd7F": null,
                "9RssK": null,
                "FBHdW": null,
                "O5yhk": null,
                "V6xmb": "2024-09-02T15:50:03.373Z",
                "aOir0": null,
                "lgfkM": "Not Started",
                "rJdNM": "Chandan Biswal - GreenPly Samet India",
                "t6ioc": null,
                "vFVIH": null
            },
            {
                "Name": "Master Sheet- Add leads",
                "1efVG": "Johann",
                "5FVfD": null,
                "6bd7F": null,
                "9RssK": null,
                "FBHdW": "High Priority",
                "O5yhk": null,
                "V6xmb": "2024-08-29T17:51:51.627Z",
                "aOir0": null,
                "lgfkM": "In Progress",
                "rJdNM": null,
                "t6ioc": null,
                "vFVIH": null
            },
            {
                "Name": "Clear payments - (Product Value)\nInternal orders/Reviewers \nExternal Reviewers",
                "1efVG": "Ashish Krishna",
                "5FVfD": null,
                "6bd7F": null,
                "9RssK": null,
                "FBHdW": "Low Priority",
                "O5yhk": "2024-09-13T20:30:00.000Z",
                "V6xmb": "2024-09-11T13:31:32.093Z",
                "aOir0": null,
                "lgfkM": "In Progress",
                "rJdNM": "Sikha Chinee - Pigeon",
                "t6ioc": null,
                "vFVIH": null
            },
            {
                "Name": "expand community as per requirement",
                "1efVG": "Vinanth",
                "5FVfD": null,
                "6bd7F": null,
                "9RssK": null,
                "FBHdW": "Mid Priority",
                "O5yhk": null,
                "V6xmb": "2024-09-12T11:44:40.514Z",
                "aOir0": null,
                "lgfkM": "Not Started",
                "rJdNM": "Aishwarya Gunjal - Max Fasion | Route Agency",
                "t6ioc": null,
                "vFVIH": null
            },
            {
                "Name": "CLose retainer amount",
                "1efVG": "Sanya Menon",
                "5FVfD": null,
                "6bd7F": null,
                "9RssK": null,
                "FBHdW": "High Priority",
                "O5yhk": "2024-09-13T15:00:00.000Z",
                "V6xmb": "2024-09-12T20:52:46.627Z",
                "aOir0": null,
                "lgfkM": "Not Started",
                "rJdNM": "Chandan Biswal - GreenPly Samet India",
                "t6ioc": null,
                "vFVIH": null
            },
            {
                "Name": "Follow-up with gyan",
                "1efVG": null,
                "5FVfD": null,
                "6bd7F": null,
                "9RssK": null,
                "FBHdW": null,
                "O5yhk": "2024-08-12T19:30:00.000Z",
                "V6xmb": "2024-08-12T17:08:33.070Z",
                "aOir0": null,
                "lgfkM": "In Progress",
                "rJdNM": "Dasgupta Subhadeep - Dabur",
                "t6ioc": null,
                "vFVIH": null
            },
            {
                "Name": "Make a TB",
                "1efVG": "Johann",
                "5FVfD": null,
                "6bd7F": null,
                "9RssK": null,
                "FBHdW": "High Priority",
                "O5yhk": "2024-09-17T17:30:00.000Z",
                "V6xmb": "2024-09-16T11:16:37.455Z",
                "aOir0": null,
                "lgfkM": "In Progress",
                "rJdNM": "niyati - BRDG Group",
                "t6ioc": null,
                "vFVIH": null
            },
            {
                "Name": "Creator Data Base ",
                "1efVG": "Pratiksha Sharma",
                "5FVfD": null,
                "6bd7F": null,
                "9RssK": null,
                "FBHdW": "High Priority",
                "O5yhk": "2024-09-16T22:00:00.000Z",
                "V6xmb": "2024-09-16T18:47:46.756Z",
                "aOir0": null,
                "lgfkM": "In Progress",
                "rJdNM": null,
                "t6ioc": null,
                "vFVIH": null
            },
            {
                "Name": "Add youtube creators with costing (Priority)",
                "1efVG": "Vinanth",
                "5FVfD": null,
                "6bd7F": null,
                "9RssK": null,
                "FBHdW": "High Priority",
                "O5yhk": "2024-09-17T00:00:00.000Z",
                "V6xmb": "2024-09-06T12:08:43.865Z",
                "aOir0": null,
                "lgfkM": "In Progress",
                "rJdNM": "Rachika Singh - Clovia",
                "t6ioc": null,
                "vFVIH": null
            },
            {
                "Name": "Write initial deck - Should include what we can do for them , Retainer plan, can include social media ",
                "1efVG": "Vinanth",
                "5FVfD": null,
                "6bd7F": null,
                "9RssK": null,
                "FBHdW": "Low Priority",
                "O5yhk": "2024-09-22T18:30:00.000Z",
                "V6xmb": "2024-08-13T18:23:00.088Z",
                "aOir0": null,
                "lgfkM": "Not Started",
                "rJdNM": "Ranjani - Proactive For Her",
                "t6ioc": null,
                "vFVIH": null
            },
            {
                "Name": "Coordinate with Namrata to get the video done",
                "1efVG": "Johann",
                "5FVfD": null,
                "6bd7F": null,
                "9RssK": null,
                "FBHdW": "High Priority",
                "O5yhk": null,
                "V6xmb": "2024-09-13T14:29:46.862Z",
                "aOir0": null,
                "lgfkM": "In Progress",
                "rJdNM": "Gaurav Raju - Healthify Me",
                "t6ioc": null,
                "vFVIH": null
            }
        ]
    },
    {
        "__IMTKEY__": "neel@aflog.in",
        "array": [
            {
                "Name": "Get update on the content from Nithyashree, naina & anusha",
                "1efVG": "Neel",
                "5FVfD": null,
                "6bd7F": "neel@aflog.in",
                "9RssK": null,
                "FBHdW": "High Priority",
                "O5yhk": "2024-09-17T13:30:00.000Z",
                "V6xmb": "2024-09-17T11:57:01.874Z",
                "aOir0": null,
                "lgfkM": "Not Started",
                "rJdNM": "Anubha Gautam - Decathlon",
                "t6ioc": null,
                "vFVIH": null
            },
            {
                "Name": "Send the Revised YT videos to the brand and close the campaign",
                "1efVG": "Neel",
                "5FVfD": null,
                "6bd7F": "neel@aflog.in",
                "9RssK": null,
                "FBHdW": "High Priority",
                "O5yhk": "2024-09-20T18:30:00.000Z",
                "V6xmb": "2024-09-17T12:06:24.007Z",
                "aOir0": null,
                "lgfkM": "Not Started",
                "rJdNM": "David Karambekar - Damro",
                "t6ioc": null,
                "vFVIH": null
            },
            {
                "Name": "Follow up with the brand for the apparel delivery for Anuj",
                "1efVG": "Neel",
                "5FVfD": null,
                "6bd7F": "neel@aflog.in",
                "9RssK": null,
                "FBHdW": "High Priority",
                "O5yhk": "2024-09-17T13:30:00.000Z",
                "V6xmb": "2024-09-17T12:04:44.899Z",
                "aOir0": null,
                "lgfkM": "In Progress",
                "rJdNM": "Chahat - Twamev",
                "t6ioc": null,
                "vFVIH": null
            }
        ]
    },
    {
        "__IMTKEY__": "johann@aflog.in",
        "array": [
            {
                "Name": "Add creators to the sheet based out of- HYD/AP that will fit the brand- Wake Fit",
                "1efVG": "Johann",
                "5FVfD": null,
                "6bd7F": "johann@aflog.in",
                "9RssK": null,
                "FBHdW": "High Priority",
                "O5yhk": "2024-09-17T14:35:00.000Z",
                "V6xmb": "2024-09-17T14:06:45.419Z",
                "aOir0": null,
                "lgfkM": "In Progress",
                "rJdNM": "Phalguni aneja - Wakefit",
                "t6ioc": null,
                "vFVIH": null
            }
        ]
    },
    {
        "__IMTKEY__": "ashish@aflog.in",
        "array": [
            {
                "Name": "Update the sheets and the status of the orders ",
                "1efVG": "Ashish Krishna",
                "5FVfD": null,
                "6bd7F": "ashish@aflog.in",
                "9RssK": null,
                "FBHdW": "Mid Priority",
                "O5yhk": "2024-09-17T17:00:00.000Z",
                "V6xmb": "2024-09-17T11:44:57.979Z",
                "aOir0": null,
                "lgfkM": "Not Started",
                "rJdNM": "Sikha Chinee - Pigeon",
                "t6ioc": null,
                "vFVIH": null
            },
            {
                "Name": "Make calls for youtube creators and get their costings",
                "1efVG": "Ashish Krishna",
                "5FVfD": null,
                "6bd7F": "ashish@aflog.in",
                "9RssK": null,
                "FBHdW": "Mid Priority",
                "O5yhk": "2024-09-17T18:30:00.000Z",
                "V6xmb": "2024-09-17T11:37:50.111Z",
                "aOir0": null,
                "lgfkM": "Not Started",
                "rJdNM": "Rachika Singh - Clovia",
                "t6ioc": null,
                "vFVIH": null
            },
            {
                "Name": "Onboard selected creators and share approvals and then proceed with confirmation mails ",
                "1efVG": "Ashish Krishna",
                "5FVfD": null,
                "6bd7F": "ashish@aflog.in",
                "9RssK": null,
                "FBHdW": "High Priority",
                "O5yhk": "2024-09-17T17:30:00.000Z",
                "V6xmb": "2024-09-17T11:41:24.829Z",
                "aOir0": null,
                "lgfkM": "In Progress",
                "rJdNM": "Sikha Chinee - Pigeon",
                "t6ioc": null,
                "vFVIH": null
            },
            {
                "Name": "Call the vendor and pace up the campaign ",
                "1efVG": "Ashish Krishna",
                "5FVfD": null,
                "6bd7F": "ashish@aflog.in",
                "9RssK": null,
                "FBHdW": "High Priority",
                "O5yhk": "2024-09-17T18:30:00.000Z",
                "V6xmb": "2024-09-17T11:46:55.123Z",
                "aOir0": null,
                "lgfkM": "Not Started",
                "rJdNM": "Sikha Chinee - Pigeon",
                "t6ioc": null,
                "vFVIH": null
            },
            {
                "Name": "Add more Food creators from west from different states ",
                "1efVG": "Ashish Krishna",
                "5FVfD": null,
                "6bd7F": "ashish@aflog.in",
                "9RssK": null,
                "FBHdW": "Mid Priority",
                "O5yhk": "2024-09-17T19:30:00.000Z",
                "V6xmb": "2024-09-17T11:48:44.555Z",
                "aOir0": null,
                "lgfkM": "Not Started",
                "rJdNM": "sangamithra@milkymist.com - MilkyMist",
                "t6ioc": null,
                "vFVIH": null
            }
        ]
    },
    {
        "__IMTKEY__": "pratiksha@aflog.in",
        "array": [
            {
                "Name": "need 5-10 good sportsperson profiles (150k+) for paid collaboration",
                "1efVG": "Pratiksha Sharma",
                "5FVfD": null,
                "6bd7F": "pratiksha@aflog.in",
                "9RssK": null,
                "FBHdW": "High Priority",
                "O5yhk": "2024-09-17T19:38:00.000Z",
                "V6xmb": "2024-09-17T12:37:00.256Z",
                "aOir0": null,
                "lgfkM": "Not Started",
                "rJdNM": "Bhavna - Cult Avant",
                "t6ioc": null,
                "vFVIH": null
            },
            {
                "Name": "Need to send more Barter creators",
                "1efVG": "Pratiksha Sharma",
                "5FVfD": null,
                "6bd7F": "pratiksha@aflog.in",
                "9RssK": null,
                "FBHdW": "High Priority",
                "O5yhk": "2024-09-17T15:31:00.000Z",
                "V6xmb": "2024-09-17T11:58:50.298Z",
                "aOir0": null,
                "lgfkM": "Not Started",
                "rJdNM": "niyati - BRDG Group",
                "t6ioc": null,
                "vFVIH": null
            }
        ]
    },
    {
        "__IMTKEY__": "vinanth@aflog.in",
        "array": [
            {
                "Name": "send confirmation mail to all creators + set up briefing calls + onboard them on afcreate",
                "1efVG": "Vinanth",
                "5FVfD": null,
                "6bd7F": "vinanth@aflog.in",
                "9RssK": null,
                "FBHdW": "High Priority",
                "O5yhk": "2024-09-17T03:30:00.000Z",
                "V6xmb": "2024-09-16T19:10:10.913Z",
                "aOir0": null,
                "lgfkM": "In Progress",
                "rJdNM": "Santosh - Atlys",
                "t6ioc": null,
                "vFVIH": null
            }
        ]
    }
]

The Data Aggregator output is grouped my email ID

I need to send different Email (Same structure but different data inside Email to different email IDs

Let me know if this is ok? Or you need the get rows output still?

Regards,
Dilip

1 Like
6

@Msquare_Automation

this is my Output Bundle for Get rows

OutputData_row.txt (456.8 KB)

Regards,
Dilip

1 Like
7

Hi @Dilip
Work flow

image
image1436×412 46.1 KB

image
image712×354 23.8 KB

image
image1131×681 61.4 KB

image
image764×854 48.4 KB

Best regards,

Msquare Automation
Gold Partner of Make
@Msquare_Automation

8

Hi @Msquare_Automation ,

Thank you for replying.

Few questions.

Why is the first element JSON parser?

My First element is going to be glide table right? From where I get all rows. (Please correct me if I am wrong))

Second Element is iterator after which I need to apply filter to get only rows with certain status

Third element you have is text aggregator.

I have to pass it through an array aggregator right? Because I have to group elements based on Email id. Because I will have to Group all tasks which have same person assigned / email id.

After that I can pass it to text aggregator right?

I need emails to be sent to each of the task assignee and in each email body I need th tasks listed under them.

Please let me know wether this approach is ok?

Regards,
Dilip

9

Hi @Dilip
The output bundle you provided was in JSON format, so I used the ‘Parse JSON’ module to create a sample output based on the aggregator module you shared.

The workflow I shared will proceed after the aggregator module. Please note the Parse JSON module is utilized for processing the output bundle from the aggregator module you provided.
Best regards,

Msquare Automation
Gold Partner of Make
@Msquare_Automation

10

Hi @Msquare_Automation ,

Thank you for replying.

Can you show me how you configured the JSON Parser module?

Ill apply the same after my aggregator module

Thank you again.

Regards,
Dilip

11

Hi @Dilip
If you can share your blueprint, I can setup the structure for you.
Best regards,

Msquare Automation
Gold Partner of Make
@Msquare_Automation

12

Hi @Dilip

You can setup the complete workflow I shared without parse json module, after the module you specified:

image
image870×305 20.6 KB

Best regards,

Msquare Automation
Gold Partner of Make
@Msquare_Automation

13

Hi @Msquare_Automation

I just used to create it using the generate feature

let me know if this is ok.

Also I passed the Array aggregator output into JSON

Screenshot 2024-09-17 at 5.32.35 PM
Screenshot 2024-09-17 at 5.32.35 PM1356×994 123 KB

Its giving me following error when I run it

Screenshot 2024-09-17 at 5.33.10 PM
Screenshot 2024-09-17 at 5.33.10 PM876×1012 70.9 KB
D

Regards,
Dilip

14

Hi @Msquare_Automation ,

how would this work?

I tried putting the Data aggregator output into text aggregator and even Iterator.

but nothing works.

Regards,
Dilip

15

Hi @Dilip

Delete the parse json module and connect the iterator module to the aggregator the workflow will look like this:

image
image1541×434 45.6 KB

Best regards,

Msquare Automation
Gold Partner of Make
@Msquare_Automation

16

Hi @Msquare_Automation ,

I had tried that previously

I configured Iterator to take my Array aggregator as input

Screenshot 2024-09-17 at 5.49.19 PM
Screenshot 2024-09-17 at 5.49.19 PM2702×1044 194 KB

But in the output of the module I am getting Empty Array

Screenshot 2024-09-17 at 5.49.03 PM
Screenshot 2024-09-17 at 5.49.03 PM2776×874 187 KB

What am I doing wrong here?

Regards,
Dilip

17

Hi @Dilip
Kindly provide a screenshot of the output from the array aggregator. You are grouping by email id right?
Best regards,

Msquare Automation
Gold Partner of Make
@Msquare_Automation

18

Hi @Msquare_Automation ,

Thank you for your patience.

here is the screenshot.

Screenshot 2024-09-17 at 5.55.36 PM
Screenshot 2024-09-17 at 5.55.36 PM1572×1544 206 KB

Regards,
Dilip

19

Hi @Msquare_Automation ,

Yah I am grouping it by Email ID

Regards,
Dilip

20

Hi @Dilip
Now map the following array from array aggregator:

image
image1102×383 72.7 KB

Best regards,

Msquare Automation
Gold Partner of Make
@Msquare_Automation