Hi !
I have the below json (let’s call it {{json.data}} )
I’m trying to get the value “ARM001” from the below json with this path :
{{json.data}}[‘Articles’][‘Article’][0][‘ReferenceEcommercant’]
but i’m getting the following error :
Script Error: Articles is not defined
how can i get this value out of the json to then use it in my flow ?
thank you
{
“_declaration”: {
“_attributes”: {
“version”: “1.0”,
“encoding”: “utf-8”
}
},
“Articles”: {
“Article”: [
{
“ReferenceEcommercant”: {
“_cdata”: “ARM001”
},
“Titre”: {
“_cdata”: “Artichauts grillés à l’huile d’olive vierge extra 100g”
},
“StockTotal”: {
“_text”: “403”
},
“StockVente”: {
“_text”: “391”
},
“StockBloque”: {
“_text”: “12”
},
“DLC”: {
“_text”: “29/12/2020”
},
“DLCFictive”: {
“_text”: “N”
}
},
{
“ReferenceEcommercant”: {
“_cdata”: “ART001”
},
“Titre”: {
“_cdata”: “Bocal de creme fine d’artichauts - 180g”
},
“StockTotal”: {
“_text”: “275”
},
“StockVente”: {
“_text”: “275”
},
“StockBloque”: {
“_text”: “0”
},
“DLC”: {
“_text”: “29/05/2019”
},
“DLCFictive”: {
“_text”: “N”
}
},
{
“ReferenceEcommercant”: {
“_cdata”: “ART002”
},
“Titre”: {
“_cdata”: “Creme fine d’artichauts 100g”
},
“StockTotal”: {
“_text”: “700”
},
“StockVente”: {
“_text”: “688”
},
“StockBloque”: {
“_text”: “12”
},
“DLC”: {
“_text”: “01/09/2019”
},
“DLCFictive”: {
“_text”: “N”
}
},
{
“ReferenceEcommercant”: {
“_cdata”: “ART003”
},
“Titre”: {
“_cdata”: “Crème fine d’artichaut 375g”
},
“StockTotal”: {
“_text”: “8”
},
“StockVente”: {
“_text”: “8”
},
“StockBloque”: {
“_text”: “0”
},
“DLC”: {
“_text”: “04/05/2019”
},
“DLCFictive”: {
“_text”: “N”
}
},
]
}
}