Excel power query showing the deleted submission

Hello,
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?

Dear Kal_Lam,

Wow I just did and its amazing and solved everything.

I am really happy now and thanks for your help.

God bless,

Jonah

1 Like