Getting data from RapidAPI using the HTTP module

Need help
1

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?

2

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

3

@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:

flow
flow998×1204 89.9 KB

http
http750×686 35.2 KB

google
google768×872 82.9 KB

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.

4

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.

image
image1867×686 47.3 KB

Please see also this post as reference, Understanding of loops

Let me know if this worked.

KR Bram

5

That is what I was looking for.

It works and I have a better understanding.

Thanks.

6

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