How do I turn this Array of collections, into 1 collection with usable values

How To
,
1

Hello,
I’ve been digging for 5 hours, I am trying toCollection or Mapping but I either get only the first value, or empty key value pairs…

Basically as I describe in the photo, I want to get ALL values to a mappable way.

Basically turning this bundle of array of collections, into collection with value pairs.

Example of key value pairs should look like
Key: Value pairs
Row number 35: Link
Row number 36: Link

SCR-20241230-mgdh
SCR-20241230-mgdh1143×822 89.9 KB

Here is the output bundle

[
    {
        "array": [
            {
                "0": "https://www.amazon.com/dp/B06XWXTX49",
                "__ROW_NUMBER__": 35
            },
            {
                "0": "https://www.amazon.com/dp/B06XX65GS1",
                "__ROW_NUMBER__": 36
            },
            {
                "0": "https://www.amazon.com/dp/B018UPBFUK",
                "__ROW_NUMBER__": 37
            },
            {
                "0": "https://www.amazon.com/dp/B072M8FKRW",
                "__ROW_NUMBER__": 38
            },
            {
                "0": "https://www.amazon.com/dp/B0C9MWB85P",
                "__ROW_NUMBER__": 39
            },
            {
                "0": "https://www.amazon.com/dp/B01NAEHLFO",
                "__ROW_NUMBER__": 40
            },
            {
                "0": "https://www.amazon.com/dp/B08R5FTZ52",
                "__ROW_NUMBER__": 41
            },
            {
                "0": "https://www.amazon.com/dp/B0756NHJRY",
                "__ROW_NUMBER__": 42
            },
            {
                "0": "https://www.amazon.com/dp/B00NGT4M7Y",
                "__ROW_NUMBER__": 43
            },
            {
                "0": "https://www.amazon.com/dp/B08CBYRMR4",
                "__ROW_NUMBER__": 44
            },
            {
                "0": "https://www.amazon.com/dp/B0020XQWCA",
                "__ROW_NUMBER__": 45
            },
            {
                "0": "https://www.amazon.com/dp/B0015R6ZPQ",
                "__ROW_NUMBER__": 46
            },
            {
                "0": "https://www.amazon.com/dp/B000GIPJ02",
                "__ROW_NUMBER__": 47
            },
            {
                "0": "https://www.amazon.com/dp/B00XQF7NG0",
                "__ROW_NUMBER__": 48
            },
            {
                "0": "https://www.amazon.com/dp/B07BP7DQG9",
                "__ROW_NUMBER__": 49
            },
            {
                "0": "https://www.amazon.com/dp/B01LXK56YS",
                "__ROW_NUMBER__": 50
            },
            {
                "0": "https://www.amazon.com/dp/B000GP0NYM",
                "__ROW_NUMBER__": 51
            },
            {
                "0": "https://www.amazon.com/dp/B01KKEECLS",
                "__ROW_NUMBER__": 52
            },
            {
                "0": "https://www.amazon.com/dp/B073ZP1VYW",
                "__ROW_NUMBER__": 53
            },
            {
                "0": "https://www.amazon.com/dp/B08H56G22H",
                "__ROW_NUMBER__": 54
            },
            {
                "0": "https://www.amazon.com/dp/B07X1LFDH9",
                "__ROW_NUMBER__": 55
            },
            {
                "0": "https://www.amazon.com/dp/B01FYXCQ1S",
                "__ROW_NUMBER__": 56
            },
            {
                "0": "https://www.amazon.com/dp/B07SXBL1GF",
                "__ROW_NUMBER__": 57
            },
            {
                "0": "https://www.amazon.com/dp/B09ZMNYS1F",
                "__ROW_NUMBER__": 58
            },
            {
                "0": "https://www.amazon.com/dp/B08VCCGMFS",
                "__ROW_NUMBER__": 59
            },
            {
                "0": "https://www.amazon.com/dp/B01772DE74",
                "__ROW_NUMBER__": 60
            },
            {
                "0": "https://www.amazon.com/dp/B08CMG5VHP",
                "__ROW_NUMBER__": 61
            },
            {
                "0": "https://www.amazon.com/dp/B00U6OUAZA",
                "__ROW_NUMBER__": 62
            },
            {
                "0": "https://www.amazon.com/dp/B078TLSD51",
                "__ROW_NUMBER__": 63
            },
            {
                "0": "https://www.amazon.com/dp/B0020XQWCA",
                "__ROW_NUMBER__": 64
            },
            {
                "0": "https://www.amazon.com/dp/B08GL3DTDQ",
                "__ROW_NUMBER__": 65
            },
            {
                "0": "https://www.amazon.com/dp/B0C37XGLPT",
                "__ROW_NUMBER__": 66
            },
            {
                "0": "https://www.amazon.com/dp/B00NBDMN8U",
                "__ROW_NUMBER__": 69
            },
            {
                "0": "https://www.amazon.com/dp/B01DMUT4MO",
                "__ROW_NUMBER__": 70
            },
            {
                "0": "https://www.amazon.com/dp/B01DMU8YDY",
                "__ROW_NUMBER__": 71
            },
            {
                "0": "https://www.amazon.com/dp/B01ITRCZM6",
                "__ROW_NUMBER__": 72
            },
            {
                "0": "https://www.amazon.com/dp/B0CGXZCWC1",
                "__ROW_NUMBER__": 73
            },
            {
                "0": "https://www.amazon.com/dp/B0CGY27QCH",
                "__ROW_NUMBER__": 74
            },
            {
                "0": "https://www.amazon.com/dp/B00XIKPUK4",
                "__ROW_NUMBER__": 75
            },
            {
                "0": "https://www.amazon.com/dp/B0D2PDNT55",
                "__ROW_NUMBER__": 76
            },
            {
                "0": "https://www.amazon.com/dp/B0D2PFN3NX",
                "__ROW_NUMBER__": 77
            },
            {
                "0": "https://www.amazon.com/dp/B0CGXZ3CG3",
                "__ROW_NUMBER__": 78
            },
            {
                "0": "https://www.amazon.com/dp/B0CGXZ3FWH",
                "__ROW_NUMBER__": 79
            },
            {
                "0": "https://www.amazon.com/dp/B0787RNSPQ",
                "__ROW_NUMBER__": 80
            },
            {
                "0": "https://www.amazon.com/dp/B0787S4YN1",
                "__ROW_NUMBER__": 81
            },
            {
                "0": "https://www.amazon.com/dp/B071ZDDNBY",
                "__ROW_NUMBER__": 82
            },
            {
                "0": "https://www.amazon.com/dp/B0B9YMNYWK",
                "__ROW_NUMBER__": 83
            },
            {
                "0": "https://www.amazon.com/dp/B00ULZF5HC",
                "__ROW_NUMBER__": 84
            },
            {
                "0": "https://www.amazon.com/dp/B0D94WBG3W",
                "__ROW_NUMBER__": 85
            },
            {
                "0": "https://www.amazon.com/dp/B0DF7X3F7X",
                "__ROW_NUMBER__": 86
            },
            {
                "0": "https://www.amazon.com/dp/B0DF7XPR6W",
                "__ROW_NUMBER__": 87
            },
            {
                "0": "https://www.amazon.com/dp/B00NBIUGA2",
                "__ROW_NUMBER__": 88
            },
            {
                "0": "https://www.amazon.com/dp/B01E50XSG8",
                "__ROW_NUMBER__": 89
            },
            {
                "0": "https://www.amazon.com/dp/B01E51F1NU",
                "__ROW_NUMBER__": 90
            },
            {
                "0": "https://www.amazon.com/dp/B0CLM6N2FF",
                "__ROW_NUMBER__": 91
            },
            {
                "0": "https://www.amazon.com/dp/B0CLM7ZW1P",
                "__ROW_NUMBER__": 92
            },
            {
                "0": "https://www.amazon.com/dp/B0D2PDM4WM",
                "__ROW_NUMBER__": 93
            },
            {
                "0": "https://www.amazon.com/dp/B0D2RX2Y1W",
                "__ROW_NUMBER__": 94
            },
            {
                "0": "https://www.amazon.com/dp/B0D2PFSQ7Q",
                "__ROW_NUMBER__": 95
            },
            {
                "0": "https://www.amazon.com/dp/B0D2PCN1GY",
                "__ROW_NUMBER__": 96
            },
            {
                "0": "https://www.amazon.com/dp/B0D2PFDYC4",
                "__ROW_NUMBER__": 97
            },
            {
                "0": "https://www.amazon.com/dp/B0787RBSF8",
                "__ROW_NUMBER__": 98
            },
            {
                "0": "https://www.amazon.com/dp/B0D2RXJYNF",
                "__ROW_NUMBER__": 99
            },
            {
                "0": "https://www.amazon.com/dp/B0D2PFQP1J",
                "__ROW_NUMBER__": 100
            },
            {
                "0": "https://www.amazon.com/dp/B07XTQKYG1",
                "__ROW_NUMBER__": 101
            },
            {
                "0": "https://www.amazon.com/dp/B083VT91G9",
                "__ROW_NUMBER__": 102
            },
            {
                "0": "https://www.amazon.com/dp/B083VTWMP8",
                "__ROW_NUMBER__": 103
            },
            {
                "0": "https://www.amazon.com/dp/B0CLM5C5KS",
                "__ROW_NUMBER__": 104
            },
            {
                "0": "https://www.amazon.com/dp/B0CLM66QPM",
                "__ROW_NUMBER__": 105
            },
            {
                "0": "https://www.amazon.com/dp/B08J8BKCZ5",
                "__ROW_NUMBER__": 106
            },
            {
                "0": "https://www.amazon.com/dp/B00UIAEOO0",
                "__ROW_NUMBER__": 107
            },
            {
                "0": "https://www.amazon.com/dp/B01IO5TJZ4",
                "__ROW_NUMBER__": 108
            },
            {
                "0": "https://www.amazon.com/dp/B0CLM76BRS",
                "__ROW_NUMBER__": 109
            },
            {
                "0": "https://www.amazon.com/dp/B0CLM69LYB",
                "__ROW_NUMBER__": 110
            },
            {
                "0": "https://www.amazon.com/dp/B00NQLE5JC",
                "__ROW_NUMBER__": 111
            },
            {
                "0": "https://www.amazon.com/dp/B0C264SJNB",
                "__ROW_NUMBER__": 112
            },
            {
                "0": "https://www.amazon.com/dp/B0C579PWGG",
                "__ROW_NUMBER__": 113
            },
            {
                "0": "https://www.amazon.com/dp/B0C57BCSR3",
                "__ROW_NUMBER__": 114
            },
            {
                "0": "https://www.amazon.com/dp/B08XY94XCZ",
                "__ROW_NUMBER__": 115
            },
            {
                "0": "https://www.amazon.com/dp/B09GYS1HT2",
                "__ROW_NUMBER__": 116
            },
            {
                "0": "https://www.amazon.com/dp/B09GYSJZ4K",
                "__ROW_NUMBER__": 117
            },
            {
                "0": "https://www.amazon.com/dp/B08XY6ZMMS",
                "__ROW_NUMBER__": 118
            },
            {
                "0": "https://www.amazon.com/dp/B0C9NNPF4Q",
                "__ROW_NUMBER__": 119
            },
            {
                "0": "https://www.amazon.com/dp/B0C9NH4VMJ",
                "__ROW_NUMBER__": 120
            },
            {
                "0": "https://www.amazon.com/dp/B0BQ3QVQJ9",
                "__ROW_NUMBER__": 121
            },
            {
                "0": "https://www.amazon.com/dp/B0BQ3S8NL4",
                "__ROW_NUMBER__": 122
            },
            {
                "0": "https://www.amazon.com/dp/B09CVW9P5K",
                "__ROW_NUMBER__": 123
            },
            {
                "0": "https://www.amazon.com/dp/B071ZDD3HL",
                "__ROW_NUMBER__": 124
            },
            {
                "0": "https://www.amazon.com/dp/B0787V2FQQ",
                "__ROW_NUMBER__": 125
            },
            {
                "0": "https://www.amazon.com/dp/B09S35BYSD",
                "__ROW_NUMBER__": 126
            },
            {
                "0": "https://www.amazon.com/dp/B09VYLS3ST",
                "__ROW_NUMBER__": 127
            },
            {
                "0": "https://www.amazon.com/dp/B0CGKYN83K",
                "__ROW_NUMBER__": 128
            },
            {
                "0": "https://www.amazon.com/dp/B0CGKGT77J",
                "__ROW_NUMBER__": 129
            },
            {
                "0": "https://www.amazon.com/dp/B0CGKQYVRY",
                "__ROW_NUMBER__": 130
            },
            {
                "0": "https://www.amazon.com/dp/B0D9M3W97N",
                "__ROW_NUMBER__": 131
            },
            {
                "0": "https://www.amazon.com/dp/B0D9M65SH3",
                "__ROW_NUMBER__": 132
            },
            {
                "0": "https://www.amazon.com/dp/B0D9M2RQXT",
                "__ROW_NUMBER__": 133
            },
            {
                "0": "https://www.amazon.com/dp/B0D9M3GGBB",
                "__ROW_NUMBER__": 134
            },
            {
                "0": "https://www.amazon.com/dp/B00NBILDQ8",
                "__ROW_NUMBER__": 135
            },
            {
                "0": "https://www.amazon.com/dp/B0787TJJNQ",
                "__ROW_NUMBER__": 136
            },
            {
                "0": "https://www.amazon.com/dp/B01DTWXM3C",
                "__ROW_NUMBER__": 137
            },
            {
                "0": "https://www.amazon.com/dp/B01DTV8JCW",
                "__ROW_NUMBER__": 138
            },
            {
                "0": "https://www.amazon.com/dp/B07H5SLML1",
                "__ROW_NUMBER__": 139
            },
            {
                "0": "https://www.amazon.com/dp/B071SCRL2X",
                "__ROW_NUMBER__": 140
            },
            {
                "0": "https://www.amazon.com/dp/B0C9NVWL4B",
                "__ROW_NUMBER__": 141
            },
            {
                "0": "https://www.amazon.com/dp/B0B9YJZ1WV",
                "__ROW_NUMBER__": 142
            },
            {
                "0": "https://www.amazon.com/dp/B0CYMRFRN7",
                "__ROW_NUMBER__": 143
            },
            {
                "0": "https://www.amazon.com/dp/B0CLM6SB8J",
                "__ROW_NUMBER__": 144
            },
            {
                "0": "https://www.amazon.com/dp/B0CLM6FWH5",
                "__ROW_NUMBER__": 145
            },
            {
                "0": "https://www.amazon.com/dp/B00NBJ377K",
                "__ROW_NUMBER__": 146
            },
            {
                "0": "https://www.amazon.com/dp/B01N41U106",
                "__ROW_NUMBER__": 147
            },
            {
                "0": "https://www.amazon.com/dp/B01E4XSABY",
                "__ROW_NUMBER__": 148
            },
            {
                "0": "https://www.amazon.com/dp/B086H452WJ",
                "__ROW_NUMBER__": 149
            },
            {
                "0": "https://www.amazon.com/dp/B00NBIDHP8",
                "__ROW_NUMBER__": 150
            },
            {
                "0": "https://www.amazon.com/dp/B0787ST38Q",
                "__ROW_NUMBER__": 151
            },
            {
                "0": "https://www.amazon.com/dp/B07ZPCY74F",
                "__ROW_NUMBER__": 152
            },
            {
                "0": "https://www.amazon.com/dp/B09VYR3VXF",
                "__ROW_NUMBER__": 153
            },
            {
                "0": "https://www.amazon.com/dp/B094CBBCZ3",
                "__ROW_NUMBER__": 154
            },
            {
                "0": "https://www.amazon.com/dp/B08XY7L7KG",
                "__ROW_NUMBER__": 155
            },
            {
                "0": "https://www.amazon.com/dp/B09CW5Q8L2",
                "__ROW_NUMBER__": 156
            },
            {
                "0": "https://www.amazon.com/dp/B0CFVZ65KN",
                "__ROW_NUMBER__": 157
            },
            {
                "0": "https://www.amazon.com/dp/B0CJMLDXHG",
                "__ROW_NUMBER__": 158
            },
            {
                "0": "https://www.amazon.com/dp/B0CJMJB81Z",
                "__ROW_NUMBER__": 159
            },
            {
                "0": "https://www.amazon.com/dp/B08XY78L17",
                "__ROW_NUMBER__": 160
            },
            {
                "0": "https://www.amazon.com/dp/B0B1HL48P2",
                "__ROW_NUMBER__": 161
            },
            {
                "0": "https://www.amazon.com/dp/B0B9YN7DRJ",
                "__ROW_NUMBER__": 162
            },
            {
                "0": "https://www.amazon.com/dp/B08XY8247F",
                "__ROW_NUMBER__": 163
            },
            {
                "0": "https://www.amazon.com/dp/B08XY82YM6",
                "__ROW_NUMBER__": 164
            },
            {
                "0": "https://www.amazon.com/dp/B0BCM3HP6F",
                "__ROW_NUMBER__": 165
            },
            {
                "0": "https://www.amazon.com/dp/B0BCMHC8NQ",
                "__ROW_NUMBER__": 166
            },
            {
                "0": "https://www.amazon.com/dp/B0BCM5YWVL",
                "__ROW_NUMBER__": 167
            },
            {
                "0": "https://www.amazon.com/dp/B0DJ3KYNQ5",
                "__ROW_NUMBER__": 168
            },
            {
                "0": "https://www.amazon.com/dp/B0DJ3P7DR7",
                "__ROW_NUMBER__": 169
            },
            {
                "0": "https://www.amazon.com/dp/B0DJ3PXB5C",
                "__ROW_NUMBER__": 170
            },
            {
                "0": "https://www.amazon.com/dp/B0DJ3Q695L",
                "__ROW_NUMBER__": 171
            }
        ],
        "__IMTAGGLENGTH__": 135
    }
]
2

