JSON single lines Output

Help Activities
, , , , ,
1

Hey, I have the following JSON output via API.

{

    "error": [ ],
    "result": 

{

    "XXBTZUSD": 

[

[

    1616662740,
    "52591.9",
    "52599.9",
    "52591.8",
    "52599.9",
    "52599.1",
    "0.11091626",
    5

],
[

    1616662800,
    "52600.0",
    "52674.9",
    "52599.9",
    "52665.2",
    "52643.3",
    "2.49035996",
    30

],
[

    1616662860,
    "52677.7",
    "52686.4",
    "52602.1",
    "52609.5",
    "52634.5",
    "1.25810675",
    20

],
[

    1616662920,
    "52603.9",
    "52627.5",
    "52601.2",
    "52616.4",
    "52614.0",
    "3.42391799",
    23

],

            [
                1616662980,
                "52601.2",
                "52601.2",
                "52599.9",
                "52599.9",
                "52599.9",
                "0.43748934",
                7
            ]
        ],
        "last": 1616662920
    }

}

But now I would like to read out individual values, i.e. these between the brackets. How do I set that up so that I can, for example, read out specifically to No. 7 or No. 50 etc? (a total of 720 always).

I ask via http request and deseralize the json.
grafik

This is the output:

{
  "XXBTZEUR": [
    [
      1638302400,
      "50924.3",
      "51036.5",
      "50558.8",
      "50694.1",
      "50752.9",
      "36.97996593",
      1276
    ],
    [
      1638306000,
      "50683.6",
      "50953.6",
      "50164.7",
      "50390.0",
      "50484.3",
      "49.05962932",
      1292
    ],
    [
      1638309600,
      "50390.1",
      "50751.4",
      "50328.2",
      "50565.6",
      "50560.7",
      "24.78866738",
      841
    ],
    [
      1638313200,
      "50565.6",
      "50628.9",
      "50138.4",
      "50269.2",
      "50362.6",
      "21.96716662",
      950
    ]
  ],
  "last": 1640887200
}
2

Try like this

Json_var(“XXBTZUSD”)(0)(7).ToString

Use the above syntax in write line activity and it will print value 5 you have to traverse according to json like above syntax

Thanks,
Robin

1 Like
3

Oh wow. This was too simple. Thank you very much!!

4

Your welcome

5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.