MYSQL output into 3 bundles ---> variables

[Cyau1983]

Dear all,
I have this output from MYSQL.
I want to take the task_type as key & task_content as value, and use them down the road in another module. Any idea how to do? Aggregator? It seems wrong to use iterator as I need to set the variable I suppose?

Thank you in advance for your help.

attached is the bundles:

[
{
“id”: 13,
“recipes_processed_id”: 109,
“task_type”: “crosscheck_title_output”,
“task_priority”: 0,
“pending”: null,
“need_regenerate”: null,
“task_content”: “YES”,
“task_html”: null,
“created_at”: “2024-04-18T18:50:45.000Z”,
“updated_at”: “2024-04-18T18:50:45.000Z”,
“synced_at”: null,
“last_error_at”: null,
“IMTINDEX”: 1,
“IMTLENGTH”: 3
},
{
“id”: 12,
“recipes_processed_id”: 109,
“task_type”: “faq”,
“task_priority”: 0,
“pending”: null,
“need_regenerate”: null,
“task_content”: “### What does lemon juice do to a potato?\n@@@ Lemon juice prevents potatoes from discoloring by slowing down the oxidation process. When you soak cut potatoes in water with lemon juice, the citric acid from the lemon helps maintain their natural color.\n\n### What potatoes does Gordon Ramsay use?\n@@@ Gordon Ramsay often opts for Yukon Gold Potatoes in his recipes. They have a good balance of starch and moisture, making them versatile for various cooking methods, including roasting and mashing.\n\n### Should I marinate potatoes?\n@@@ Yes, marinating potatoes can significantly enhance their flavor. A brine or marinade allows the seasonings to penetrate the flesh of the potatoes, resulting in a more flavorful dish.\n\n### What potatoes are best for roasting?\n@@@ For roasting, Russet Potatoes are excellent as they get crispy on the outside and fluffy inside. Yukon Gold Potatoes are also good for roasting, offering creamier centers and a richer flavor.\n\n### Can I use dried lemon zest instead of fresh lemon juice for Greek-Style Lemon Potatoes?\n@@@ Yes, you can use dried lemon zest as a substitute. It will give a different but still citrusy flavor. However, you might miss the tangy moisture that fresh lemon juice provides.\n\n### How long can I store leftover Greek-Style Lemon Potatoes?\n@@@ Leftover Greek-Style Lemon Potatoes can be stored in the refrigerator for up to 3-4 days. Make sure they’re in an airtight container to maintain freshness.\n\n### Is it necessary to peel the potatoes for this recipe?\n@@@ Peeling is not necessary, especially if you’re using thin-skinned potatoes like Yukon Golds. Keeping the skin on can add texture and nutrients. However, for a more traditional texture, you might prefer to peel them.”,
“task_html”: null,
“created_at”: “2024-04-18T18:50:44.000Z”,
“updated_at”: “2024-04-18T18:50:44.000Z”,
“synced_at”: null,
“last_error_at”: null,
“IMTINDEX”: 2,
“IMTLENGTH”: 3
},
{
“id”: 3,
“recipes_processed_id”: 109,
“task_type”: “ingredients_exp”,
“task_priority”: 0,
“pending”: null,
“need_regenerate”: null,
“task_content”: “- @#@Potatoes#@#: Foundation of the dish, their starchy goodness absorbs the flavors, creating a comforting, hearty base.\n\n- @#@Garlic#@#: Adds a pungent kick, essential for depth and a slight heat, which complements the zesty lemon beautifully.\n\n- @#@Olive Oil#@#: Provides richness, helps crisp up the potatoes, and carries the oregano and lemon flavors throughout the dish.\n\n- @#@Chicken or Vegetable Broth#@#: Adds moisture and a savory note, ensuring the potatoes don’t dry out while baking.\n\n- @#@Lemon Juice#@#: Brings a bright, acidic contrast to the earthy potatoes, giving the dish its signature Greek zing.\n\n- @#@Dried Oregano#@#: Offers a hint of Mediterranean herbaceousness, which is classic in Greek cuisine and pairs well with lemon.”,
“task_html”: null,
“created_at”: “2024-04-18T18:50:01.000Z”,
“updated_at”: “2024-04-18T18:50:01.000Z”,
“synced_at”: null,
“last_error_at”: null,
“IMTINDEX”: 3,
“IMTLENGTH”: 3
}
]

[samliew]

It depends on how you want to use (map) them down the line. Could you share what you’re trying to do?

1. Screenshots of module fields and filters

Please share screenshots of relevant module fields and filters in question? It would really help other community members to see what you’re looking at.

You can upload images here using the Upload icon in the text editor:

2. Scenario blueprint

Please export the scenario blueprint file to allow others to view the mappings and settings. At the bottom of the scenario editor, you can click on the three dots to find the Export Blueprint menu item.

^{(Note: Exporting your scenario will not include private information or keys to your connections)}

Uploading it here will look like this:

blueprint.json (12.3 KB)

3. And most importantly, Output bundles

Please provide the output bundles of the modules by running the scenario, then click the white speech bubble on the top-right of each module and select “Download output bundles”.

A.

Save the bundle contents in your text editor as a bundle.txt file, and upload it here into this discussion thread.

Uploading it here will look like this:

bundle.txt (12.3 KB)

B.

If you are unable to upload files on this forum, alternatively you can paste the formatted output bundle in this manner:

• Either add three backticks ``` before and after the code, like this:

  ```
  <sup>input/output bundle content goes here</sup>
  ```

• Or use the format code button in the editor:
  

Providing the output bundles will allow others to replicate what is going on in the scenario even if they do not use the external service.

Following these steps will allow others to assist you here. Thanks!