Issue posting to Zoho CRM Custom Module

Questions
,
1

I have gotten pretty far with my workflow so far, thanks mostly to this forum, but I am stuck again. I am trying to take my zillow api and post properties into a custom module in Zoho CRM. My Zoho CRM credentials are current and the connection is active.

here is the current error

{"status":"rejected","reason":{"message":"Bad request - please check your parameters","timestamp":1694556987262,"name":"NodeApiError","description":"400 - \"{\\\"code\\\":\\\"MANDATORY_NOT_FOUND\\\",\\\"details\\\":{\\\"api_name\\\":\\\"data\\\"},\\\"message\\\":\\\"required field not found\\\",\\\"status\\\":\\\"error\\\"}\\n\" - {\"code\":\"MANDATORY_NOT_FOUND\",\"details\":{\"api_name\":\"data\"},\"message\":\"required field not found\",\"status\":\"error\"}\n","context":{},"cause":{"message":"400 - \"{\\\"code\\\":\\\"MANDATORY_NOT_FOUND\\\",\\\"details\\\":{\\\"api_name\\\":\\\"data\\\"},\\\"message\\\":\\\"required field not found\\\",\\\"status\\\":\\\"error\\\"}\\n\"","name":"Error","stack":"Error: 400 - \"{\\\"code\\\":\\\"MANDATORY_NOT_FOUND\\\",\\\"details\\\":{\\\"api_name\\\":\\\"data\\\"},\\\"message\\\":\\\"required field not found\\\",\\\"status\\\":\\\"error\\\"}\\n\"\n    at createError (/usr/local/lib/node_modules/n8n/node_modules/axios/lib/core/createError.js:16:15)\n    at settle (/usr/local/lib/node_modules/n8n/node_modules/axios/lib/core/settle.js:17:12)\n    at RedirectableRequest.handleResponse (/usr/local/lib/node_modules/n8n/node_modules/axios/lib/adapters/http.js:238:9)\n    at RedirectableRequest.emit (node:events:525:35)\n    at RedirectableRequest.emit (node:domain:489:12)\n    at RedirectableRequest._processResponse (/usr/local/lib/node_modules/n8n/node_modules/follow-redirects/index.js:356:10)\n    at ClientRequest.RedirectableRequest._onNativeResponse (/usr/local/lib/node_modules/n8n/node_modules/follow-redirects/index.js:62:10)\n    at Object.onceWrapper (node:events:628:26)\n    at ClientRequest.emit (node:events:525:35)\n    at ClientRequest.emit (node:domain:489:12)\n    at HTTPParser.parserOnIncomingClient (node:_http_client:701:27)\n    at HTTPParser.parserOnHeadersComplete (node:_http_common:119:17)\n    at TLSSocket.socketOnData (node:_http_client:542:22)\n    at TLSSocket.emit (node:events:513:28)\n    at TLSSocket.emit (node:domain:489:12)\n    at addChunk (node:internal/streams/readable:324:12)\n    at readableAddChunk (node:internal/streams/readable:297:9)\n    at TLSSocket.Readable.push (node:internal/streams/readable:234:10)\n    at TLSWrap.onStreamRead (node:internal/stream_base_commons:190:23)\n    at TLSWrap.callbackTrampoline (node:internal/async_hooks:130:17)"}}}

Here is y parameters

image
image352Ă—865 24.8 KB

and here is the workflow

Share the output returned by the last node

ERROR: Bad request - please check your parameters
400 - "{\"code\":\"MANDATORY_NOT_FOUND\",\"details\":{\"api_name\":\"data\"},\"message\":\"required field not found\",\"status\":\"error\"}\n" - {"code":"MANDATORY_NOT_FOUND","details":{"api_name":"data"},"message":"required field not found","status":"error"}

What I have in Zoho CRM is a custom module names Properties, and it basically has all the important fields from the zillow API. What am I doing wrong? I have tried everything

3

Hi @djjace :wave: What’s your data structure like from Zillow and going into Zoho? If you could post a JSON example (with any sensitive data removed), that would help!

Can you also let us know the following:

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:
4

