Program that converts data from data.oaklandca.gov into a CSV spreadsheet. User enters a filename and then the link to the API that they would use and the script will produce a CSV sheet under the specified name containing the data of the API.
IMPORTANT Please remember to pull API from https://data.oaklandca.gov/browse
The particular data sheets I used for this pertained to campaign finance spending for the November 2020 Election Cycle. They are linked below by name.
Itemized Cash contributions https://data.oaklandca.gov/dataset/Campaign-Finance-FPPC-Form-460-Schedule-A-Monetary/3xq4-ermg
In-kind contributions https://data.oaklandca.gov/dataset/Campaign-Finance-FPPC-Form-460-Schedule-C-Non-Mone/ba44-jqtm
Late contributions https://data.oaklandca.gov/dataset/Campaign-Finance-FPPC-Form-497-Late-Contribution-R/qact-u8hq
Summary Totals (Balance Sheet) https://data.oaklandca.gov/dataset/Campaign-Finance-FPPC-Form-460-Summary-Totals/rsxe-vvuw
Go to the right hand size of the sheet and click API. Copy the JSON file that is produced by clicking copy and paste into the terminal when prompted.
These 4 datasets are from FFPC form 460 which I was authorized to use by Suzanne Doran of Public Ethics Comission for the City of Oakland.