Hello everyone,
I’m currently facing an issue with processing JSON data retrieved from an HTTP request in my n8n workflow, and I’m hoping to get some guidance on how to resolve it.
I’m fetching a JSON data structure from an external API using an HTTP request node. The retrieved JSON data contains multiple items, and each item has a nested “elementList” with various properties. I’m trying to extract the “propertyCode” values from each item’s “elementList” and process them further.
Here’s a my JSON data:
{"elementList":[{"propertyCode":"97991946","thumbnail":"https://img3.idealista.com/blur/WEB_LISTING-M/0/id.pro.es.image.master/94/46/db/997369149.jpg","numPhotos":15,"floor":"1","price":400.0,"propertyType":"flat","operation":"rent","size":65.0,"exterior":false,"rooms":2,"bathrooms":1,"address":"Avenida de los Pescadores, 17","province":"Cádiz","municipality":"Chiclana de la Frontera","district":"La Barrosa","country":"es","locationId":"0-EU-ES-11-01-005-015-09","latitude":36.3716959,"longitude":-6.1784804,"showAddress":true,"url":"https://www.idealista.com/inmueble/97991946/","description":"Se alquila piso muy bonito para personal docente desde septiembre a junio. La vivienda tiene buenas calidades; suelo de mármol, mosquiteras en todas las habitaciones, aire acondicionado, calefacción, lavavajillas, microondas, terraza.. . etc. También dispone de mecedoras, sombrilla, y toallas de playa para los meses calurosos. La Barriada posee pistas deportivas (pádel, tenis, fútbol, baloncesto), extensas zonas ajardinadas, una Piscina de adultos y de pequeños grandísima las dos, con dos socorristas, más dos controladores. Tiene también Plaza de estacionamiento numerada y reservada junto al piso. Teléfono-Wasa.","hasVideo":false,"status":"good","firstActivationDate":1693177276000,"newDevelopment":false,"favourite":false,"newProperty":false,"multimedia":{"images":[{"url":"https://img3.idealista.com/blur/WEB_LISTING-M/0/id.pro.es.image.master/94/46/db/997369149.jpg","tag":"kitchen"},{"url":"https://img3.idealista.com/blur/WEB_LISTING-M/0/id.pro.es.image.master/6f/fd/7e/997369184.jpg","tag":"livingRoom"},{"url":"https://img3.idealista.com/blur/WEB_LISTING-M/0/id.pro.es.image.master/dd/f9/4a/997369272.jpg","tag":"livingRoom"},{"url":"https://img3.idealista.com/blur/WEB_LISTING-M/0/id.pro.es.image.master/9f/3b/32/997369325.jpg","tag":"bathroom"},{"url":"https://img3.idealista.com/blur/WEB_LISTING-M/0/id.pro.es.image.master/09/c2/e9/997369429.jpg","tag":"bedroom"},{"url":"https://img3.idealista.com/blur/WEB_LISTING-M/0/id.pro.es.image.master/be/38/40/997369443.jpg","tag":"bedroom"},{"url":"https://img3.idealista.com/blur/WEB_LISTING-M/0/id.pro.es.image.master/f2/81/cc/997369439.jpg","tag":"terrace"},{"url":"https://img3.idealista.com/blur/WEB_LISTING-M/0/id.pro.es.image.master/85/c7/6b/997369440.jpg","tag":"facade"},{"url":"https://img3.idealista.com/blur/WEB_LISTING-M/0/id.pro.es.image.master/78/82/e3/997369442.jpg","tag":"garden"},{"url":"https://img3.idealista.com/blur/WEB_LISTING-M/0/id.pro.es.image.master/5d/1f/ce/997369154.jpg","tag":"swimmingPool"},{"url":"https://img3.idealista.com/blur/WEB_LISTING-M/0/id.pro.es.image.master/ca/7d/b2/997369463.jpg","tag":"views"},{"url":"https://img3.idealista.com/blur/WEB_LISTING-M/0/id.pro.es.image.master/71/63/cf/997369445.jpg","tag":"terrace"},{"url":"https://img3.idealista.com/blur/WEB_LISTING-M/0/id.pro.es.image.master/1d/01/96/999597670.jpg","tag":"views"},{"url":"https://img3.idealista.com/blur/WEB_LISTING-M/0/id.pro.es.image.master/bc/88/d6/999597771.jpg","tag":"views"},{"url":"https://img3.idealista.com/blur/WEB_LISTING-M/0/id.pro.es.image.master/c0/1f/c0/999597823.jpg","tag":"views"}]},"contactInfo":{"phone1":{"phoneNumber":"639442143","formattedPhone":"639 44 21 43","prefix":"34","phoneNumberForMobileDialing":"+34639442143","nationalNumber":true},"contactName":"Juan Antonio","userType":"private","contactMethod":"all"},"hasLift":false,"parkingSpace":{"hasParkingSpace":true,"isParkingSpaceIncludedInPrice":true},"priceByArea":6.0,"features":{"hasSwimmingPool":true,"hasTerrace":true,"hasAirConditioning":true,"hasBoxRoom":false,"hasGarden":true},"detailedType":{"typology":"flat"},"suggestedTexts":{"subtitle":"La Barrosa, Chiclana de la Frontera","title":"Piso en Avenida de los Pescadores, 17"},"hasPlan":false,"has3DTour":false,"has360":false,"hasStaging":false,"urgentVisualHighlight":false,"visualHighlight":false,"preferenceHighlight":false,"topHighlight":false,"superTopHighlight":false,"topNewDevelopment":false},{"propertyCode":"102339361","thumbnail":"https://img3.idealista.com/blur/WEB_LISTING-M/0/id.pro.es.image.master/c1/37/f1/1153807325.jpg","externalReference":"E-732","numPhotos":22,"price":1200.0,"propertyType":"chalet","operation":"rent","size":195.0,"rooms":3,"bathrooms":3,"address":"barrio Pinar Alto","province":"Cádiz","municipality":"El Puerto de Santa María","district":"Crevillet - Pinar Alto","country":"es","neighborhood":"Pinar Alto","locationId":"0-EU-ES-11-01-002-027-02-003","latitude":36.5996914,"longitude":-6.2397101,"showAddress":false,"url":"https://www.idealista.com/inmueble/102339361/","description":"SE ALQUILA, todo el año sin amueblar. Chalet adosado, amplio e independiente, con garaje cubierto para 2 vehículos y trastero. Cerca del centro ciudad, zona de comercios, colegios, iglesias, hospitales, y del Soto de Vistahermosa. Acceso peatonal a la entrada principal a nivel de calle y con el coche desde el garaje subterráneo directamente a la vivienda. Distribuida en dos plantas más buhardilla. ▹ Planta Baja •Hall de entrada. •Aseo. •Salón con chimenea. •Comedor independiente. •Cocina y despensa. •Patio tendedero. ▹ Planta Alta •Dormitorio principal con muchos armarios y cuarto de baño ensuite. •Otros dos dormitorios dobles que comparten cuarto de baño. ▹ Buhardilla •Sala acondicionada como dormitorio con Split de aire acondicionado. •Salida a terraza exterior. ▹Sótano •Trastero muy grande. •Garaje subterráneo con acceso a plaza cerrada para 2 vehículos. ▹ Entrada directa a la casa desde el garaje. Dotaciones: •Chimenea. •Armarios vestidos. •Porche y jardín. •Trastero. •Plaza de aparcamiento. *** Asimismo, se informa al cliente que los honorarios de intermediación y otros gastos que pudiesen generar inherentes al arrendamiento del inmueble, no están incluidos en el precio. ***.","hasVideo":false,"status":"good","firstActivationDate":1693170995000,"newDevelopment":false,"favourite":false,"newProperty":false,"multimedia":{"images":[{"url":"https://img3.idealista.com/blur/WEB_LISTING-M/0/id.pro.es.image.master/c1/37/f1/1153807325.jpg","tag":"terrace"},{"url":"https://img3.idealista.com/blur/WEB_LISTING-M/0/id.pro.es.image.master/bd/db/74/1153807343.jpg","tag":"entranceExit"},{"url":"https://img3.idealista.com/blur/WEB_LISTING-M/0/id.pro.es.image.master/71/4c/ea/1153807344.jpg","tag":"facade"},{"url":"https://img3.idealista.com/blur/WEB_LISTING-M/0/id.pro.es.image.master/5b/08/e1/1153807345.jpg"},{"url":"https://img3.idealista.com/blur/WEB_LISTING-M/0/id.pro.es.image.master/e4/75/66/1153807346.jpg","tag":"bathroom"},{"url":"https://img3.idealista.com/blur/WEB_LISTING-M/0/id.pro.es.image.master/59/dd/f6/1153807347.jpg","tag":"livingRoom"},{"url":"https://img3.idealista.com/blur/WEB_LISTING-M/0/id.pro.es.image.master/91/0c/74/1153807326.jpg","tag":"livingRoom"},{"url":"https://img3.idealista.com/blur/WEB_LISTING-M/0/id.pro.es.image.master/47/36/69/1153807348.jpg","tag":"diningRoom"},{"url":"https://img3.idealista.com/blur/WEB_LISTING-M/0/id.pro.es.image.master/12/d1/26/1153807349.jpg","tag":"kitchen"},{"url":"https://img3.idealista.com/blur/WEB_LISTING-M/0/id.pro.es.image.master/fe/da/16/1153807350.jpg","tag":"kitchen"},{"url":"https://img3.idealista.com/blur/WEB_LISTING-M/0/id.pro.es.image.master/b2/ce/20/1153807327.jpg","tag":"kitchen"},{"url":"https://img3.idealista.com/blur/WEB_LISTING-M/0/id.pro.es.image.master/44/fe/e1/1153807351.jpg","tag":"bedroom"},{"url":"https://img3.idealista.com/blur/WEB_LISTING-M/0/id.pro.es.image.master/21/48/d0/1153807352.jpg","tag":"energyCertification"},{"url":"https://img3.idealista.com/blur/WEB_LISTING-M/0/id.pro.es.image.master/33/fa/92/1153807328.jpg","tag":"bathroom"},{"url":"https://img3.idealista.com/blur/WEB_LISTING-M/0/id.pro.es.image.master/28/ae/52/1153807353.jpg","tag":"bedroom"},{"url":"https://img3.idealista.com/blur/WEB_LISTING-M/0/id.pro.es.image.master/27/8b/18/1153807354.jpg","tag":"bathroom"},{"url":"https://img3.idealista.com/blur/WEB_LISTING-M/0/id.pro.es.image.master/79/4b/53/1153807329.jpg","tag":"bedroom"},{"url":"https://img3.idealista.com/blur/WEB_LISTING-M/0/id.pro.es.image.master/3a/04/c1/1153807330.jpg","tag":"details"},{"url":"https://img3.idealista.com/blur/WEB_LISTING-M/0/id.pro.es.image.master/24/43/3f/1153807355.jpg","tag":"room"},{"url":"https://img3.idealista.com/blur/WEB_LISTING-M/0/id.pro.es.image.master/8d/b0/e8/1153807356.jpg","tag":"terrace"},{"url":"https://img3.idealista.com/blur/WEB_LISTING-M/0/id.pro.es.image.master/41/db/62/1153807357.jpg","tag":"parkingSpace"},{"url":"https://img3.idealista.com/blur/WEB_LISTING-M/0/id.pro.es.image.master/e1/6f/cf/1153807452.jpg","tag":"parkingSpace"}]},"contactInfo":{"commercialName":"Elisa Terry Servicios Inmobiliarios","phone1":{"phoneNumber":"856630907","formattedPhone":"856 63 09 07","prefix":"34","phoneNumberForMobileDialing":"+34856630907","nationalNumber":true},"contactName":"Elisa Terry Servicios Inmobiliarios","userType":"professional","contactMethod":"all","micrositeShortName":"elisaterryserviciosinmobiliarios"},"parkingSpace":{"hasParkingSpace":true,"isParkingSpaceIncludedInPrice":true},"priceByArea":6.0,"features":{"hasTerrace":true,"hasAirConditioning":true,"hasBoxRoom":true,"hasGarden":true},"detailedType":{"typology":"chalet","subTypology":"terracedHouse"},"suggestedTexts":{"subtitle":"Pinar Alto, El Puerto de Santa María","title":"Chalet adosado"},"hasPlan":false,"has3DTour":false,"has360":false,"hasStaging":false,"urgentVisualHighlight":false,"visualHighlight":false,"preferenceHighlight":false,"topHighlight":false,"superTopHighlight":false,"topNewDevelopment":false},{"propertyCode":"102382183","thumbnail":"https://img3.idealista.com/blur/WEB_LISTING-M/0/id.pro.es.image.master/36/ac/cc/1153805097.jpg","numPhotos":9,"floor":"en","price":550.0,"propertyType":"flat","operation":"rent","size":65.0,"exterior":true,"rooms":2,"bathrooms":1,"address":"Calle Méjico, 55","province":"Cádiz","municipality":"Chiclana de la Frontera","district":"La Banda - Campo de Fútbol","country":"es","locationId":"0-EU-ES-11-01-005-015-02","latitude":36.4254253,"longitude":-6.1400418,"showAddress":true,"url":"https://www.idealista.com/inmueble/102382183/","description":"Se alquila piso de 65m2 de nueva construcción en Chiclana de la Frontera en la calle Méjico. Consta de salón, 2 dormitorios, 1 baño, armario empotrado y cocina amueblada con electrodomésticos. Dispone de patio privado, cuarto trastero y azotea transitable. Cuenta con placas para el agua caliente. Muy luminoso y fresco. Acabados de gran calidad. A estrenar. El piso se entrega sin amueblar. Precio 550€.","hasVideo":false,"status":"good","firstActivationDate":1693166679000,"newDevelopment":false,"favourite":false,"newProperty":false,"multimedia":{"images":[{"url":"https://img3.idealista.com/blur/WEB_LISTING-M/0/id.pro.es.image.master/36/ac/cc/1153805097.jpg","tag":"bedroom"},{"url":"https://img3.idealista.com/blur/WEB_LISTING-M/0/id.pro.es.image.master/b9/49/83/1153805064.jpg","tag":"kitchen"},{"url":"https://img3.idealista.com/blur/WEB_LISTING-M/0/id.pro.es.image.master/f5/80/2e/1153805078.jpg","tag":"bathroom"},{"url":"https://img3.idealista.com/blur/WEB_LISTING-M/0/id.pro.es.image.master/b0/3a/e3/1153805101.jpg","tag":"bedroom"},{"url":"https://img3.idealista.com/blur/WEB_LISTING-M/0/id.pro.es.image.master/42/0d/ee/1153805103.jpg","tag":"terrace"},{"url":"https://img3.idealista.com/blur/WEB_LISTING-M/0/id.pro.es.image.master/3c/7c/d7/1153805105.jpg","tag":"kitchen"},{"url":"https://img3.idealista.com/blur/WEB_LISTING-M/0/id.pro.es.image.master/54/e3/6f/1153805106.jpg","tag":"kitchen"},{"url":"https://img3.idealista.com/blur/WEB_LISTING-M/0/id.pro.es.image.master/c5/94/e2/1153805107.jpg","tag":"bedroom"},{"url":"https://img3.idealista.com/blur/WEB_LISTING-M/0/id.pro.es.image.master/da/1b/a4/1153805079.jpg","tag":"livingRoom"}]},"contactInfo":{"phone1":{"phoneNumber":"666677741","formattedPhone":"666 67 77 41","prefix":"34","phoneNumberForMobileDialing":"+34666677741","nationalNumber":true},"contactName":"CARMEN","userType":"private","contactMethod":"phone"},"hasLift":false,"priceByArea":8.0,"features":{"hasSwimmingPool":false,"hasTerrace":true,"hasAirConditioning":false,"hasBoxRoom":true,"hasGarden":false},"detailedType":{"typology":"flat"},"suggestedTexts":{"subtitle":"La Banda - Campo de Fútbol, Chiclana de la Frontera","title":"Piso en Calle Méjico, 55"},"hasPlan":false,"has3DTour":false,"has360":false,"hasStaging":false,"urgentVisualHighlight":false,"visualHighlight":false,"preferenceHighlight":false,"topHighlight":false,"superTopHighlight":false,"topNewDevelopment":false},{"propertyCode":"102382076","thumbnail":"https://img3.idealista.com/blur/WEB_LISTING-M/0/id.pro.es.image.master/47/88/e7/1153801995.jpg","numPhotos":9,"floor":"2","price":1100.0,"propertyType":"flat","operation":"rent","size":79.0,"exterior":false,"rooms":2,"bathrooms":1,"address":"Calle Cervantes, 45","province":"Cádiz","municipality":"Cádiz","district":"Mentidero - Teatro Falla - Alameda","country":"es","locationId":"0-EU-ES-11-01-001-012-01","latitude":36.5351962,"longitude":-6.3005586,"showAddress":true,"url":"https://www.idealista.com/inmueble/102382076/","description":"Alquiler piso en el centro de Cádiz, localización inmejorable. Disponible de Septiembre a Junio. Especial para profesores y estudiantes.","hasVideo":false,"status":"good","firstActivationDate":1693164102000,"newDevelopment":false,"favourite":false,"newProperty":false,"multimedia":{"images":[{"url":"https://img3.idealista.com/blur/WEB_LISTING-M/0/id.pro.es.image.master/47/88/e7/1153801995.jpg","tag":"livingRoom"},{"url":"https://img3.idealista.com/blur/WEB_LISTING-M/0/id.pro.es.image.master/c3/e7/d7/1153802006.jpg","tag":"livingRoom"},{"url":"https://img3.idealista.com/blur/WEB_LISTING-M/0/id.pro.es.image.master/ef/79/09/1153801972.jpg","tag":"bedroom"},{"url":"https://img3.idealista.com/blur/WEB_LISTING-M/0/id.pro.es.image.master/6a/5c/8a/1153802005.jpg","tag":"kitchen"},{"url":"https://img3.idealista.com/blur/WEB_LISTING-M/0/id.pro.es.image.master/f9/02/09/1153801994.jpg","tag":"bedroom"},{"url":"https://img3.idealista.com/blur/WEB_LISTING-M/0/id.pro.es.image.master/5f/68/81/1153802003.jpg","tag":"bedroom"},{"url":"https://img3.idealista.com/blur/WEB_LISTING-M/0/id.pro.es.image.master/40/25/aa/1153802004.jpg","tag":"kitchen"},{"url":"https://img3.idealista.com/blur/WEB_LISTING-M/0/id.pro.es.image.master/8b/2f/ac/1153801997.jpg","tag":"bedroom"},{"url":"https://img3.idealista.com/blur/WEB_LISTING-M/0/id.pro.es.image.master/73/63/15/1153801996.jpg","tag":"bathroom"}]},"contactInfo":{"phone1":{"phoneNumber":"620750707","formattedPhone":"620 75 07 07","prefix":"34","phoneNumberForMobileDialing":"+34620750707","nationalNumber":true},"contactName":"Katherine Reyes","userType":"private","contactMethod":"all"},"hasLift":false,"priceByArea":14.0,"features":{"hasSwimmingPool":false,"hasTerrace":false,"hasAirConditioning":false,"hasBoxRoom":false,"hasGarden":false},"detailedType":{"typology":"flat"},"suggestedTexts":{"subtitle":"Mentidero - Teatro Falla - Alameda, Cádiz","title":"Piso en Calle Cervantes, 45"},"hasPlan":false,"has3DTour":false,"has360":false,"hasStaging":false,"urgentVisualHighlight":false,"visualHighlight":false,"preferenceHighlight":false,"topHighlight":false,"superTopHighlight":false,"topNewDevelopment":false},{"propertyCode":"25333022","thumbnail":"https://img3.idealista.com/blur/WEB_LISTING-M/0/id.pro.es.image.master/1d/43/10/29086180.jpg","numPhotos":16,"price":800.0,"propertyType":"chalet","operation":"rent","size":90.0,"rooms":3,"bathrooms":2,"address":"Los Gallos - La Coquina","province":"Cádiz","municipality":"Chiclana de la Frontera","district":"Los Gallos - La Coquina","country":"es","locationId":"0-EU-ES-11-01-005-015-03","latitude":36.3976477,"longitude":-6.1720704,"showAddress":false,"url":"https://www.idealista.com/inmueble/25333022/","description":"Disponible año completo.","hasVideo":false,"status":"good","firstActivationDate":1693160897000,"newDevelopment":false,"favourite":false,"newProperty":false,"multimedia":{"images":[{"url":"https://img3.idealista.com/blur/WEB_LISTING-M/0/id.pro.es.image.master/1d/43/10/29086180.jpg","tag":"unknown"},{"url":"https://img3.idealista.com/blur/WEB_LISTING-M/0/id.pro.es.image.master/a8/17/c5/29086190.jpg","tag":"unknown"},{"url":"https://img3.idealista.com/blur/WEB_LISTING-M/0/id.pro.es.image.master/45/42/ae/29086192.jpg","tag":"unknown"},{"url":"https://img3.idealista.com/blur/WEB_LISTING-M/0/id.pro.es.image.master/b9/95/79/29086194.jpg","tag":"unknown"},{"url":"https://img3.idealista.com/blur/WEB_LISTING-M/0/id.pro.es.image.master/d4/77/92/29086197.jpg","tag":"unknown"},{"url":"https://img3.idealista.com/blur/WEB_LISTING-M/0/id.pro.es.image.master/c1/e2/94/29086199.jpg","tag":"unknown"},{"url":"https://img3.idealista.com/blur/WEB_LISTING-M/0/id.pro.es.image.master/5b/25/3f/29086200.jpg","tag":"unknown"},{"url":"https://img3.idealista.com/blur/WEB_LISTING-M/0/id.pro.es.image.master/d2/ca/a4/29086204.jpg","tag":"unknown"},{"url":"https://img3.idealista.com/blur/WEB_LISTING-M/0/id.pro.es.image.master/da/10/ed/29086211.jpg","tag":"unknown"},{"url":"https://img3.idealista.com/blur/WEB_LISTING-M/0/id.pro.es.image.master/c1/fe/8f/29085947.jpg","tag":"unknown"},{"url":"https://img3.idealista.com/blur/WEB_LISTING-M/0/id.pro.es.image.master/32/52/fb/29086225.jpg","tag":"unknown"},{"url":"https://img3.idealista.com/blur/WEB_LISTING-M/0/id.pro.es.image.master/34/f0/52/29086230.jpg","tag":"unknown"},{"url":"https://img3.idealista.com/blur/WEB_LISTING-M/0/id.pro.es.image.master/da/af/4b/29086237.jpg","tag":"unknown"},{"url":"https://img3.idealista.com/blur/WEB_LISTING-M/0/id.pro.es.image.master/45/43/42/29086246.jpg","tag":"unknown"},{"url":"https://img3.idealista.com/blur/WEB_LISTING-M/0/id.pro.es.image.master/5b/66/8a/29086270.jpg","tag":"unknown"},{"url":"https://img3.idealista.com/blur/WEB_LISTING-M/0/id.pro.es.image.master/b9/99/a8/29086274.jpg","tag":"unknown"}]},"contactInfo":{"phone1":{"phoneNumber":"674610708","formattedPhone":"674 61 07 08","prefix":"34","phoneNumberForMobileDialing":"+34674610708","nationalNumber":true},"contactName":"Lisandro","userType":"private","contactMethod":"all"},"parkingSpace":{"hasParkingSpace":true,"isParkingSpaceIncludedInPrice":true},"priceByArea":9.0,"features":{"hasSwimmingPool":true,"hasTerrace":true,"hasAirConditioning":false,"hasBoxRoom":true,"hasGarden":true},"detailedType":{"typology":"chalet","subTypology":"terracedHouse"},"suggestedTexts":{"subtitle":"Los Gallos - La Coquina, Chiclana de la Frontera","title":"Chalet adosado"},"hasPlan":false,"has3DTour":false,"has360":false,"hasStaging":false,"urgentVisualHighlight":false,"visualHighlight":false,"preferenceHighlight":false,"topHighlight":false,"superTopHighlight":false,"topNewDevelopment":false}],"total":2995,"totalPages":599,"actualPage":1,"itemsPerPage":5,"numPaginations":0,"summary":["Alquilar","Viviendas","Cádiz provincia","Todos los precios","Todos los tamaños"],"filter":{"locationName":"Cádiz"},"alertName":"Viviendas en Cádiz","totalAppliedFilters":0,"lowerRangePosition":0,"upperRangePosition":5,"paginable":true}
My objective is to iterate through each item in the fetched JSON data, extract the “propertyCode” values, and then perform some actions with those values.
Thank you!
