Javascript : Json traversing list

[ttv_neezy]

Hello, I wan’t to return minimal object[price] on all these object list, I use javascript but I think list indexing is bugged

the api used is : https://api.gtaliferp.fr:8443/v1/extinction/marketplace/sell/weapon_assaultrifle

thank for the help.

[david]

items is a string value, not an array. You should use JSON.parse(p1) to get data, but better yet, use the Transform JSON plugin:

Transform JSON column • Glide

[ttv_neezy]

@david

JSON.parse(p1)

hey, thank for your response but i tried the 2 options and no one works

have you another idea ?

[ThinhDinh]

You can use this jq query in the original column if what you want is just the 1st id.

[david]

@ttv_neezy

const data = JSON.parse(p1);
return data[0];

[ttv_neezy]

to explain I search to compare all “price” in this api so I think I need to use javascript

[ttv_neezy]

thank for your response but same when i just want to get data, it returns nothing

[ThinhDinh]

Ah that’s true. Yeah I think Javascript is needed.

[ThinhDinh]

Here you go. First I returned a list of prices from the API.

Then use JavaScript to get the minimum from the array.

const arr = p1.replace("[","").replace("]","").split(",");
const min = Math.min(...arr)
return min;

[ttv_neezy]

Is a way to send a notification with these data ?

[ThinhDinh]

If you’re talking about native notifications then no.

If it’s not native notification then please elaborate on what type of notification you want people to receive.

[ttv_neezy]

@ThinhDinh

f it’s not native notification then please elaborate on wh

yes i was talking about native notification so thank you for your help and have a good day