[sailplease]

If anyone is interested I setup the bills and committee endpoints in a google sheet, makes it easy to get the data in one spot, manage pagination, etc.. You can simply copy the spreadsheet and it will copy the api connectors, just enter your api key, you can easily add other endpoints, change query params, etc.

Pagination seems to be limited to 250 on the endpoints and some of the data sets are quite large so I set a limit on pagination of 10 pages, if you want all the bills from all time, prepare to wait.

Full disclosure it uses a free addon myself and my cofounders created to easily push any api data into a google sheet. I just find it useful to play around in a spreadsheet very quickly vs setting up a db.

spreadsheet is here: https://docs.google.com/spreadsheets/d/1amnbqb_J9W2r-XaVsrue...