Help with JSON feed

Created on 16 July 2024, 4 months ago
Updated 5 August 2024, 4 months ago

Problem/Motivation

Trying to import from the following JSON and I keep receiving an Array error or an AJAX error occurred:

{"success":true,"data":{"analyticsTaxonomy":{"activity":"listing_search","areaName":"Hacheston","bedsMax":null,"bedsMin":null,"brand":"zoopla","countryCode":"gb","countyAreaName":"Suffolk","currencyCode":"GBP","expandedResultsCount":0,"geoIdentifier":"hacheston","listingsCategory":"residential","outcode":"IP13","outcodes":["IP13"],"page":"/for-sale/results/","postalArea":"IP","priceMax":null,"priceMin":null,"radius":null,"regionName":"East of England","resultsSort":"newest_listings","searchGuid":"","searchIdentifier":"2bd1d13905a5da001a094e210bcff3ec65db6697fb7d1c8795944f1f33aeef66","searchLocation":null,"searchResultsCount":3,"section":"for-sale","totalResults":3,"url":"/api/search/mobile/?page=1&location.identifier=hacheston&location.value=Hacheston%2C+Suffolk&section=for-sale&sortOrder=newest_listings&excludeRadius=true&furnishedState=Any","viewType":"List"},"listings":{"regular":[{"address":"The Street, Hacheston, Woodbridge, Suffolk IP13","agent":{"logoUri":"https://st.zoocdn.com/zoopla_static_agent_logo_(648969).png","branchId":"106838","branchName":"Savills - Ipswich","phone":"01473 558045"},"attributes":{"bedrooms":5,"bathrooms":4,"livingRooms":4},"flag":null,"highlights":[],"imageUris":["https://lid.zoocdn.com/645/430/7ff29f5c276a0ccfc2ebe916f581a4a2073116ad.jpg","https://lid.zoocdn.com/645/430/59c743b3d1e15613efbf12a38991053e335842b7.jpg","https://lid.zoocdn.com/645/430/3fe9b4b495fff2b1d942866c1c44d1cfc680bf15.jpg","https://lid.zoocdn.com/645/430/42e7f080daf2d514ff9002995689081157385083.jpg","https://lid.zoocdn.com/645/430/b03f82117f8b09ec9600b4de562622cf393b845b.jpg","https://lid.zoocdn.com/645/430/5cb4820d117b34eedc60f030cc5def9a2af541f4.jpg","https://lid.zoocdn.com/645/430/bd11af36354e75bbb8a6cf2602e938c9b76dda03.jpg","https://lid.zoocdn.com/645/430/f186519b65521be6fb32f469ac09cf7ac3488470.jpg","https://lid.zoocdn.com/645/430/d3279d0e66317fcf1c32ae5e6ee4e7f340654cb9.jpg","https://lid.zoocdn.com/645/430/b54139b718b8d05f615344b8ef68d48f2eb74375.jpg","https://lid.zoocdn.com/645/430/1d4a1ecaffa71749c8ba44835a9aa7a3f2e4ced9.jpg","https://lid.zoocdn.com/645/430/5af899693140e4e69d19f0aa5163527970ed3f78.jpg","https://lid.zoocdn.com/645/430/822ed28d9c0903a1bfaf2d9271abc3c3e4afe3b5.jpg","https://lid.zoocdn.com/645/430/aae1f3307fe73c8b3f291c3c96700271a6bad4b6.jpg","https://lid.zoocdn.com/645/430/90a459ac9281dcfc33080112c1b6f7d3e54bf98a.jpg","https://lid.zoocdn.com/645/430/34b9320b03e7823609ba245c3190458c99232ade.jpg","https://lid.zoocdn.com/645/430/489d60f69c75d931ce166b3dea4cf4bc65d4c78d.jpg","https://lid.zoocdn.com/645/430/69676034e6b1414b6a1e70b499c9e8ccf0717331.jpg","https://lid.zoocdn.com/645/430/7897a466e9059358e240d0b50d114b0cc81c3e4d.jpg","https://lid.zoocdn.com/645/430/3f145f03ea95108ac1ab5f41b430dfc6f9a9449f.jpg","https://lid.zoocdn.com/645/430/97565bcf10387a7d1e375e9c04df9a471504d01c.jpg","https://lid.zoocdn.com/645/430/b4d34bfee5004657a7e0932e69d42d9bf6eac3a6.jpg","https://lid.zoocdn.com/645/430/58410d3ea961e35a18361e5ccbdb0e42aa99453d.jpg","https://lid.zoocdn.com/645/430/3237bd30acd90e34ef6b2bf53db53488a10a9658.jpg","https://lid.zoocdn.com/645/430/fac9173154a25893db8901f0f5096b65fdbf0306.jpg"],"isExpired":false,"isFeatured":false,"isPremium":false,"listingId":"67667844","location":{"coordinates":{"latitude":52.174752,"longitude":1.378363}},"pricing":{"value":1850000,"qualifier":"guide_price","qualifierLabel":"Guide price","label":"£1,850,000"},"publicationStatus":"Live","tags":[{"label":"Freehold"}],"title":"5 bed detached house for sale"},{"address":"Nonsuch Cottage, Hacheston, Suffolk IP13","agent":{"logoUri":"https://st.zoocdn.com/zoopla_static_agent_logo_(719159).png","branchId":"62884","branchName":"Huntingfield Estates","phone":"01728 572197"},"attributes":{"bedrooms":4,"bathrooms":2,"livingRooms":4},"flag":null,"highlights":[],"imageUris":["https://lid.zoocdn.com/645/430/127b4dfa549c42ab409bd6685603fe65941e7e8a.jpg","https://lid.zoocdn.com/645/430/9c809a3d043f26cd0ef3c35975df106ff491b8a9.jpg","https://lid.zoocdn.com/645/430/75547e604fd7682b9776fbea956ce20942dc76eb.jpg","https://lid.zoocdn.com/645/430/f4aa344c71c6313a7116ad5f09ef97f1df85c0e5.jpg","https://lid.zoocdn.com/645/430/c3dbea883ccf44cd9af34cc3616a699dcc2835d8.jpg","https://lid.zoocdn.com/645/430/99b74abdee1d44f6a82f168068180126787731e8.jpg","https://lid.zoocdn.com/645/430/7a96089447d647d840b0e6346be44fff553a6ef6.jpg","https://lid.zoocdn.com/645/430/8d05019ef4dfbf000183031b402aec94b24e587b.jpg","https://lid.zoocdn.com/645/430/61665be52d0b0a75f8c416b1ec7275c054eb5573.jpg","https://lid.zoocdn.com/645/430/748ac3fa0c11b2c3042276ceae0104d007300238.jpg","https://lid.zoocdn.com/645/430/5ac4089bab654449c653c0716c169eff6278b5ab.jpg","https://lid.zoocdn.com/645/430/b6c587249bdd3bbf371ce9d05b35ebf3d7a14128.jpg","https://lid.zoocdn.com/645/430/0c130ba14ac42417295fc7eed1489df851df2cc0.jpg","https://lid.zoocdn.com/645/430/fe639d2b60626f5d84429793dd2beb73c87051f7.jpg","https://lid.zoocdn.com/645/430/9738e2a1ef9767b448ad648659898a13642e364c.jpg","https://lid.zoocdn.com/645/430/4da1911152fb03a59bb619f0b7869807fd183173.jpg","https://lid.zoocdn.com/645/430/5a2b54900caf6a61596f10ee8800c39d62397038.jpg","https://lid.zoocdn.com/645/430/78c3c270ae87f2451ffd153683a96b458cf3c17d.jpg","https://lid.zoocdn.com/645/430/6c7a081990b4e6203bdd5901d5424af59c12c7a4.jpg","https://lid.zoocdn.com/645/430/aaaedf622df5d05ae47e215ce2c1b72c34551821.jpg","https://lid.zoocdn.com/645/430/6f7fb8ffe52ac97a5b6b11e8afce6dc63dc4100c.jpg","https://lid.zoocdn.com/645/430/c24e1c7051fc9ae90513d87e22f2df1ad91b19a8.jpg","https://lid.zoocdn.com/645/430/ec9a41efa88fa4a544c7cec66e51170f9283b9c0.jpg"],"isExpired":false,"isFeatured":false,"isPremium":false,"listingId":"67413152","location":{"coordinates":{"latitude":52.181263,"longitude":1.376901}},"pricing":{"value":575000,"qualifier":"guide_price","qualifierLabel":"Guide price","label":"£575,000"},"publicationStatus":"Live","tags":[{"label":"Freehold"}],"title":"4 bed detached house for sale"},{"address":"Easton Lane, Hacheston, Woodbridge IP13","agent":{"logoUri":"https://st.zoocdn.com/zoopla_static_agent_logo_(381360).png","branchId":"8077","branchName":"William H Brown - Woodbridge","phone":"01394 807931"},"attributes":{"bedrooms":3,"bathrooms":1,"livingRooms":1},"flag":null,"highlights":[],"imageUris":["https://lid.zoocdn.com/645/430/849852cbbb8f55d2467908c5681ccb06243ca0a3.jpg","https://lid.zoocdn.com/645/430/8dd69182b5817c84121b838fbc5ddbec7aad900a.jpg","https://lid.zoocdn.com/645/430/1a59a3b288a62b45787a27f8ad4950e4e9ba51a1.jpg","https://lid.zoocdn.com/645/430/571f37c4f2feaa79cf893aa691846c4476e93301.jpg","https://lid.zoocdn.com/645/430/da56ae9d7717b26c7683ecac115ef9f314824b3c.jpg","https://lid.zoocdn.com/645/430/50a2d3a47dfacc55c9f054fe600475959eea6def.jpg","https://lid.zoocdn.com/645/430/f7914e8bd8055e67b26e426cc4b93356ee5325d5.jpg","https://lid.zoocdn.com/645/430/bb8da34188cf035abfb253fadada36595184438d.jpg","https://lid.zoocdn.com/645/430/e1da826652668da1807fbc56e6e17c57d083b900.jpg","https://lid.zoocdn.com/645/430/dad3b0e25095ec757daf6cf83d8bbad4814ed897.jpg","https://lid.zoocdn.com/645/430/08d7df30b2d7d5efe3138839bb02d9ba276f86ea.jpg","https://lid.zoocdn.com/645/430/9ecd2e5d687d7123e9954c8293445669d8e9cf57.jpg","https://lid.zoocdn.com/645/430/77c361ec8cee9baa7fd7c60feae32e3decef838c.jpg","https://lid.zoocdn.com/645/430/9cb606b3c3cdd23af5097ccf6fe6fb7fd1f1fca6.jpg","https://lid.zoocdn.com/645/430/b29aca260af1e985e215708810c0a6fd8604d98a.jpg","https://lid.zoocdn.com/645/430/05733406ee30364bb5e0cf199b17c627c1a0f70b.jpg","https://lid.zoocdn.com/645/430/c72f65a0a3ccd6a7905b250fd326f48559396937.jpg","https://lid.zoocdn.com/645/430/7ff568e610d1bbd1b62937a1bc5b719bac9a4027.jpg"],"isExpired":false,"isFeatured":false,"isPremium":true,"listingId":"66302307","location":{"coordinates":{"latitude":52.182192,"longitude":1.367663}},"pricing":{"value":280000,"qualifier":"","qualifierLabel":"","label":"£280,000"},"publicationStatus":"Live","tags":[{"label":"Freehold"}],"title":"3 bed detached bungalow for sale"}],"extended":null,"featured":[]},"geoData":{"polygon":{"coordinates":[[[1.387197,52.182303],[1.386817,52.183972],[1.379807,52.185751],[1.37798,52.186651],[1.377233,52.187908],[1.375406,52.187614],[1.373716,52.189185],[1.372519,52.189171],[1.367484,52.185988],[1.359351,52.188141],[1.35784,52.184257],[1.362972,52.175432],[1.362232,52.174475],[1.354724,52.172986],[1.354214,52.168264],[1.357517,52.164646],[1.356804,52.163403],[1.353883,52.16647],[1.355567,52.164506],[1.355461,52.163213],[1.354263,52.162222],[1.355021,52.161824],[1.353931,52.161286],[1.354297,52.160673],[1.353775,52.160003],[1.354526,52.159496],[1.356806,52.160004],[1.356935,52.159115],[1.360594,52.159326],[1.364253,52.161549],[1.364057,52.162033],[1.365745,52.161985],[1.367564,52.163389],[1.374392,52.16402],[1.376335,52.163604],[1.378888,52.161786],[1.374378,52.159496],[1.376501,52.158653],[1.376572,52.158167],[1.378067,52.158086],[1.380052,52.160008],[1.380757,52.15943],[1.382393,52.161326],[1.390462,52.159646],[1.392802,52.163511],[1.390052,52.165232],[1.397406,52.167757],[1.394469,52.170306],[1.392265,52.171134],[1.39147,52.172605],[1.389951,52.173435],[1.391808,52.175102],[1.391759,52.175604],[1.389921,52.179978],[1.38873,52.18056],[1.387197,52.182303]]],"type":"Polygon"},"radius":null,"geoIdentifier":"hacheston","geoType":"area","coordinates":[1.3728495,52.175507],"label":"Hacheston"},"pagination":{"totalResults":3,"totalResultsWasLimited":false}}}

Any help appreciated.

Steps to reproduce

Proposed resolution

Remaining tasks

User interface changes

API changes

Data model changes

💬 Support request
Status

Closed: works as designed

Component

JSONPath parser

Created by

🇬🇧United Kingdom sksshed

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

  • Issue created by @sksshed
  • Status changed to Postponed: needs info 4 months ago
  • 🇳🇱Netherlands megachriz

    The JSON at least looks to load fine. So perhaps you made an error in your configuration? Can you share the feed type that you created to import this?

    I've tried to import the three listings and mapped 'address' to 'title' and that worked fine. See the attachment for the feed type that I created to test it.

  • 🇬🇧United Kingdom sksshed

    Thanks, it was my context which was wrong. All working ok now.

  • Status changed to Closed: works as designed 4 months ago
  • 🇳🇱Netherlands megachriz

    Alright, thanks for reporting back!

    In the far future I'd like to add a preview feature to the mapping form page, similar to the preview feature in Views. The idea is that the preview displays a table with the parsed data and as you update mappings or - in this case - context, you would get quicker feedback on your configuration.
    It will take a long while before I get to it, there's enough other stuff to work on too.

Production build 0.71.5 2024