After my tour of the 24 record stores in Brooklyn taking pics, I wanted to make an app. So, I’ve started to build - https://recordstoresnyc.glideapp.io - and I’m pretty happy about it!
But now I want to complicate things (obviously) and add information coming from Discogs profile for those stores who have it.
So far, for now, I made it retrieve the first page of listings from a profile page with =IMPORTHTML(“https://www.discogs.com/seller/FaceRecordsNYC/profile”, “table”,3)
But now I’m facing some issues and questions:
- how can I retrieve the image, name, and price of the records? At the moment with =importhtml I’m importing a field with more generic info that I don’t need. So, for the image, I’m trying with the below, with no luck
- can I make pagination to retrieve all pages of a profie to get all their records?
Basically, what I need is: If the record store has a Discogs account, I want to display the list of records with image and price, scraping their Discogs page.
Sounds easy! But not enough for me — any help would be highly appreciated!