How do I get json info from array into json?

Post reply

❤Follow Topic(3)

0 favourites

6 posts

From the Asset Store

Array Editor

$5 USD

Supports 1D, 2D, 3D arrays. Import and export arrays in JSON format

paradine

- makkibo
- - Joined 27 Jun, 2021
  - 8 topics • 24 posts
- 1
- 19 Jul, 2021
- Quote
Hi... can someone tell me how can i read this json info to get in an array?

{

"lastUpdateId": 592561749532,

"E": 1626660385862,

"T": 1626660385852,

"bids": [ [ "16.69200", "123" ],

[ "16.69100", "82" ]
}

I need only the content of bids...
- dop2000
- - Joined 26 May, 2016
  - 139 topics • 12,609 posts
- 2
- 19 Jul, 2021
- Quote
You need to load this into JSON object using Parse action.

After that you can read values in bids section with JSON.Get

For example JSON.Get("bids.0.1") will return 123
- makkibo
- - Joined 27 Jun, 2021
  - 8 topics • 24 posts
- 1
- 19 Jul, 2021
- Quote
Hi. no, It doesn't work like that either ...

(Loading the data from a web with ajax) The data is loaded well in Json, but it does not recognize me to insert it into the array.

{

"lastUpdateId":594008409335,

"E":1626723768975,

"T":1626723768970,

"bids":
[
["0.1624","44198"],["0.1623","84634"],["0.1622","71814"],["0.1621","33161"],["0.1620","119369"],["0.1619","31096"],["0.1618","91864"],["0.1617","29794"],["0.1616","49058"],["0.1615","260063"],["0.1614","29659"],["0.3248","81"]
]

}

This is the content of JSON.

I need to separate the "Bids" values into an array, and I can't get them.

In other consult i have this JSON results,

And I can't get the intermediate values either

("31743.95", "31795.00", "31715.00", "31750.68", "3113.974") For example
[
[ 1626600600000, "31743.95", "31795.00", "31715.00", "31750.68", "3113.974", 1626601499999, "98870777.70955", 24287, "1703.773", "54098292.89283", "0" ],
[ 1626601500000, "31750.67", "31850.00", "31700.53", "31720.75", "5885.388", 1626602399999, "187076704.82843", 41161, "2871.636", "91296797.78024", "0" ],
[ 1626602400000, "31720.74", "31722.71", "31547.99", "31596.32", "8358.152", 1626603299999, "264442181.43620", 60650, "3610.197", "114242044.52215", "0" ]
]

I appreciate in advance any possible help
Try Construct 3

Develop games in your browser. Powerful, performant & highly capable.
Try Now Construct 3 users don't see these ads
- makkibo
- - Joined 27 Jun, 2021
  - 8 topics • 24 posts
- 1
- 19 Jul, 2021
- Quote
In other consult i have this JSON results,

And I can't get the intermediate values either

("31743.95", "31795.00", "31715.00", "31750.68", "3113.974") For example

[ > [ > 1626600600000, > "31743.95", > "31795.00", > "31715.00", > "31750.68", > "3113.974", > 1626601499999, > "98870777.70955", > 24287, > "1703.773", > "54098292.89283", > "0" > ],

[ > 1626601500000, > "31750.67", > "31850.00", > "31700.53", > "31720.75", > "5885.388", > 1626602399999, > "187076704.82843", > 41161, > "2871.636", > "91296797.78024", > "0" > ],

[ > 1626602400000, > "31720.74", > "31722.71", > "31547.99", > "31596.32", > "8358.152", > 1626603299999, > "264442181.43620", > 60650, > "3610.197", > "114242044.52215", > "0" > ]

]

I appreciate in advance any possible help

I can solve this part with

JSON.GET(".1") or (".2") etc...

But i cant take the first consult (BIDS) yet...
- dop2000
- - Joined 26 May, 2016
  - 139 topics • 12,609 posts
- 2
- 20 Jul, 2021
- Quote
Here you go, this example extracts all values into C3 array:

dropbox.com/s/bkx0p1e28ac4tdj/JSON_extractArray.c3p
You can also use this demo to read all keys from JSON:

dropbox.com/s/srgf9lme08by9wa/JSON-RecursiveRead.c3p
- makkibo
- - Joined 27 Jun, 2021
  - 8 topics • 24 posts
- 1
- 21 Jul, 2021
- Quote
Thanks so much... this work really good!!!