Merging data from a loop into one item for further processing

[Bastian_Orth]

Hello together,

i have a loop for processing similar data to upload data to gdrive and get the share links. For each loop run i have 2 documents and their share links.

Let’s assume we have a list with 2 dataset so n=2. Here is the loop part of my workflow:

I use the merge node to get the output of those two node, which contains the links i need for further processing. Data structure of those nodes output is identical.
I’d like to get a data structure like this but i don’t know how to achieve this. n will always between 1-3 so i will have at max 3 items.

{
  "Item1":  
  {
    "Link1": "https://drive.google.com/uc?id=12345&export=download",
    "Link2": "https://drive.google.com/uc?id=6789&export=download"
  },
    "Item2":  
  {
    "Link1": "https://drive.google.com/uc?id=12345&export=download",
    "Link2": "https://drive.google.com/uc?id=6789&export=download"
  },
    "Item3":  
  {
    "Link1": "https://drive.google.com/uc?id=12345&export=download",
    "Link2": "https://drive.google.com/uc?id=6789&export=download"
  }
}

I tried to use the Item List block with summarize and append but don’t get a single list/array for further processing and ending up to have then 2 items instead of 1.

Whats the best way to achieve this? Or maybe there is another way to do thiss?

I want to push those links to my CRM where i have specific fields like:
1_link1 = Item1.Link1
1_link2 = Item1.Link2
2_link1 = Item2.Link1
2_link2 = Item2.Link2
3_link1 = Item3.Link1
3_link2 = Item3.Link2

So i need to check before how many elements are included in the list and map them to the right fields.

Thanks for your support.
Best regards
Bastian

[Jon]

Hey @Bastian_Orth,

What does the output currently look like when you merge it? That will help us work out what needs to be tweaked to get this working.

[Bastian_Orth]

Thanks for your reply, i think is sorted it out on my own. Somehow yesterday i was stuck with handling of the multiple itemes.

I’m not finished yet with the full workflow but it looks like i got the structure i wanted yesterday.