I also use https://kc.humanitarianresponse.info/api/v1/data?format=csv to get all my file url and then connect to power query to download my file in excel. However I have deployed 2 forms. Whenever I delete a submission in the 2nd form it does not delete when I refresh the excel file.
Any explanation to this? I have checked my settings and everything seems fine.
Welcome to the community, @nepctahni360! Have you tried connecting your server through this link as shared previously?
Wow I just did and its amazing and solved everything.
I am really happy now and thanks for your help.