Getting data from RapidAPI using the HTTP module

I am using the HTTP module to Get Zillow Data. My connection works fine and the JSON looks like the below:
{
“body”: {
“props”: [
{
“city”: “Spring”,
“zpid”: 97606515,
“price”: 1925,
“state”: “TX”,
“country”: “USA”,
“zipcode”: “77388”,
“bedrooms”: 3,
“currency”: “USD”,
“homeType”: “SINGLE_FAMILY”,
“latitude”: 30.07531,
“bathrooms”: 2,
“longitude”: -95.4773,
“zestimate”: 235000,
“homeStatus”: “FOR_RENT”,
“isFeatured”: true,
“livingArea”: 1300,
“priceForHDP”: 1925,
“daysOnZillow”: 0,
“isUnmappable”: false,
“timeOnZillow”: 2585372000,
“variableData”: null,
“isZillowOwned”: false,
“rentZestimate”: 1799,
“streetAddress”: “3910 Falvel Cove Dr”,
“shouldHighlight”: false,
“homeStatusForHDP”: “FOR_RENT”,
“isPremierBuilder”: false,
“listing_sub_type”: {},
“taxAssessedValue”: 240774,
“isShowcaseListing”: false,
“isNonOwnerOccupied”: true,
“isRentalWithBasePrice”: false,
“isPreforeclosureAuction”: false
},
{
“city”: “Houston”,
“zpid”: 2062656098,
“price”: 2250,
“state”: “TX”,
“country”: “USA”,
“zipcode”: “77073”,
“bedrooms”: 3,
“currency”: “USD”,
“homeType”: “SINGLE_FAMILY”,
“latitude”: 30.013647,
“bathrooms”: 2,
“longitude”: -95.41413,
“zestimate”: 248600,
“homeStatus”: “FOR_RENT”,
“isFeatured”: true,
“livingArea”: 1311,
“priceForHDP”: 2250,
“daysOnZillow”: 0,
“isUnmappable”: false,
“timeOnZillow”: 242242000,
“variableData”: null,
“isZillowOwned”: false,
“rentZestimate”: 1534,
“streetAddress”: “22102 Sovereign Heights Ln”,
“shouldHighlight”: false,
“homeStatusForHDP”: “FOR_RENT”,
“isPremierBuilder”: false,
“listing_sub_type”: {},
“isShowcaseListing”: false,
“isNonOwnerOccupied”: true,
“isRentalWithBasePrice”: false,
“isPreforeclosureAuction”: false
},
{
“city”: “Houston”,
“zpid”: 28134561,
“price”: 2191,
“state”: “TX”,
“country”: “USA”,
“zipcode”: “77040”,
“bedrooms”: 4,
“currency”: “USD”,
“homeType”: “SINGLE_FAMILY”,
“latitude”: 29.873638,
“bathrooms”: 2,
“longitude”: -95.49385,
“zestimate”: 266900,
“homeStatus”: “FOR_RENT”,
“isFeatured”: true,
“livingArea”: 1977,
“priceChange”: -9,
“priceForHDP”: 2191,
“daysOnZillow”: 0,
“isUnmappable”: false,
“timeOnZillow”: 1212090000,
“variableData”: null,
“isZillowOwned”: false,
“rentZestimate”: 1999,
“streetAddress”: “7014 Woodfern Dr”,
“priceReduction”: “$9 (Jun 12)”,
“shouldHighlight”: false,
“datePriceChanged”: 1718175600000,
“homeStatusForHDP”: “FOR_RENT”,
“isPremierBuilder”: false,
“listing_sub_type”: {},
“taxAssessedValue”: 222629,
“isShowcaseListing”: false,
“isNonOwnerOccupied”: true,
“isRentalWithBasePrice”: false,
“isPreforeclosureAuction”: false
},
}

The above has been cropped because there are 40 props that are returned. I am trying to take the props zpid, city and address and place them in a Google Sheet row. Any suggestions?

Hi @berniecpa,

Welcome to the community! Try the Loop piece, this should fix the issue you have. You can loop each response and insert rows within the loop to Google sheets.

I am currently on Mobile, otherwise I would have send you some screenshots. Let me know the outcome!

Kr Bram

@Bram Thanks for the response. I tried with the loop but am not sure how to address the value aspect. Here is what I have:




I guess the thing i am trying to figure out is how to loop through the props and only access props:city etc. without only accessing a single prop.

Hi @berniecpa,

U are almost there. Get into the Google Sheet piece, and instead of mapping the data from the HTTP piece, map the data from the Loop on items piece.

Please see also this post as reference, Understanding of loops

Let me know if this worked.

KR Bram

That is what I was looking for.

It works and I have a better understanding.

Thanks.

Happy to hear! Good luck, and feel free to reach out in case of any questions