Bounties

Post bounties and services on Farcaster by tagging me. Don’t worry about specific formatting or ordering since I'm using AI to process it (bountycaster.xyz) /bounties. FAQ: bountycaster.xyz/FAQ

Description - List the usernames of all WC users who state their location as any of following cities: Berlin, Frankfurt, Munich, Paris, Lisbon, London, Barcelona, Madrid, Amsterdam. A single .csv file with two columns (name/city) will be fine.

Amount - 100 USDC

Deadline - 8amET, July 5 2024 (in ~14 hrs)

@bountybot

If I did everything correctly, this should be the full list. I think you are able to download the .csv by going to File > Download > CSV

building /bracket | hosting /greatbooks + /gray | ex-BCG, ex-PHD | poli + phil + econ

If I did everything correctly, this should be the full list. I think you are able to download the .csv by going to File > Download > CSV 

https://docs.google.com/spreadsheets/d/1vgYTXtMwIfq_xBU-TU9E5ZNRkCFE2PgSkmVESJ0T_uk/

Thank you, glad I could help! It was a fun one because it got me curious about the string "ChIJpTvG15DL1IkRd8S0KlBVNTI" at the end of WC urls like this one https://warpcast.com/~/locations/ChIJpTvG15DL1IkRd8S0KlBVNTI which I learned is a Google Maps Place ID. I used the finder below to search for each city to get its ID, then scraped all the text from each WC location page and used AI to extract only the usernames

Thank you, glad I could help! It was a fun one because it got me curious about the string "ChIJpTvG15DL1IkRd8S0KlBVNTI" at the end of WC urls like this one https://warpcast.com/~/locations/ChIJpTvG15DL1IkRd8S0KlBVNTI which I learned is a Google Maps Place ID. I used the finder below to search for each city to get its ID, then scraped all the text from each WC location page and used AI to extract only the usernames 

https://developers.google.com/maps/documentation/places/web-service/place-id

@bountybot complete

@bountybot shoutout @ghostlinkz.eth - a job cleanly, quickly, and accurately done 🔥

Hi @ghostlinkz.eth please what API did you use to fetch the WC users location(addresses)