Creative Ideas for Pulling Building Permit Data into Clay Table

Hi Clay team! I'm working on a new project, and I'm wondering if you have any creative ideas. I'm trying to figure out if I can search for records in a public database of building permits and pull the information into a Clay table (preferably scheduled, not just one time). Here's the DB: https://aca-prod.accela.com/ATLANTA_GA/Default.aspx Here's an example of the output of a search result with the structured data: https://aca-prod.accela.com/ATLANTA_GA/Cap/CapDetail.aspx?Module=Building&TabName=Buil[…]0000&capID3=006QR&agencyCode=ATLANTA_GA&IsToShowInspection= Any ideas? 🙂

Channeled
APP
·
·
While we don't have a direct integration with the specific database you mentioned, we can suggest a potential approach using our existing features: 1. Use our Google Search functionality to find and scrape the building permit database website. 2. Set up a scheduled action in Clay to regularly perform this search and retrieve the data. 3. Use Clay's data processing capabilities to extract the relevant information from the search results. 4. Write the extracted data to your Clay table using our "write to table" feature. This approach would allow you to regularly update your Clay table with the latest building permit information from the public database. What specific information from the building permits are you most interested in capturing?
Sources: Pull Records from Airtable with Airtable Claybooks: Perform Google searches and find web pages that mention specific keywords | Clay.com
LuisArturo
·
·
Hey there Andrew thanks for reaching out, this might be a harder to do inside of Clay at the moment. The approach I would recommend here would be to use Claygent to search this database. However Claygent does struggle to search in databases that require inputs such as these to find data.
Andrew T.
·
·
Got it. Thank you!
Channeled
APP
·
·