Use Fenix API for getFAO
I recently tried to use the old FAOSTAT API with about as success as you'd expect. I then tried the bulk download but realised that the two seem to be uploaded separately, i.e. the data in the bulk download may not match what is downloaded from FAOSTAT. You can see an example of this in the bulk download for Food Balance Sheets (2010-) where certain elements are missing.
Is there a reason that the FENIX API (https://fenixservices.fao.org/faostat/api/v1
) can't be used? I can't find documentation for it but it's quite transparent and I've successfully pulled data from it in R using httr
.