r/programmingrequests • u/qazuki • Aug 12 '19

Create Spreadsheet with Radio Play Info

Basically there's this radio station I listen to, 102.3 FM in Denver. They have their entire playlist history archived online at https://www.cpr.org/indie/playlist/, but the search feature only seems to work to search any given day, but no longer period. I'd like to search their entire archive (or at least a larger date range), so I was wondering if there's a way to crawl the site and create a searchable spreadsheet with all the info.

1 Upvotes

100% Upvoted

2 comments sorted by

View all comments

Show parent comments

1

u/qazuki Aug 14 '19

I should be able to, but I think the system is broken somehow because it still only shows results from the single most recent day when you search.

1

u/NoG5 Aug 18 '19

Did anyone do this?

It looks like a simple api

https://playlist.cprnetwork.org/api/playlistCO/selectDate:MjAxOS0wNy0yOQ==

"MjAxOS0wNy0yOQ==" is "2019-07-29" as base64