An array of arrays

Questions
1

I have an HTTP module returning a payload with a field results.

Each item in results is a collection with keys t, o, h, l, c, v (numbers).

I want to build a new JSON payload where results is not objects but an array of arrays, i.e.

“results”: [

\[t, o, h, l, c, v\],

\[t, o, h, l, c, v\],

...

]

I want the order of values (t, o, h, l, c, v) to be preserved exactly.

I do not want text concatenation hacks (like Text aggregator), tried it didn’t end well, I also cannot use JAVA !!

Is there anyway I can accomplish this on Make?

3

Welcome to the Make community!

If you need further assistance, please provide the following:

Please provide the output bundles of the HTTP module by running the scenario (you can also get this without re-running your scenario from the History tab).

Click on the white speech bubbles on the top-right of each module and select “Download input/output bundles”.

490×338 23.5 KB

A. Upload as a Text File

Save each bundle contents in a plain text editor (without formatting) as a bundle.txt file.

You can upload the file here by clicking on this button:

B. Insert as Formatted Code Block

If you are unable to upload files on this forum, alternatively you can paste the formatted bundles.
Here are some ways to provide text content in a way that it won’t be modified by the forum.

  • Method 1: Type code fence manually —
    Add three backticks ``` in a separate line before and after the content, like this,

    ```
