DanaHauser
3 years agoQrew Cadet
Get JSON from previous step in Pipeline for 2nd API call to external source
Hi, I'm looking for some help with a pipeline. I've created step A which sends an api call for a MLS property search. This first step I used the Make a Request function under webhooks. It gets an access token and runs a property search, which comes back with the following results at the end of this post.
The only data I need from the results is the corelogicPropertyId, which I need for step B in order to get the property data back using this ID. The URL I need to make the B call is https://property.corelogicapi.com/v2/properties/<clip>/ownership
<clip> is where I need to insert the corelogicProperyId into the URL for step B. How do I pull this # to step B? I'm kind of stuck at this point, any help would be very appreciated.
Thanks!
Step A results:
{
The only data I need from the results is the corelogicPropertyId, which I need for step B in order to get the property data back using this ID. The URL I need to make the B call is https://property.corelogicapi.com/v2/properties/<clip>/ownership
<clip> is where I need to insert the corelogicProperyId into the URL for step B. How do I pull this # to step B? I'm kind of stuck at this point, any help would be very appreciated.
Thanks!
Step A results:
{
"pageNumber": 1,
"pageSize": 1,
"totalRecords": 1,
"totalPages": 1,
"data": [
{
"corelogicPropertyId": "48243:74130542",
"compositePropertyId": "48243:74130542",
"fipsCode": "48243",
"apn": "H150-000-00P00070",
"latitude": 30.6703,
"longitude": -103.9664,
"universalParcelId": "74130542",
"parcelNumber": "H15000000P00070",
"parcelSequence": "1",
"houseNumber": null,
"houseNumber2": null,
"preDirection": "W",
"streetName": "WALNUT AVENUE OR 408",
"streetSuffix": null,
"postDirection": null,
"unitNumber": null,
"houseNumberSuffix": null,
"city": "FORT DAVIS",
"county": "JEFF DAVIS",
"zipcode": "79734",
"zip4": null,
"state": "TX",
"carrierRoute": null,
"streetAddress": "W WALNUT AVENUE OR 408",
"links": [
{
"rel": "self",
"href": "https://clp-api-property-gcpprd-ext-prd.apps.pci.pcfusw1prd.solutions.corelogic.com/property/48243:74130542",
"hreflang": null,
"media": null,
"title": null,
"type": "application/vnd.corelogic.v1+json",
"deprecation": null
},
{
"rel": "ownership",
"href": "https://clp-api-property-gcpprd-ext-prd.apps.pci.pcfusw1prd.solutions.corelogic.com/property/48243:74130542/ownership",
"hreflang": null,
"media": null,
"title": null,
"type": "application/vnd.corelogic.v1+json",
"deprecation": null
},
{
"rel": "building",
"href": "https://clp-api-property-gcpprd-ext-prd.apps.pci.pcfusw1prd.solutions.corelogic.com/property/48243:74130542/building",
"hreflang": null,
"media": null,
"title": null,
"type": "application/vnd.corelogic.v1+json",
"deprecation": null
},
{
"rel": "foreclosure",
"href": "https://clp-api-property-gcpprd-ext-prd.apps.pci.pcfusw1prd.solutions.corelogic.com/property/48243:74130542/foreclosure",
"hreflang": null,
"media": null,
"title": null,
"type": "application/vnd.corelogic.v1+json",
"deprecation": null
},
{
"rel": "tax-assessment",
"href": "https://clp-api-property-gcpprd-ext-prd.apps.pci.pcfusw1prd.solutions.corelogic.com/property/48243:74130542/tax-assessment",
"hreflang": null,
"media": null,
"title": null,
"type": "application/vnd.corelogic.v1+json",
"deprecation": null
},
{
"rel": "VP4",
"href": "https://clp-api-property-gcpprd-ext-prd.apps.pci.pcfusw1prd.solutions.corelogic.com/property/48243:74130542/avm/rave/VP4",
"hreflang": null,
"media": null,
"title": null,
"type": "application/vnd.corelogic.v1+json",
"deprecation": null
},
{
"rel": "PASS",
"href": "https://clp-api-property-gcpprd-ext-prd.apps.pci.pcfusw1prd.solutions.corelogic.com/property/48243:74130542/avm/rave/PASS",
"hreflang": null,
"media": null,
"title": null,
"type": "application/vnd.corelogic.v1+json",
"deprecation": null
},
{
"rel": "GeoAVMCore",
"href": "https://clp-api-property-gcpprd-ext-prd.apps.pci.pcfusw1prd.solutions.corelogic.com/property/48243:74130542/avm/rave/GeoAVMCore",
"hreflang": null,
"media": null,
"title": null,
"type": "application/vnd.corelogic.v1+json",
"deprecation": null
},
{
"rel": "GeoAVMPrecision",
"href": "https://clp-api-property-gcpprd-ext-prd.apps.pci.pcfusw1prd.solutions.corelogic.com/property/48243:74130542/avm/rave/GeoAVMPrecision",
"hreflang": null,
"media": null,
"title": null,
"type": "application/vnd.corelogic.v1+json",
"deprecation": null
},
{
"rel": "Prospector",
"href": "https://clp-api-property-gcpprd-ext-prd.apps.pci.pcfusw1prd.solutions.corelogic.com/property/48243:74130542/avm/rave/Prospector",
"hreflang": null,
"media": null,
"title": null,
"type": "application/vnd.corelogic.v1+json",
"deprecation": null
},
{
"rel": "sales-history",
"href": "https://clp-api-property-gcpprd-ext-prd.apps.pci.pcfusw1prd.solutions.corelogic.com/property/48243:74130542/sales-history",
"hreflang": null,
"media": null,
"title": null,
"type": "application/vnd.corelogic.v1+json",
"deprecation": null
},
{
"rel": "finance-history",
"href": "https://clp-api-property-gcpprd-ext-prd.apps.pci.pcfusw1prd.solutions.corelogic.com/property/48243:74130542/finance-history",
"hreflang": null,
"media": null,
"title": null,
"type": "application/vnd.corelogic.v1+json",
"deprecation": null
},
{
"rel": "site",
"href": "https://clp-api-property-gcpprd-ext-prd.apps.pci.pcfusw1prd.solutions.corelogic.com/property/48243:74130542/site",
"hreflang": null,
"media": null,
"title": null,
"type": "application/vnd.corelogic.v1+json",
"deprecation": null
},
{
"rel": "summary",
"href": "https://clp-api-property-gcpprd-ext-prd.apps.pci.pcfusw1prd.solutions.corelogic.com/property/48243:74130542/summary",
"hreflang": null,
"media": null,
"title": null,
"type": "application/vnd.corelogic.v1+json",
"deprecation": null
},
{
"rel": "location",
"href": "https://clp-api-property-gcpprd-ext-prd.apps.pci.pcfusw1prd.solutions.corelogic.com/property/48243:74130542/location",
"hreflang": null,
"media": null,
"title": null,
"type": "application/vnd.corelogic.v1+json",
"deprecation": null
},
{
"rel": "comparables",
"href": "https://clp-api-property-gcpprd-ext-prd.apps.pci.pcfusw1prd.solutions.corelogic.com/property/48243:74130542/comparables",
"hreflang": null,
"media": null,
"title": null,
"type": "application/vnd.corelogic.v1+json",
"deprecation": null
},
{
"rel": "owner-transfer",
"href": "https://clp-api-property-gcpprd-ext-prd.apps.pci.pcfusw1prd.solutions.corelogic.com/property/48243:74130542/owner-transfer",
"hreflang": null,
"media": null,
"title": null,
"type": "application/vnd.corelogic.v1+json",
"deprecation": null
},
{
"rel": "last-market-sale",
"href": "https://clp-api-property-gcpprd-ext-prd.apps.pci.pcfusw1prd.solutions.corelogic.com/property/48243:74130542/last-market-sale",
"hreflang": null,
"media": null,
"title": null,
"type": "application/vnd.corelogic.v1+json",
"deprecation": null
},
{
"rel": "prior-sale",
"href": "https://clp-api-property-gcpprd-ext-prd.apps.pci.pcfusw1prd.solutions.corelogic.com/property/48243:74130542/prior-sale",
"hreflang": null,
"media": null,
"title": null,
"type": "application/vnd.corelogic.v1+json",
"deprecation": null
},
{
"rel": "current-transfer",
"href": "https://clp-api-property-gcpprd-ext-prd.apps.pci.pcfusw1prd.solutions.corelogic.com/property/48243:74130542/current-transfer",
"hreflang": null,
"media": null,
"title": null,
"type": "application/vnd.corelogic.v1+json",
"deprecation": null
},
{
"rel": "current-first-mortgage",
"href": "https://clp-api-property-gcpprd-ext-prd.apps.pci.pcfusw1prd.solutions.corelogic.com/property/48243:74130542/current-first-mortgage",
"hreflang": null,
"media": null,
"title": null,
"type": "application/vnd.corelogic.v1+json",
"deprecation": null
},
{
"rel": "legal-and-vesting",
"href": "https://clp-api-property-gcpprd-ext-prd.apps.pci.pcfusw1prd.solutions.corelogic.com/property/48243:74130542/legal-and-vesting",
"hreflang": null,
"media": null,
"title": null,
"type": "application/vnd.corelogic.v1+json",
"deprecation": null
}
]
}
],
"links": [
{
"rel": "self",
"href": "https://clp-api-property-gcpprd-ext-prd.apps.pci.pcfusw1prd.solutions.corelogic.com/property?address=%091600%20Walnut%20Avenue%20&zip5=78702&responseLimit=100&pageNumber=1&pageSize=10",
"hreflang": null,
"media": null,
"title": null,
"type": "application/vnd.corelogic.v1+json",
"deprecation": null
}
]
}
------------------------------
Dana Hauser
------------------------------