self hosted set up here. I can’t figure out why this is repeating. it completes and everything works perfect and I check the executions and it has run 40 times in 5 minutes. over and over
{
"meta": {
"templateCredsSetupCompleted": true,
"instanceId": "32661e4be5fdf7b33ada1a81089c57c1c62780434c5f9270e23ac9b71180fa02"
},
"nodes": [
{
"parameters": {
"method": "PUT",
"url": "=https://www.zohoapis.com/crm/v6/Property/{{ $('Webhook').first().json.query.id }}",
"authentication": "predefinedCredentialType",
"nodeCredentialType": "zohoOAuth2Api",
"sendQuery": true,
"queryParameters": {
"parameters": [
{}
]
},
"sendBody": true,
"bodyParameters": {
"parameters": [
{
"name": "data",
"value": "={{ $json.data }}"
}
]
},
"options": {
"response": {
"response": {
"fullResponse": true,
"responseFormat": "json"
}
}
}
},
"id": "3ac2b01d-60e8-45f1-9301-1a8d2e194965",
"name": "Add Property CRM",
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.1,
"position": [
1060,
-340
],
"executeOnce": true,
"credentials": {
"zohoOAuth2Api": {
"id": "6WcZrYGR3bVX34Ft",
"name": "Zoho account"
}
}
},
{
"parameters": {
"path": "32f2d7bb-7b5b-459e-8430-daccf58cea91",
"options": {
"responseData": "success"
}
},
"id": "f16f8e34-047c-4a54-8a5e-9b3bd52f268b",
"name": "Webhook",
"type": "n8n-nodes-base.webhook",
"typeVersion": 1.1,
"position": [
-1060,
-300
],
"webhookId": "32f2d7bb-7b5b-459e-8430-daccf58cea91"
},
{
"parameters": {
"url": "https://unofficial-redfin.p.rapidapi.com/auto-complete",
"sendQuery": true,
"queryParameters": {
"parameters": [
{
"name": "location",
"value": "={{ $('Webhook').item.json.query.street }} {{ $('Webhook').item.json.query.city }} {{ $('Webhook').item.json.query.state }} {{ $('Webhook').item.json.query.zip }}"
},
{
"name": "limit",
"value": "10"
}
]
},
"sendHeaders": true,
"headerParameters": {
"parameters": [
{
"name": "X-RapidAPI-Key",
"value": "XX"
},
{
"name": "X-RapidAPI-Host",
"value": "unofficial-redfin.p.rapidapi.com"
}
]
},
"options": {}
},
"id": "3b69f7a0-4679-4981-9ceb-fa007bdb2886",
"name": "Redfin Get Prop ID",
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.1,
"position": [
-580,
100
]
},
{
"parameters": {
"url": "https://redfin-com-data.p.rapidapi.com/property/detail",
"sendQuery": true,
"queryParameters": {
"parameters": [
{
"name": "url",
"value": "={{ $json.payload.exactMatch.urlV2 }}"
}
]
},
"sendHeaders": true,
"headerParameters": {
"parameters": [
{
"name": "X-RapidAPI-Key",
"value": "XX"
},
{
"name": "X-RapidAPI-Host",
"value": "redfin-com-data.p.rapidapi.com"
}
]
},
"options": {
"response": {
"response": {
"fullResponse": true,
"responseFormat": "json"
}
}
}
},
"id": "97945c13-855a-4de4-9426-eefe4ee0abf0",
"name": "Redfin Get Main Info",
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.1,
"position": [
-360,
100
]
},
{
"parameters": {
"fields": {
"values": [
{
"name": "DOM",
"stringValue": "={{ $json.body.data.aboveTheFold.addressSectionInfo.cumulativeDaysOnMarket }}"
},
]
},
"include": "selected",
"options": {}
},
"id": "12f30abf-ad7e-4aa3-a93d-ba02c2366b40",
"name": "Redfin Main Info Fields",
"type": "n8n-nodes-base.set",
"typeVersion": 3.2,
"position": [
80,
120
]
},
{
"parameters": {
"mode": "combine",
"combinationMode": "mergeByPosition",
"options": {}
},
"id": "5ba7e9f1-4720-4e1b-b3bc-847af7704edf",
"name": "Merge",
"type": "n8n-nodes-base.merge",
"typeVersion": 2.1,
"position": [
320,
-120
]
},
{
"parameters": {
"mode": "combine",
"combinationMode": "mergeByPosition",
"options": {}
},
"id": "820a699d-33e1-4e55-8cc2-c7a0a64c87f6",
"name": "Merge1",
"type": "n8n-nodes-base.merge",
"typeVersion": 2.1,
"position": [
520,
-680
]
},
{
"parameters": {
"mode": "combine",
"combinationMode": "mergeByPosition",
"options": {}
},
"id": "e81675c0-7225-4f57-a9b3-da3229630ea1",
"name": "Merge2",
"type": "n8n-nodes-base.merge",
"typeVersion": 2.1,
"position": [
540,
40
]
},
{
"parameters": {
"aggregate": "aggregateAllItemData",
"options": {}
},
"id": "b35a6af4-d776-425d-a02f-a25e7cf6aaf2",
"name": "Aggregate1",
"type": "n8n-nodes-base.aggregate",
"typeVersion": 1,
"position": [
880,
-340
]
},
{
"parameters": {
"url": "https://zillow-com1.p.rapidapi.com/locationSuggestions",
"sendQuery": true,
"queryParameters": {
"parameters": [
{
"name": "q",
"value": "={{ $('Webhook').item.json.query.street }} {{ $('Webhook').item.json.query.city }} {{ $('Webhook').item.json.query.state }} {{ $('Webhook').item.json.query.zip }}"
}
]
},
"sendHeaders": true,
"headerParameters": {
"parameters": [
{
"name": "X-RapidAPI-Key",
"value": "XX"
},
{
"name": "X-RapidAPI-Host",
"value": "zillow-com1.p.rapidapi.com"
}
]
},
"options": {
"response": {
"response": {
"fullResponse": true,
"responseFormat": "json"
}
}
}
},
"id": "79f1f14e-21b4-454c-b7f1-80945bf3b4b1",
"name": "Get ZPID",
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.1,
"position": [
-740,
-680
],
"executeOnce": true
},
{
"parameters": {
"fields": {
"values": [
{
"name": "Realtor_Since",
"stringValue": "={{ $json.about.yearsExperience }}"
},
]
},
"include": "selected",
"options": {}
},
"id": "4d047964-0a73-472b-8f66-bfa56391b1f9",
"name": "Edit Fields2",
"type": "n8n-nodes-base.set",
"typeVersion": 3.2,
"position": [
80,
-200
]
},
{
"parameters": {
"method": "POST",
"url": "=https://www.zohoapis.com/crm/v6/Property/{{ $('Aggregate1').item.json.data[0].id }}/photo",
"authentication": "predefinedCredentialType",
"nodeCredentialType": "zohoOAuth2Api",
"sendBody": true,
"contentType": "multipart-form-data",
"bodyParameters": {
"parameters": [
{
"parameterType": "formBinaryData",
"name": "file",
"inputDataFieldName": "file"
}
]
},
"options": {
"response": {
"response": {
"fullResponse": true,
"responseFormat": "json"
}
}
}
},
"id": "83d46ab9-eda4-4d2e-b251-3e4149ac4cdc",
"name": "HTTP Request",
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.1,
"position": [
1420,
-340
],
"credentials": {
"zohoOAuth2Api": {
"id": "6WcZrYGR3bVX34Ft",
"name": "Zoho account"
}
}
},
{
"parameters": {
"url": "https://zillow-com1.p.rapidapi.com/property",
"sendQuery": true,
"queryParameters": {
"parameters": [
{
"name": "zpid",
"value": "={{ $json.ZPID }}"
}
]
},
"sendHeaders": true,
"headerParameters": {
"parameters": [
{
"name": "X-RapidAPI-Key",
"value": "XX"
},
{
"name": "X-RapidAPI-Host",
"value": "zillow-com1.p.rapidapi.com"
}
]
},
"options": {
"response": {
"response": {
"fullResponse": true
}
}
}
},
"id": "a551acb4-28b3-412f-8035-b6d78a7c15e1",
"name": "Get All Zillow Details",
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.1,
"position": [
-460,
-680
]
},
{
"parameters": {
"mode": "combine",
"combinationMode": "mergeByPosition",
"options": {}
},
"id": "88ba94d5-5699-4c88-a203-7694b65ec08e",
"name": "Merge5",
"type": "n8n-nodes-base.merge",
"typeVersion": 2.1,
"position": [
320,
-460
]
},
{
"parameters": {
"mode": "combine",
"combinationMode": "mergeByPosition",
"options": {}
},
"id": "ce7b687c-5411-44d7-a4fd-bea13b16ce9d",
"name": "Merge3",
"type": "n8n-nodes-base.merge",
"typeVersion": 2.1,
"position": [
300,
-780
]
},
{
"parameters": {
"mode": "combine",
"combinationMode": "mergeByPosition",
"options": {}
},
"id": "a08f19ed-aefa-478f-a51b-55994a67c247",
"name": "Merge4",
"type": "n8n-nodes-base.merge",
"typeVersion": 2.1,
"position": [
320,
180
]
},
{
"parameters": {
"fields": {
"values": [
{
"name": "Last_Updated",
"stringValue": "={{ $json.Last_Updated }}"
}
]
},
"options": {}
},
"id": "6e9ea037-6810-4905-ba27-8d8e8f774164",
"name": "Edit Fields4",
"type": "n8n-nodes-base.set",
"typeVersion": 3.2,
"position": [
80,
-860
]
},
{
"parameters": {
"operation": "formatDate",
"date": "={{ $json.body.attributionInfo.lastUpdated }}",
"format": "custom",
"customFormat": "yyyy-MM-dd'T'HH:mm:ss",
"outputFieldName": "Last_Updated",
"options": {}
},
"id": "9358c4d9-04fc-4bdc-8ea4-0caed2539d21",
"name": "Last Updated",
"type": "n8n-nodes-base.dateTime",
"typeVersion": 2,
"position": [
-160,
-860
]
},
{
"parameters": {
"url": "={{ $('Aggregate1').item.json.data[0].propimg01 }}",
"options": {
"response": {
"response": {
"responseFormat": "file",
"outputPropertyName": "file"
}
}
}
},
"id": "9a7aa232-1d4a-4695-9109-568e9c39c86e",
"name": "HTTP Request4",
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.1,
"position": [
1240,
-340
]
},
{
"parameters": {
"fields": {
"values": [
{
"name": "ZillowComp01",
"stringValue": "=https://www.zillow.com{{ $json.comps[0].hdpUrl }}"
},
]
},
"include": "selected",
"options": {}
},
"id": "2d7bed70-605a-4752-b38c-3d14f06ab6a4",
"name": "Edit Fields5",
"type": "n8n-nodes-base.set",
"typeVersion": 3.2,
"position": [
80,
-380
]
},
{
"parameters": {
"mode": "combine",
"combinationMode": "mergeByPosition",
"options": {}
},
"id": "03a0c947-b197-494d-8fb0-005d44d5ef05",
"name": "Merge6",
"type": "n8n-nodes-base.merge",
"typeVersion": 2.1,
"position": [
720,
-340
]
},
{
"parameters": {
"fields": {
"values": [
{
"name": "Status",
"stringValue": "={{ $json.body.homeStatus }}, {{ $json.body.contingentListingType }}"
},
]
},
"include": "selected",
"options": {}
},
"id": "6998cbe4-5549-4e83-afef-170dd5cb376a",
"name": "Edit Fields6",
"type": "n8n-nodes-base.set",
"typeVersion": 3.2,
"position": [
80,
-700
]
},
{
"parameters": {
"url": "https://zillow-com1.p.rapidapi.com/propertyComps",
"sendQuery": true,
"queryParameters": {
"parameters": [
{
"name": "zpid",
"value": "={{ $json.body.zpid }}"
}
]
},
"sendHeaders": true,
"headerParameters": {
"parameters": [
{
"name": "X-RapidAPI-Key",
"value": "XX"
},
{
"name": "X-RapidAPI-Host",
"value": "zillow-com1.p.rapidapi.com"
}
]
},
"options": {}
},
"id": "c3f431e7-c88e-4232-9c36-f3e26c1ead85",
"name": "Get Zillow Comps",
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.1,
"position": [
-460,
-500
]
},
{
"parameters": {
"fields": {
"values": [
{
"name": "ZPID",
"stringValue": "={{ $json.body.results[0].metaData.zpid }}"
}
]
},
"include": "selected",
"options": {}
},
"id": "3cd24271-a3ee-4cad-a668-1d015356c490",
"name": "Edit Fields7",
"type": "n8n-nodes-base.set",
"typeVersion": 3.2,
"position": [
-600,
-680
]
},
{
"parameters": {
"fields": {
"values": [
{
"name": "zpid",
"stringValue": "={{ $json.body.zpid }}"
},
]
},
"include": "selected",
"options": {
"ignoreConversionErrors": true
}
},
"id": "15ef61ae-c880-4e85-8992-ef73f12c2a16",
"name": "Edit Fields3",
"type": "n8n-nodes-base.set",
"typeVersion": 3.2,
"position": [
80,
-540
]
},
{
"parameters": {
"url": "https://zillow-com1.p.rapidapi.com/images",
"sendQuery": true,
"queryParameters": {
"parameters": [
{
"name": "zpid",
"value": "={{ $('Get All Zillow Details').first().json.body.zpid }}"
}
]
},
"sendHeaders": true,
"headerParameters": {
"parameters": [
{
"name": "X-RapidAPI-Key",
"value": "XX"
},
{
"name": "X-RapidAPI-Host",
"value": "zillow-com1.p.rapidapi.com"
}
]
},
"options": {}
},
"id": "e7c728c6-fc09-4ede-8d07-9db05a982d55",
"name": "Get Property Images",
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.1,
"position": [
-460,
-140
]
},
{
"parameters": {
"fields": {
"values": [
{
"name": "propimg01",
"stringValue": "={{ $json.images[0] }}"
},
]
},
"include": "selected",
"options": {}
},
"id": "b759236d-31fc-40bf-929d-da46dc3d15fa",
"name": "Edit Fields8",
"type": "n8n-nodes-base.set",
"typeVersion": 3.2,
"position": [
80,
-40
]
},
{
"parameters": {
"url": "https://realtor.p.rapidapi.com/properties/v3/detail",
"sendQuery": true,
"queryParameters": {
"parameters": [
{
"name": "property_id",
"value": "={{ $json.autocomplete[0].mpr_id }}"
}
]
},
"sendHeaders": true,
"headerParameters": {
"parameters": [
{
"name": "X-RapidAPI-Key",
"value": "XX"
},
{
"name": "X-RapidAPI-Host",
"value": "realtor.p.rapidapi.com"
}
]
},
"options": {}
},
"id": "aaf640a3-a592-4619-916d-a0676da929c4",
"name": "HTTP Request2",
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.1,
"position": [
-360,
360
]
},
{
"parameters": {
"url": "https://realtor.p.rapidapi.com/locations/v2/auto-complete",
"sendQuery": true,
"queryParameters": {
"parameters": [
{
"name": "input",
"value": "={{ $('Get All Zillow Details').item.json.body.address.streetAddress }} {{ $('Get All Zillow Details').item.json.body.address.city }} {{ $('Get All Zillow Details').item.json.body.address.state }} {{ $('Get All Zillow Details').item.json.body.address.zipcode }}"
}
]
},
"sendHeaders": true,
"headerParameters": {
"parameters": [
{
"name": "X-RapidAPI-Key",
"value": "XX"
},
{
"name": "X-RapidAPI-Host",
"value": "realtor.p.rapidapi.com"
}
]
},
"options": {}
},
"id": "d0d77c59-7f73-4053-a1a3-57fba1e11571",
"name": "HTTP Request3",
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.1,
"position": [
-580,
360
]
},
{
"parameters": {
"fields": {
"values": [
{
"name": "Collateral_Analytics",
"stringValue": "={{ $json.data.home.estimates.current_values[1].estimate }}"
},
]
},
"include": "selected",
"options": {}
},
"id": "7f95c379-0fee-4ceb-9456-a2c44e6df926",
"name": "Edit Fields9",
"type": "n8n-nodes-base.set",
"typeVersion": 3.2,
"position": [
80,
280
]
},
{
"parameters": {
"url": "https://zillow-com1.p.rapidapi.com/agentDetails",
"sendQuery": true,
"queryParameters": {
"parameters": [
{
"name": "username",
"value": "={{ $('Get All Zillow Details').item.json.body.listed_by.profile_url.slice(31,-1) }}"
}
]
},
"sendHeaders": true,
"headerParameters": {
"parameters": [
{
"name": "X-RapidAPI-Key",
"value": "XX"
},
{
"name": "X-RapidAPI-Host",
"value": "zillow-com1.p.rapidapi.com"
}
]
},
"sendBody": true,
"bodyParameters": {
"parameters": [
{}
]
},
"options": {}
},
"id": "fcd638c8-3c1f-4b2a-aff2-e0df5915eb32",
"name": "get agent details",
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.1,
"position": [
-460,
-320
],
"alwaysOutputData": true,
"onError": "continueRegularOutput"
},
{
"parameters": {},
"id": "1f8891c3-b207-463f-b201-0ac7a3b62e99",
"name": "DONE",
"type": "n8n-nodes-base.noOp",
"typeVersion": 1,
"position": [
1580,
-340
]
}
],
"connections": {
"Add Property CRM": {
"main": [
[
{
"node": "HTTP Request4",
"type": "main",
"index": 0
}
]
]
},
"Webhook": {
"main": [
[
{
"node": "Get ZPID",
"type": "main",
"index": 0
}
]
]
},
"Redfin Get Prop ID": {
"main": [
[
{
"node": "Redfin Get Main Info",
"type": "main",
"index": 0
}
]
]
},
"Redfin Get Main Info": {
"main": [
[
{
"node": "Redfin Main Info Fields",
"type": "main",
"index": 0
},
{
"node": "HTTP Request3",
"type": "main",
"index": 0
}
]
]
},
"Redfin Main Info Fields": {
"main": [
[
{
"node": "Merge4",
"type": "main",
"index": 0
}
]
]
},
"Merge": {
"main": [
[
{
"node": "Merge2",
"type": "main",
"index": 0
}
]
]
},
"Merge1": {
"main": [
[
{
"node": "Merge6",
"type": "main",
"index": 0
}
]
]
},
"Merge2": {
"main": [
[
{
"node": "Merge6",
"type": "main",
"index": 1
}
]
]
},
"Aggregate1": {
"main": [
[
{
"node": "Add Property CRM",
"type": "main",
"index": 0
}
]
]
},
"Get ZPID": {
"main": [
[
{
"node": "Edit Fields7",
"type": "main",
"index": 0
}
]
]
},
"Edit Fields2": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 0
}
]
]
},
"HTTP Request": {
"main": [
[
{
"node": "DONE",
"type": "main",
"index": 0
}
]
]
},
"Get All Zillow Details": {
"main": [
[
{
"node": "Get Zillow Comps",
"type": "main",
"index": 0
}
]
]
},
"Merge5": {
"main": [
[
{
"node": "Merge1",
"type": "main",
"index": 1
}
]
]
},
"Merge3": {
"main": [
[
{
"node": "Merge1",
"type": "main",
"index": 0
}
]
]
},
"Merge4": {
"main": [
[
{
"node": "Merge2",
"type": "main",
"index": 1
}
]
]
},
"Edit Fields4": {
"main": [
[
{
"node": "Merge3",
"type": "main",
"index": 0
}
]
]
},
"Last Updated": {
"main": [
[
{
"node": "Edit Fields4",
"type": "main",
"index": 0
}
]
]
},
"HTTP Request4": {
"main": [
[
{
"node": "HTTP Request",
"type": "main",
"index": 0
}
]
]
},
"Edit Fields5": {
"main": [
[
{
"node": "Merge5",
"type": "main",
"index": 1
}
]
]
},
"Merge6": {
"main": [
[
{
"node": "Aggregate1",
"type": "main",
"index": 0
}
]
]
},
"Edit Fields6": {
"main": [
[
{
"node": "Merge3",
"type": "main",
"index": 1
}
]
]
},
"Get Zillow Comps": {
"main": [
[
{
"node": "get agent details",
"type": "main",
"index": 0
},
{
"node": "Edit Fields5",
"type": "main",
"index": 0
}
]
]
},
"Edit Fields7": {
"main": [
[
{
"node": "Get All Zillow Details",
"type": "main",
"index": 0
}
]
]
},
"Edit Fields3": {
"main": [
[
{
"node": "Merge5",
"type": "main",
"index": 0
}
]
]
},
"Get Property Images": {
"main": [
[
{
"node": "Edit Fields8",
"type": "main",
"index": 0
},
{
"node": "Redfin Get Prop ID",
"type": "main",
"index": 0
}
]
]
},
"Edit Fields8": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 1
}
]
]
},
"HTTP Request2": {
"main": [
[
{
"node": "Edit Fields9",
"type": "main",
"index": 0
}
]
]
},
"HTTP Request3": {
"main": [
[
{
"node": "HTTP Request2",
"type": "main",
"index": 0
}
]
]
},
"Edit Fields9": {
"main": [
[
{
"node": "Merge4",
"type": "main",
"index": 1
}
]
]
},
"get agent details": {
"main": [
[
{
"node": "Edit Fields2",
"type": "main",
"index": 0
},
{
"node": "Get Property Images",
"type": "main",
"index": 0
}
]
]
}
},
"pinData": {}
}