Hey,
thanks for the help

here is the workflow, with data

A text comes in ringcentral, and sends a webhook, which gives me this

[
  {
    "headers": {
      "host": "laurabrealtor.app.n8n.cloud",
      "x-request-id": "9c1038379771e26e970e28ebba448487",
      "x-real-ip": "3.238.134.18",
      "x-forwarded-for": "3.238.134.18",
      "x-forwarded-host": "laurabrealtor.app.n8n.cloud",
      "x-forwarded-port": "443",
      "x-forwarded-proto": "https",
      "x-forwarded-scheme": "https",
      "x-scheme": "https",
      "content-length": "110",
      "accept": "application/json",
      "content-type": "text/plain",
      "user-agent": "node-fetch/1.0 (+https://github.com/bitinn/node-fetch)"
    },
    "params": {},
    "query": {},
    "body": "Hello, this is new message, https://www.zillow.com/homedetails/540-Ohio-St-Lexington-KY-40508/77532621_zpid/ \n"
  }
]

then if the text includes “zillow.com” it continues and pulls the zpid from the text

which gives me this

[[
{
"headers": 
{
"host": 
"laurabrealtor.app.n8n.cloud",
"x-request-id": 
"9c1038379771e26e970e28ebba448487",
"x-real-ip": 
"3.238.134.18",
"x-forwarded-for": 
"3.238.134.18",
"x-forwarded-host": 
"laurabrealtor.app.n8n.cloud",
"x-forwarded-port": 
"443",
"x-forwarded-proto": 
"https",
"x-forwarded-scheme": 
"https",
"x-scheme": 
"https",
"content-length": 
"110",
"accept": 
"application/json",
"content-type": 
"text/plain",
"user-agent": 
"node-fetch/1.0 (+https://github.com/bitinn/node-fetch)"
},
"params": 
{
},
"query": 
{
},
"body": 
"Hello, this is new message, https://www.zillow.com/homedetails/540-Ohio-St-Lexington-KY-40508/77532621_zpid/ ",
"zpid": 
"77532621"
}
]

then I take that zpid and get the property details from the api, which gives me this

[
  {
    "listingProvider": {
      "enhancedVideoURL": null,
      "showNoContactInfoMessage": false,
      "postingGroupName": null,
      "isZRMSourceText": null,
      "showLogos": null,
      "logos": {},
      "sourceText": null,
      "title": "Listing Provided by",
      "disclaimerText": null,
      "postingWebsiteURL": null,
      "agentLicenseNumber": null,
      "postingWebsiteLinkText": "See listing website",
      "enhancedDescriptionText": null,
      "agentName": null
    },
    "zpid": 77532621,
    "buildingPermits": null,
    "propertyTaxRate": 0.91,
    "contact_recipients": [
      {
        "agent_reason": 1,
        "zpro": null,
        "recent_sales": 1,
        "review_count": 54,
        "display_name": "RE/MAX Creative Realty",
        "zuid": "X1-ZUylmejyo0xdzd_a3ta0",
        "rating_average": 5,
        "badge_type": "Premier Agent",
        "phone": {
          "prefix": "577",
          "areacode": "859",
          "number": "7660"
        },
        "image_url": "https://photos.zillowstatic.com/h_n/ISbluejal9nyz80000000000.jpg"
      }
    ],
    "zipcode": "40508",
    "openHouseSchedule": {},
    "longitude": -84.48284,
    "zestimateLowPercent": "17",
    "address": {
      "community": null,
      "city": "Lexington",
      "state": "KY",
      "neighborhood": null,
      "subdivision": null,
      "streetAddress": "540 Ohio St",
      "zipcode": "40508"
    },
    "cityId": 25574,
    "timeOnZillow": "1072 days",
    "url": "/homedetails/540-Ohio-St-Lexington-KY-40508/77532621_zpid/",
    "zestimate": 135700,
    "imgSrc": "https://maps.googleapis.com/maps/api/streetview?location=540+Ohio+St%2C+Lexington%2C+KY+40508&size=400x300&key=AIzaSyARFMLB1na-BBWf7_R3-5YOQQaHqEJf6RQ&source=outdoor&&signature=Hloh1VRx4DCYCjNlRQ2fDCgj5BU=",
    "description": "540 Ohio St, Lexington, KY 40508 is a single family home that contains 1,128 sq ft and was built in 1900. It contains 1 bathroom. This home last sold for $83,000 in October 2020. \n \nThe Zestimate for this house is $135,700. The Rent Zestimate for this home is $1,345/mo. ",
    "price": 83000,
    "livingAreaValue": 1128,
    "resoFacts": {
      "hasAttachedProperty": false,
      "frontageType": null,
      "poolFeatures": null,
      "flooring": {},
      "builderModel": null,
      "accessibilityFeatures": null,
      "hasGarage": false,
      "hasPetsAllowed": null,
      "bodyType": null,
      "topography": null,
      "landLeaseExpirationDate": null,
      "hasAdditionalParcels": false,
      "waterViewYN": null,
      "livingQuarters": {},
      "totalActualRent": null,
      "offerReviewDate": null,
      "horseYN": null,
      "view": {},
      "buyerAgencyCompensationType": null,
      "rooms": {},
      "belowGradeFinishedArea": null,
      "feesAndDues": {},
      "cityRegion": "Lexington",
      "mainLevelBathrooms": null,
      "hasPrivatePool": null,
      "associationFeeIncludes": null,
      "waterSource": null,
      "carportParkingCapacity": null,
      "inclusions": null,
      "hasFireplace": true,
      "gas": null,
      "sewer": null,
      "elevationUnits": null,
      "roadSurfaceType": null,
      "subdivisionName": null,
      "numberOfUnitsVacant": null,
      "hasWaterfrontView": null,
      "bathroomsOneQuarter": null,
      "lotSize": "6,081 sqft",
      "entryLevel": null,
      "irrigationWaterRightsAcres": null,
      "greenWaterConservation": null,
      "stories": null,
      "bathrooms": 1,
      "numberOfUnitsInCommunity": null,
      "listingTerms": null,
      "otherParking": null,
      "associationFee": null,
      "marketingType": null,
      "greenIndoorAirQuality": null,
      "greenSustainability": null,
      "heating": [
        "Other"
      ],
      "associationPhone": null,
      "greenBuildingVerificationType": null,
      "hasAttachedGarage": null,
      "bedrooms": null,
      "architecturalStyle": null,
      "listingId": null,
      "structureType": null,
      "interiorFeatures": null,
      "horseAmenities": null,
      "electric": null,
      "otherFacts": {},
      "lotFeatures": null,
      "roofType": null,
      "constructionMaterials": [
        "Frame"
      ],
      "fireplaceFeatures": null,
      "hoaFeeTotal": null,
      "doorFeatures": null,
      "taxAnnualAmount": 755,
      "bathroomsPartial": null,
      "bathroomsHalf": null,
      "daysOnZillow": 1072,
      "listAOR": null,
      "buildingName": null,
      "attic": null,
      "mainLevelBedrooms": null,
      "elementarySchool": null,
      "virtualTour": null,
      "hasCarport": null,
      "canRaiseHorses": false,
      "hasLandLease": false,
      "communityFeatures": {},
      "yearBuiltEffective": null,
      "middleOrJuniorSchool": null,
      "lotSizeDimensions": null,
      "hasHomeWarranty": false,
      "entryLocation": null,
      "yearBuilt": 1900,
      "propertySubType": null,
      "propertyCondition": null,
      "utilities": null,
      "parcelNumber": "16163301",
      "incomeIncludes": null,
      "highSchool": null,
      "isNewConstruction": null,
      "otherStructures": null,
      "livingArea": "1,128 sqft",
      "livingAreaRangeUnits": null,
      "buildingArea": null,
      "windowFeatures": null,
      "ownership": null,
      "woodedArea": null,
      "middleOrJuniorSchoolDistrict": null,
      "associationPhone2": null,
      "isSeniorCommunity": null,
      "foundationDetails": {},
      "frontageLength": null,
      "exteriorFeatures": [
        "Wood"
      ],
      "associationAmenities": null,
      "buildingFeatures": null,
      "hasCooling": true,
      "buildingAreaSource": null,
      "parkingFeatures": {},
      "foundationArea": null,
      "zoning": null,
      "hoaFee": null,
      "livingAreaRange": null,
      "bathroomsFull": null,
      "additionalParcelsDescription": null,
      "waterBodyName": null,
      "waterfrontFeatures": null,
      "aboveGradeFinishedArea": null,
      "zoningDescription": null,
      "levels": null,
      "basementYN": false,
      "hasView": false,
      "appliances": {},
      "securityFeatures": null,
      "elevation": null,
      "fencing": null,
      "greenEnergyEfficient": null,
      "developmentStatus": null,
      "ownershipType": null,
      "garageParkingCapacity": null,
      "associations": {},
      "waterView": "",
      "laundryFeatures": null,
      "buyerAgencyCompensation": null,
      "basement": "None",
      "additionalFeeInfo": null,
      "commonWalls": null,
      "homeType": "SingleFamily",
      "spaFeatures": null,
      "municipality": null,
      "bathroomsThreeQuarter": null,
      "hasSpa": false,
      "hasHeating": true,
      "associationFee2": null,
      "cooling": [
        "Central"
      ],
      "openParkingCapacity": null,
      "associationName2": null,
      "hasRentControl": null,
      "elementarySchoolDistrict": null,
      "otherEquipment": null,
      "associationName": null,
      "specialListingConditions": null,
      "furnished": false,
      "vegetation": null,
      "patioAndPorchFeatures": null,
      "bathroomsFloat": 1,
      "builderName": null,
      "highSchoolDistrict": null,
      "exclusions": null,
      "storiesTotal": null,
      "landLeaseAmount": null,
      "fireplaces": null,
      "availabilityDate": null,
      "cropsIncludedYN": null,
      "coveredParkingCapacity": null,
      "irrigationWaterRightsYN": null,
      "hasOpenParking": null,
      "onMarketDate": null,
      "hasElectricOnProperty": null,
      "parkingCapacity": 0,
      "pricePerSquareFoot": 74,
      "atAGlanceFacts": [
        {
          "factValue": "SingleFamily",
          "factLabel": "Type"
        },
        {
          "factValue": "1900",
          "factLabel": "Year Built"
        },
        {
          "factValue": "Other",
          "factLabel": "Heating"
        },
        {
          "factValue": "Central",
          "factLabel": "Cooling"
        },
        {
          "factValue": "0 spaces",
          "factLabel": "Parking"
        },
        {
          "factValue": "6,081 sqft",
          "factLabel": "Lot"
        },
        {
          "factValue": null,
          "factLabel": "Offer Review Date"
        }
      ],
      "hasAssociation": null
    },
    "taxHistory": [
      {
        "time": 1600042840642,
        "valueIncreaseRate": 0,
        "taxIncreaseRate": 0,
        "taxPaid": 678.3,
        "value": 53100
      },
      {
        "time": 1568420440642,
        "valueIncreaseRate": 0.77,
        "taxIncreaseRate": 0.77000153,
        "taxPaid": 678.3,
        "value": 53100
      },
      {
        "time": 1536884440642,
        "valueIncreaseRate": 0,
        "taxIncreaseRate": 0.049285363,
        "taxPaid": 383.22,
        "value": 30000
      },
      {
        "time": 1505348440642,
        "valueIncreaseRate": 0,
        "taxIncreaseRate": 0.08783841,
        "taxPaid": 365.22,
        "value": 30000
      },
      {
        "time": 1442190040642,
        "valueIncreaseRate": 0,
        "taxIncreaseRate": 0,
        "taxPaid": 335.73,
        "value": 30000
      },
      {
        "time": 1410654040642,
        "valueIncreaseRate": 0,
        "taxIncreaseRate": 0,
        "taxPaid": 335.73,
        "value": 30000
      },
      {
        "time": 1347582040642,
        "valueIncreaseRate": 0,
        "taxIncreaseRate": 0,
        "taxPaid": 335.73,
        "value": 30000
      },
      {
        "time": 1315959640642,
        "valueIncreaseRate": 0,
        "taxIncreaseRate": 0,
        "taxPaid": null,
        "value": null
      },
      {
        "time": 1284423640642,
        "valueIncreaseRate": 0,
        "taxIncreaseRate": 0,
        "taxPaid": null,
        "value": null
      },
      {
        "time": 1252887640642,
        "valueIncreaseRate": 0,
        "taxIncreaseRate": 0,
        "taxPaid": null,
        "value": null
      },
      {
        "time": 1221351640642,
        "valueIncreaseRate": 0,
        "taxIncreaseRate": 0,
        "taxPaid": null,
        "value": 30000
      },
      {
        "time": 1158193240642,
        "valueIncreaseRate": 0,
        "taxIncreaseRate": 0,
        "taxPaid": null,
        "value": null
      },
      {
        "time": 1126657240642,
        "valueIncreaseRate": 0,
        "taxIncreaseRate": 0,
        "taxPaid": null,
        "value": null
      },
      {
        "time": 1095121240642,
        "valueIncreaseRate": 0,
        "taxIncreaseRate": 0,
        "taxPaid": null,
        "value": null
      }
    ],
    "brokerId": null,
    "stateId": 24,
    "streetAddress": "540 Ohio St",
    "listingSubType": {
      "is_FSBA": false,
      "is_comingSoon": false,
      "is_newHome": false,
      "is_pending": false,
      "is_forAuction": false,
      "is_foreclosure": false,
      "is_bankOwned": false,
      "is_openHouse": false,
      "is_FSBO": false
    },
    "solarPotential": null,
    "dateSold": null,
    "countyId": null,
    "timeZone": "America/New_York",
    "homeType": "SINGLE_FAMILY",
    "livingAreaUnits": "sqft",
    "comingSoonOnMarketDate": null,
    "rentZestimate": 1345,
    "bathrooms": 1,
    "annualHomeownersInsurance": 349,
    "state": "KY",
    "propertyTypeDimension": "Single Family",
    "building": null,
    "listed_by": {
      "agent_reason": null,
      "zpro": null,
      "recent_sales": null,
      "review_count": null,
      "display_name": null,
      "badge_type": null,
      "business_name": null,
      "rating_average": null,
      "phone": null,
      "zuid": null,
      "image_url": null
    },
    "yearBuilt": 1900,
    "brokerageName": null,
    "pageViewCount": 2,
    "county": "Fayette County",
    "mortgageRates": {
      "thirtyYearFixedRate": null
    },
    "attributionInfo": {
      "buyerAgentName": null,
      "mlsName": null,
      "coAgentLicenseNumber": null,
      "listingOffices": [
        {
          "associatedOfficeType": "listOffice",
          "officeName": null
        }
      ],
      "lastUpdated": null,
      "buyerAgentMemberStateLicense": null,
      "brokerName": null,
      "listingAgreement": null,
      "infoString10": null,
      "trueStatus": null,
      "infoString3": null,
      "agentEmail": null,
      "agentName": null,
      "attributionTitle": null,
      "mlsId": null,
      "coAgentName": null,
      "coAgentNumber": null,
      "infoString5": null,
      "listingAgents": {},
      "agentPhoneNumber": null,
      "agentLicenseNumber": null,
      "providerLogo": null,
      "infoString16": null,
      "buyerBrokerageName": null,
      "mlsDisclaimer": null,
      "brokerPhoneNumber": null,
      "lastChecked": null
    },
    "monthlyHoaFee": null,
    "homeStatus": "SOLD",
    "homeFacts": null,
    "latitude": 38.04925,
    "datePosted": "",
    "bedrooms": null,
    "nearbyHomes": [
      {
        "miniCardPhotos": [
          {
            "url": "https://maps.googleapis.com/maps/api/staticmap?mobile=false&sensor=true&maptype=satellite&size=316x234&zoom=17&center=38.04930877685547,-84.48274993896484&key=AIzaSyBJsNQO5ZeG-XAbqqWLKwG08fWITSxg33w&&signature=K01kYerCb_xfyrbSi_O9-Za03Z8="
          }
        ],
        "zpid": 77527508,
        "longitude": -84.48275,
        "address": {
          "city": "Lexington",
          "state": "KY",
          "streetAddress": "544 Ohio St",
          "zipcode": "40508"
        },
        "price": 11000,
        "homeType": "SINGLE_FAMILY",
        "homeStatus": "OTHER",
        "currency": "USD",
        "latitude": 38.04931
      },
      {
        "miniCardPhotos": [
          {
            "url": "https://maps.googleapis.com/maps/api/streetview?location=536+Ohio+St%2C+Lexington%2C+KY+40508&size=316x234&key=AIzaSyARFMLB1na-BBWf7_R3-5YOQQaHqEJf6RQ&source=outdoor&&signature=TNRkA35uNi9j_9INiOHTmLTTRsc="
          }
        ],
        "zpid": 124045371,
        "longitude": -84.48294,
        "address": {
          "city": "Lexington",
          "state": "KY",
          "streetAddress": "536 Ohio St",
          "zipcode": "40508"
        },
        "price": 2250000,
        "homeType": "MULTI_FAMILY",
        "homeStatus": "SOLD",
        "currency": "USD",
        "latitude": 38.049175
      },
      {
        "miniCardPhotos": [
          {
            "url": "https://maps.googleapis.com/maps/api/staticmap?mobile=false&sensor=true&maptype=satellite&size=316x234&zoom=17&center=38.04935073852539,-84.4826889038086&key=AIzaSyBJsNQO5ZeG-XAbqqWLKwG08fWITSxg33w&&signature=TPPa6z5raJ7qzthQ93F9mIq27FM="
          }
        ],
        "zpid": 77538544,
        "longitude": -84.48269,
        "address": {
          "city": "Lexington",
          "state": "KY",
          "streetAddress": "546 Ohio St",
          "zipcode": "40508"
        },
        "price": 95700,
        "homeType": "SINGLE_FAMILY",
        "homeStatus": "OTHER",
        "currency": "USD",
        "latitude": 38.04935
      },
      {
        "miniCardPhotos": [
          {
            "url": "https://maps.googleapis.com/maps/api/streetview?location=532+Ohio+St%2C+Lexington%2C+KY+40508&size=316x234&key=AIzaSyARFMLB1na-BBWf7_R3-5YOQQaHqEJf6RQ&source=outdoor&&signature=DuA-u0PB7yPyqtSrqog8Gsv9-O4="
          }
        ],
        "zpid": 77518278,
        "longitude": -84.48305,
        "address": {
          "city": "Lexington",
          "state": "KY",
          "streetAddress": "532 Ohio St",
          "zipcode": "40508"
        },
        "price": 109200,
        "homeType": "SINGLE_FAMILY",
        "homeStatus": "OTHER",
        "currency": "USD",
        "latitude": 38.049103
      },
      {
        "miniCardPhotos": [
          {
            "url": "https://maps.googleapis.com/maps/api/streetview?location=550+Ohio+St%2C+Lexington%2C+KY+40508&size=316x234&key=AIzaSyARFMLB1na-BBWf7_R3-5YOQQaHqEJf6RQ&source=outdoor&&signature=0rrwpRKAvzNio1MUV5PX9s1Ip3s="
          }
        ],
        "zpid": 77536501,
        "longitude": -84.482605,
        "address": {
          "city": "Lexington",
          "state": "KY",
          "streetAddress": "550 Ohio St",
          "zipcode": "40508"
        },
        "price": 106100,
        "homeType": "SINGLE_FAMILY",
        "homeStatus": "OTHER",
        "currency": "USD",
        "latitude": 38.049408
      },
      {
        "miniCardPhotos": [
          {
            "url": "https://maps.googleapis.com/maps/api/streetview?location=530+Ohio+St%2C+Lexington%2C+KY+40508&size=316x234&key=AIzaSyARFMLB1na-BBWf7_R3-5YOQQaHqEJf6RQ&source=outdoor&&signature=1Qe_WsxK73D-3jP_RGXfgTkzxLE="
          }
        ],
        "zpid": 77538678,
        "longitude": -84.483154,
        "address": {
          "city": "Lexington",
          "state": "KY",
          "streetAddress": "530 Ohio St",
          "zipcode": "40508"
        },
        "price": 70400,
        "homeType": "SINGLE_FAMILY",
        "homeStatus": "OTHER",
        "currency": "USD",
        "latitude": 38.04904
      },
      {
        "miniCardPhotos": [
          {
            "url": "https://maps.googleapis.com/maps/api/streetview?location=554+Ohio+St%2C+Lexington%2C+KY+40508&size=316x234&key=AIzaSyARFMLB1na-BBWf7_R3-5YOQQaHqEJf6RQ&source=outdoor&&signature=pBJnsoni05I_DlPdkcMIfl2HXg4="
          }
        ],
        "zpid": 77535595,
        "longitude": -84.482506,
        "address": {
          "city": "Lexington",
          "state": "KY",
          "streetAddress": "554 Ohio St",
          "zipcode": "40508"
        },
        "price": 136900,
        "homeType": "SINGLE_FAMILY",
        "homeStatus": "OTHER",
        "currency": "USD",
        "latitude": 38.049477
      },
      {
        "miniCardPhotos": [
          {
            "url": "https://maps.googleapis.com/maps/api/streetview?location=539+Chestnut+St%2C+Lexington%2C+KY+40508&size=316x234&key=AIzaSyARFMLB1na-BBWf7_R3-5YOQQaHqEJf6RQ&source=outdoor&&signature=9Rc4Zi3yIepQOk6dg_YFAsMWCcY="
          }
        ],
        "zpid": 77515729,
        "longitude": -84.48256,
        "address": {
          "city": "Lexington",
          "state": "KY",
          "streetAddress": "539 Chestnut St",
          "zipcode": "40508"
        },
        "price": 202900,
        "homeType": "MULTI_FAMILY",
        "homeStatus": "OTHER",
        "currency": "USD",
        "latitude": 38.048904
      }
    ],
    "livingArea": 1128,
    "priceHistory": [
      {
        "priceChangeRate": 2.6086956521739,
        "date": "2020-10-06",
        "source": "Public Record",
        "postingIsRental": false,
        "time": 1601942400000,
        "sellerAgent": null,
        "showCountyLink": false,
        "attributeSource": {
          "infoString2": "Public Record",
          "infoString3": null,
          "infoString1": null
        },
        "pricePerSquareFoot": 74,
        "buyerAgent": null,
        "event": "Sold",
        "price": 83000
      },
      {
        "priceChangeRate": 0,
        "date": "2005-12-19",
        "source": "Bluegrass REALTORS®",
        "postingIsRental": false,
        "time": 1134950400000,
        "sellerAgent": null,
        "showCountyLink": false,
        "attributeSource": {
          "infoString2": "Bluegrass REALTORS®",
          "infoString3": "https://photos.zillowstatic.com/fp/e1323399a06ea122bee0b6638767efe7-zillow_web_logo_inf_11.jpg",
          "infoString1": "511841"
        },
        "pricePerSquareFoot": 20,
        "buyerAgent": null,
        "event": "Sold",
        "price": 23000
      }
    ],
    "favoriteCount": 0,
    "schools": [
      {
        "link": "https://www.greatschools.org/school?id=04078&state=KY",
        "rating": 3,
        "totalCount": null,
        "distance": 0.3,
        "assigned": null,
        "name": "William Wells Brown Elementary School",
        "studentsPerTeacher": null,
        "isAssigned": null,
        "size": null,
        "level": "Primary",
        "grades": "PK-5",
        "type": "Public"
      },
      {
        "link": "https://www.greatschools.org/school?id=00434&state=KY",
        "rating": 3,
        "totalCount": null,
        "distance": 0.4,
        "assigned": null,
        "name": "Lexington Trad Magnet School",
        "studentsPerTeacher": null,
        "isAssigned": null,
        "size": null,
        "level": "Middle",
        "grades": "6-8",
        "type": "Public"
      },
      {
        "link": "https://www.greatschools.org/school?id=05304&state=KY",
        "rating": 4,
        "totalCount": null,
        "distance": 2.6,
        "assigned": null,
        "name": "Frederick Douglass High School",
        "studentsPerTeacher": null,
        "isAssigned": null,
        "size": null,
        "level": "High",
        "grades": "9-12",
        "type": "Public"
      }
    ],
    "zestimateHighPercent": "18",
    "mlsid": null,
    "countyFIPS": "21067",
    "city": "Lexington",
    "providerListingID": null,
    "country": "USA",
    "currency": "USD",
    "isListedByOwner": null,
    "contingentListingType": null
  }
]

then I am trying to push that data into my custom module in zoho crm. right now the only field I have set up is the only mandatory field, which is the property name (api NAME).

but I am getting this


{
"status": 
"rejected",
"reason": 
{
"message": 
"Bad request - please check your parameters",
"timestamp": 
1694650897796,
"name": 
"NodeApiError",
"description": 
"400 - "{\"code\":\"MANDATORY_NOT_FOUND\",\"details\":{\"api_name\":\"data\"},\"message\":\"required field not found\",\"status\":\"error\"}\n" - {"code":"MANDATORY_NOT_FOUND","details":{"api_name":"data"},"message":"required field not found","status":"error"} ",
"context": 
{
},
"cause": 
{
"message": 
"400 - "{\"code\":\"MANDATORY_NOT_FOUND\",\"details\":{\"api_name\":\"data\"},\"message\":\"required field not found\",\"status\":\"error\"}\n"",
"name": 
"Error",
"stack": 
"Error: 400 - "{\"code\":\"MANDATORY_NOT_FOUND\",\"details\":{\"api_name\":\"data\"},\"message\":\"required field not found\",\"status\":\"error\"}\n" at createError (/usr/local/lib/node_modules/n8n/node_modules/axios/lib/core/createError.js:16:15) at settle (/usr/local/lib/node_modules/n8n/node_modules/axios/lib/core/settle.js:17:12) at RedirectableRequest.handleResponse (/usr/local/lib/node_modules/n8n/node_modules/axios/lib/adapters/http.js:238:9) at RedirectableRequest.emit (node:events:526:35) at RedirectableRequest.emit (node:domain:489:12) at RedirectableRequest._processResponse (/usr/local/lib/node_modules/n8n/node_modules/follow-redirects/index.js:356:10) at ClientRequest.RedirectableRequest._onNativeResponse (/usr/local/lib/node_modules/n8n/node_modules/follow-redirects/index.js:62:10) at Object.onceWrapper (node:events:629:26) at ClientRequest.emit (node:events:526:35) at ClientRequest.emit (node:domain:489:12) at HTTPParser.parserOnIncomingClient (node:_http_client:700:27) at HTTPParser.parserOnHeadersComplete (node:_http_common:119:17) at TLSSocket.socketOnData (node:_http_client:541:22) at TLSSocket.emit (node:events:514:28) at TLSSocket.emit (node:domain:489:12) at addChunk (node:internal/streams/readable:324:12) at readableAddChunk (node:internal/streams/readable:297:9) at TLSSocket.Readable.push (node:internal/streams/readable:234:10) at TLSWrap.onStreamRead (node:internal/stream_base_commons:190:23) at TLSWrap.callbackTrampoline (node:internal/async_hooks:130:17)"
}
}
}
5

Hi @djjace - thanks so much for that. However, with your extremely detailed description (and thanks so much), I’ve realised exactly what you meant by custom module, and unfortunately this is only available on an Enterprise or Ultimate plan in Zoho, which doesn’t seem to have a free trial :see_no_evil: So sadly, I can’t test this one to help you out.

Is this request working outside of n8n, like in Postman or Insomnia? If it is, could you provide the working cURL request here with any sensitive details like credentials omitted/redacted? Then I could at least try to help you re-build this request in n8n :bowing_man:

1 Like
6

I have only tried it in n8n, as I have no idea how to make postman run lol

7

If you’re interested in trying, Postman have some pretty comprehensive documentation to get you started, and it would help debug the issue too :bowing_man:

8

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.