Zillow data in Airtable

Input            single line text  (Zillow link or full address)
Price            currency
Zestimate        currency
Rent Zestimate   currency
Status           single line text
Zillow URL       URL
Lookup error     single line text

const KEY = "YOUR_KEY";
const table = base.getTable("Homes");
const query = await table.selectRecordsAsync({ fields: ["Input"] });
const records = query.records.filter((r) => r.getCellValueAsString("Input").trim());

for (let i = 0; i < records.length; i += 50) {
  const chunk = records.slice(i, i + 50);
  const res = await fetch("https://api.propertiesapi.com/v1/zillow/batch", {
    method: "POST",
    headers: { "x-api-key": KEY, "content-type": "application/json" },
    body: JSON.stringify({ items: chunk.map((r) => r.getCellValueAsString("Input").trim()) }),
  });
  const body = await res.json();
  if (!res.ok) throw new Error(`${res.status} ${body.error?.code}: ${body.error?.message}`);

  const updates = body.data.map((item) => {
    const id = chunk[item.index].id;
    if (!item.ok) return { id, fields: { "Lookup error": item.error.code } };
    const d = item.data;
    return {
      id,
      fields: {
        "Price": d.price, "Zestimate": d.zestimate, "Rent Zestimate": d.rentZestimate,
        "Status": d.homeStatus, "Zillow URL": d.detailUrl, "Lookup error": null,
      },
    };
  });
  while (updates.length) await table.updateRecordsAsync(updates.splice(0, 50));
  output.text(`${i + chunk.length} of ${records.length} done, ${body.meta.credits} credits used`);
}

not_found            no matching Zillow property: check the address or paste the Zillow link
address_ambiguous    closest match is a different home: add the unit, city or ZIP, or paste the link
bad_param            the Input isn't a Zillow link or a full US address with a house number
rate_limited         too many requests a minute: run the script again shortly
upstream_busy        lookups are busy: run the script again shortly