Why didn’t this work?

{{toCollection(9.array; "Row number"; "C")}}

Then I tested with the “ROW_NUMBER” and at least it looks like this now.

{{toCollection(9.array; "__ROW_NUMBER__"; "C")}}

SCR-20241230-mrfh
SCR-20241230-mrfh1294×485 70.8 KB

But Entering C or 0 does not work…
I wonder why there is a difference between the bundle download output and what I see on the interface.

3

Ok so this worked… Now I have 1 array with all the links,

{{map(9.array; 0)}}

so what I am doing is feeding this into the next module with

{
    "categoryUrls": [
        {
            "url": "{{24.allValues[1]}}",
            "method": "GET"
        },
        {
            "url": "{{24.allValues[2]}}",
            "method": "GET"
        },
        {
            "url": "{{24.allValues[3]}}",
            "method": "GET"
        }, // ETC . etc . etc.

So I am calling each link by it’s position. makes sense…

This is the result.

image
image825×735 102 KB

But I feel like there is a better way to do all of this…

I just really puzzled 100 forums together to build this.

There’s something I am not understanding about these arrays, in collections, in arrays…

map, get, to collection, etc functions. And those granular things are blocking me to intuitively build.

I am open to learn so hit me with it if you get the chance.

4

I am building a SIMPLE amazon Best sellers rank monitoring system. For 135 products. I have solved MOST of it, but stuck on last steps.

here is a video explaining the situation