I would like to know how this can be done in order not to have to choose every category each time, so I just plug the API and code in R, and it downloads automatically.
For querying the API from R you can use the httr2 package, for exporting data to excel there are many package options, one example is openxlsx, and for scheduling an R script you can use taskscheduleR or cronR depending on your Operating System.
Hi Andres,
Thank your for your response. I am very new to R so I am kinda in a black tunnel with this task. Trying to get the: commo_to_items = {
"SOYBEANS": ["SOYBEANS - YIELD, MEASURED IN BU / ACRE", "SOYBEANS - ACRES PLANTED", "SOYBEANS - ACRES HARVESTED", "SOYBEANS - PRODUCTION, MEASURED IN BU"],
}