I could really use high-level/strategic pointers on how best to achieve the following:
- Loop through an .xlsx/.csv column, appending the cell values to an API request URL
- The JSON output for each call is big and nested, so I want to identify the 5-6 relevant keys and then…
- … write the key-values back to the .xlsx/.csv, each key with its own column, each value the same row as its corresponding original value and accompanying data.
I managed step 1 using openpyxl, but am open to the possibility of starting over if csvreader or something similar could ultimately make life easier.
Thanks for any consideration! Am happy to privately share code if it helps.