My first parse json

Questions
#1

Hello,

I’m new to n8n. I’m trying to extract certain data from HTTP Request but I’m can’t get the field value I want.

The data I’m receiving from webhook has this format:

[
{
"time_to_live": "1 years 0 mons 0 days 0 hours 0 mins 0.0 secs",
"timeout_type": "FIRST_SEEN",
"number_of_elements": 144,
"data": [
{
"last_seen": 1627660297855,
"first_seen": 1627660297855,
"source": "Fochcraft: DNS TLD Blacklist",
"value": "www.lavoixdulibre.info",
"domain_id": null
},
{
"last_seen": 1628578830289,
"first_seen": 1628578830289,
"source": "Fochcraft: DNS TLD Blacklist",
"value": "vpn-cn-sn.mpsa.cn",
"domain_id": null
}
],
"creation_time": 1576593373444,
"name": "Fochcraft : FQDN Blacklist",
"namespace": "SHARED",
"element_type": "ALN",
"collection_id": 34
}
]

I need to extract the value field value. In the request I can find many names.

Can anybody point me in the right direction?

Thank you for your help.

#2

Hey @focheur91300,

The value you are after is in an array so you would need to use something like item.json.data[index].value to access it where index is the position of the item in the array unless you loop it.

You should also be able to use the item list node to extract data to multiple items as well.