Hi @Josh I have tried deleting data directly from Excel - once I do that, and I press refresh, it doesn’t appear again. However, once I fill in a new form and try to retrieve new data onto my spreadsheet, data does not appear - I would need to undo that column deletion before new data appears. I did try something new: when attempting to add in the link to web from excel, I would include the URL without “.xls” (therefore looking like this: “https://kc.humanitarianresponse.info/api/v1/data/680427” instead of "“https://kc.humanitarianresponse.info/api/v1/data/680427.xls”) and that helped in retrieving only available data (therefore deleted data did not appear). Yet, the problem now is that what appears on my PowerQuery is data only and questions that were in the form of notes do not download (since there no data points to be collected). While I’m happy that only new data is downloaded, I would have still preferred to download the note fields.
1 Like