text goes here
```

  • Method 2: Highlight and click the “preformatted text” button in the editor —

  • Method 3: Upload your file and share the public link —
    (this method is only recommended for large files exceeding the forum upload limit)

Providing the input/output bundles will allow others to replicate what is going on in the scenario, especially if there are complex data structures (nested arrays and collections) or if external services are involved, and help you with mapping the raw property names from collections.

This will allow others to better assist you. Thanks!

Hope this helps! Let me know if there are any further questions or issues.

— @samliew
P.S.: investing some effort into the tutorials in the Make Academy will save you lots of time and frustration using Make!

4 

````````````
[
                {
                    "v": 313985919,
                    "vw": 266.5563,
                    "o": 254.02,
                    "c": 287.03,
                    "h": 292.48,
                    "l": 246.1,
                    "t": 1596254400000,
                    "n": 3449547
                },
                {
                    "v": 238702380,
                    "vw": 278.5068,
                    "o": 289.2,
                    "c": 293.98,
                    "h": 299,
                    "l": 264.56,
                    "t": 1598932800000,
                    "n": 2874682
                },
                {
                    "v": 281645688,
                    "vw": 302.4831,
                    "o": 295.26,
                    "c": 304.69,
                    "h": 319.32,
                    "l": 284.88,
                    "t": 1601524800000,
                    "n": 3330772
                },
                {
                    "v": 593317838,
                    "vw": 274.325,
                    "o": 310.95,
                    "c": 263.36,
                    "h": 311.44,
                    "l": 252.55,
                    "t": 1604203200000,
                    "n": 7538567
                },
                {
                    "v": 580759696,
                    "vw": 240.202,
                    "o": 265.47,
                    "c": 232.73,
                    "h": 271.3,
                    "l": 211.23,
                    "t": 1606798800000,
                    "n": 6285802
                },
                {
                    "v": 500294260,
                    "vw": 242.9498,
                    "o": 226.5,
                    "c": 253.83,
                    "h": 269,
                    "l": 220.09,
                    "t": 1609477200000,
                    "n": 5515832
                },
                {
                    "v": 305940308,
                    "vw": 260.7451,
                    "o": 258.8,
                    "c": 237.76,
                    "h": 274.29,
                    "l": 237.65,
                    "t": 1612155600000,
                    "n": 3701252
                },
                {
                    "v": 378832995,
                    "vw": 232.4252,
                    "o": 241.05,
                    "c": 226.73,
                    "h": 242.79,
                    "l": 220.42,
                    "t": 1614574800000,
                    "n": 4833009
                },
                {
                    "v": 332779024,
                    "vw": 233.5434,
                    "o": 230.68,
                    "c": 230.95,
                    "h": 245.69,
                    "l": 221.32,
                    "t": 1617249600000,
                    "n": 4266008
                },
                {
                    "v": 364005446,
                    "vw": 215.3933,
                    "o": 231.27,
                    "c": 213.96,
                    "h": 236.1699,
                    "l": 204.39,
                    "t": 1619841600000,
                    "n": 4322892
                },
                {
                    "v": 280901381,
                    "vw": 217.4571,
                    "o": 223.02,
                    "c": 226.78,
                    "h": 230.89,
                    "l": 208.2256,
                    "t": 1622520000000,
                    "n": 3545602
                },
                {
                    "v": 457467619,
                    "vw": 201.8415,
                    "o": 228.07,
                    "c": 195.19,
                    "h": 228.85,
                    "l": 179.6701,
                    "t": 1625112000000,
                    "n": 5665088
                },
                {
                    "v": 657507673,
                    "vw": 171.9962,
                    "o": 196.27,
                    "c": 166.99,
                    "h": 203.275,
                    "l": 152.8,
                    "t": 1627790400000,
                    "n": 7322095
                },
                {
                    "v": 484707241,
                    "vw": 158.976,
                    "o": 169.56,
                    "c": 148.05,
                    "h": 178.18,
                    "l": 144.44,
                    "t": 1630468800000,
                    "n": 5426419
                },
                {
                    "v": 473028154,
                    "vw": 164.0626,
                    "o": 147.09,
                    "c": 164.94,
                    "h": 182.09,
                    "l": 138.43,
                    "t": 1633060800000,
                    "n": 5061531
                },
                {
                    "v": 433494642,
                    "vw": 150.3893,
                    "o": 165.84,
                    "c": 127.53,
                    "h": 171.895,
                    "l": 126.13,
                    "t": 1635739200000,
                    "n": 5277106
                },
                {
                    "v": 586559492,
                    "vw": 119.9288,
                    "o": 128.37,
                    "c": 118.79,
                    "h": 129.4499,
                    "l": 108.7,
                    "t": 1638334800000,
                    "n": 6074424
                },
                {
                    "v": 490799404,
                    "vw": 125.259,
                    "o": 119.38,
                    "c": 125.79,
                    "h": 138.7,
                    "l": 110.06,
                    "t": 1641013200000,
                    "n": 5014566
                },
                {
                    "v": 366849460,
                    "vw": 117.6915,
                    "o": 124.81,
                    "c": 105.19,
                    "h": 129.4,
                    "l": 100.02,
                    "t": 1643691600000,
                    "n": 4023313
                },
                {
                    "v": 1155151370,
                    "vw": 101.8404,
                    "o": 105.85,
                    "c": 108.8,
                    "h": 124.1112,
                    "l": 73.28,
                    "t": 1646110800000,
                    "n": 9650565
                },
                {
                    "v": 540824973,
                    "vw": 99.6676,
                    "o": 117.62,
                    "c": 97.09,
                    "h": 118.95,
                    "l": 81.8,
                    "t": 1648785600000,
                    "n": 5050293
                },
                {
                    "v": 482622227,
                    "vw": 89.986,
                    "o": 96.41,
                    "c": 96.05,
                    "h": 102.69,
                    "l": 78.01,
                    "t": 1651377600000,
                    "n": 4595567
                },
                {
                    "v": 721270023,
                    "vw": 107.8274,
                    "o": 95.9,
                    "c": 113.68,
                    "h": 121.38,
                    "l": 91.88,
                    "t": 1654056000000,
                    "n": 5984715
                },
                {
                    "v": 504662660,
                    "vw": 105.7618,
                    "o": 113.63,
                    "c": 89.37,
                    "h": 125.84,
                    "l": 89.11,
                    "t": 1656648000000,
                    "n": 4624173
                },
                {
                    "v": 509871987,
                    "vw": 94.1571,
                    "o": 89.19,
                    "c": 95.41,
                    "h": 104.85,
                    "l": 86.71,
                    "t": 1659326400000,
                    "n": 4561244
                },
                {
                    "v": 340950892,
                    "vw": 85.321,
                    "o": 92.75,
                    "c": 79.99,
                    "h": 94.84,
                    "l": 76.28,
                    "t": 1662004800000,
                    "n": 3177660
                },
                {
                    "v": 534289643,
                    "vw": 69.5478,
                    "o": 79.76,
                    "c": 63.58,
                    "h": 86.29,
                    "l": 58.01,
                    "t": 1664596800000,
                    "n": 4077840
                },
                {
                    "v": 645335420,
                    "vw": 75.074,
                    "o": 68.01,
                    "c": 87.56,
                    "h": 89.625,
                    "l": 63.4,
                    "t": 1667275200000,
                    "n": 5081862
                },
                {
                    "v": 436324597,
                    "vw": 89.2808,
                    "o": 84.35,
                    "c": 88.09,
                    "h": 94.98,
                    "l": 84.26,
                    "t": 1669870800000,
                    "n": 3680992
                },
                {
                    "v": 439860310,
                    "vw": 110.6493,
                    "o": 91.11,
                    "c": 110.2,
                    "h": 121.3,
                    "l": 90.75,
                    "t": 1672549200000,
                    "n": 4016216
                },
                {
                    "v": 405420617,
                    "vw": 99.6878,
                    "o": 111.86,
                    "c": 87.79,
                    "h": 113.95,
                    "l": 87.27,
                    "t": 1675227600000,
                    "n": 3448218
                },
                {
                    "v": 662236064,
                    "vw": 90.8097,
                    "o": 92.92,
                    "c": 102.18,
                    "h": 105.05,
                    "l": 79.48,
                    "t": 1677646800000,
                    "n": 5383741
                },
                {
                    "v": 440574191,
                    "vw": 93.0718,
                    "o": 100.89,
                    "c": 84.69,
                    "h": 103.24,
                    "l": 82.212,
                    "t": 1680321600000,
                    "n": 3474543
                },
                {
                    "v": 447989996,
                    "vw": 84.3975,
                    "o": 84.15,
                    "c": 79.55,
                    "h": 91.43,
                    "l": 77.77,
                    "t": 1682913600000,
                    "n": 3726462
                },
                {
                    "v": 335422653,
                    "vw": 86.8944,
                    "o": 79.35,
                    "c": 83.35,
                    "h": 94.29,
                    "l": 79.35,
                    "t": 1685592000000,
                    "n": 3308569
                },
                {
                    "v": 422658402,
                    "vw": 93.3689,
                    "o": 84.87,
                    "c": 102.16,
                    "h": 102.5,
                    "l": 82.64,
                    "t": 1688184000000,
                    "n": 3936439
                },
                {
                    "v": 397165162,
                    "vw": 93.8704,
                    "o": 99.87,
                    "c": 92.9,
                    "h": 101.84,
                    "l": 86.86,
                    "t": 1690862400000,
                    "n": 3769246
                },
                {
                    "v": 229477692,
                    "vw": 88.8076,
                    "o": 94.55,
                    "c": 86.74,
                    "h": 96.68,
                    "l": 83.76,
                    "t": 1693540800000,
                    "n": 2338845
                },
                {
                    "v": 256089866,
                    "vw": 83.5679,
                    "o": 86.75,
                    "c": 82.54,
                    "h": 88.7963,
                    "l": 79.02,
                    "t": 1696132800000,
                    "n": 2571704
                },
                {
                    "v": 416014473,
                    "vw": 80.0106,
                    "o": 81.705,
                    "c": 74.88,
                    "h": 87.83,
                    "l": 74.01,
                    "t": 1698811200000,
                    "n": 3734877
                },
                {
                    "v": 413549159,
                    "vw": 73.6906,
                    "o": 73.12,
                    "c": 77.51,
                    "h": 77.79,
                    "l": 70.08,
                    "t": 1701406800000,
                    "n": 3484993
                },
                {
                    "v": 497282955,
                    "vw": 72.2402,
                    "o": 76.05,
                    "c": 72.17,
                    "h": 76.69,
                    "l": 66.63,
                    "t": 1704085200000,
                    "n": 4257231
                },
                {
                    "v": 400968631,
                    "vw": 74.2251,
                    "o": 73.155,
                    "c": 74.03,
                    "h": 78.34,
                    "l": 70,
                    "t": 1706763600000,
                    "n": 3510577
                },
                {
                    "v": 270194348,
                    "vw": 73.4599,
                    "o": 74.48,
                    "c": 72.36,
                    "h": 77.45,
                    "l": 70.5825,
                    "t": 1709269200000,
                    "n": 2528423
                },
                {
                    "v": 312630808,
                    "vw": 72.5515,
                    "o": 73.24,
                    "c": 74.85,
                    "h": 76.93,
                    "l": 68.36,
                    "t": 1711944000000,
                    "n": 2642590
                },
                {
                    "v": 487343464,
                    "vw": 81.9611,
                    "o": 74.99,
                    "c": 78.34,
                    "h": 90.46,
                    "l": 74.87,
                    "t": 1714536000000,
                    "n": 4160358
                },
                {
                    "v": 235289325,
                    "vw": 76.0067,
                    "o": 79,
                    "c": 72,
                    "h": 80.055,
                    "l": 71.8,
                    "t": 1717214400000,
                    "n": 2174277
                },
                {
                    "v": 255566732,
                    "vw": 76.5203,
                    "o": 72.51,
                    "c": 78.85,
                    "h": 81.01,
                    "l": 71.97,
                    "t": 1719806400000,
                    "n": 2456325
                },
                {
                    "v": 336294326,
                    "vw": 80.9729,
                    "o": 78.77,
                    "c": 83.34,
                    "h": 85.79,
                    "l": 73.87,
                    "t": 1722484800000,
                    "n": 3144593
                },
                {
                    "v": 422093004,
                    "vw": 95.6924,
                    "o": 81.78,
                    "c": 106.12,
                    "h": 112.22,
                    "l": 80.3199,
                    "t": 1725163200000,
                    "n": 3699911
                },
                {
                    "v": 521256900,
                    "vw": 107.2266,
                    "o": 106.42,
                    "c": 97.98,
                    "h": 117.82,
                    "l": 95.52,
                    "t": 1727755200000,
                    "n": 4941383
                },
                {
                    "v": 317529879,
                    "vw": 90.6814,
                    "o": 98.22,
                    "c": 87.37,
                    "h": 101.1,
                    "l": 82.635,
                    "t": 1730433600000,
                    "n": 3109744
                },
                {
                    "v": 283493428,
                    "vw": 86.6228,
                    "o": 86.94,
                    "c": 84.79,
                    "h": 94.12,
                    "l": 81.7,
                    "t": 1733029200000,
                    "n": 2615748
                },
                {
                    "v": 400050536,
                    "vw": 91.5581,
                    "o": 84.39,
                    "c": 98.84,
                    "h": 103.665,
                    "l": 80.06,
                    "t": 1735707600000,
                    "n": 3679267
                },
                {
                    "v": 829201363,
                    "vw": 125.0324,
                    "o": 96.505,
                    "c": 132.51,
                    "h": 145.3,
                    "l": 96.07,
                    "t": 1738386000000,
                    "n": 7863103
                },
                {
                    "v": 475751327,
                    "vw": 137.7014,
                    "o": 134.01,
                    "c": 132.23,
                    "h": 148.43,
                    "l": 126.1,
                    "t": 1740805200000,
                    "n": 5040247
                },
                {
                    "v": 604983292,
                    "vw": 111.4424,
                    "o": 132.75,
                    "c": 119.43,
                    "h": 134.1,
                    "l": 95.73,
                    "t": 1743480000000,
                    "n": 6001919
                },
                {
                    "v": 301516196,
                    "vw": 124.7819,
                    "o": 120.19,
                    "c": 113.84,
                    "h": 134.51,
                    "l": 111.6,
                    "t": 1746072000000,
                    "n": 3299420
                },
                {
                    "v": 244592327,
                    "vw": 116.1615,
                    "o": 114.9,
                    "c": 113.41,
                    "h": 123.46,
                    "l": 111.26,
                    "t": 1748750400000,
                    "n": 2521780
                },
                {
                    "v": 328508840,
                    "vw": 114.733,
                    "o": 112.95,
                    "c": 120.63,
                    "h": 123.99,
                    "l": 103.71,
                    "t": 1751342400000,
                    "n": 3321339
                },
                {
                    "v": 304533739,
                    "vw": 124.297,
                    "o": 118.06,
                    "c": 135,
                    "h": 136.65,
                    "l": 116.11,
                    "t": 1754020800000,
                    "n": 3110836
                }
            ]
`````````

Thank you for your reply

this one sample output of HTTP

I can’t use collection because it changes the order, also they are numbers I can’t convert them to text either because I need them as numbers.