Hi @Kal_Lam we observed more of the issue, and found what is actually happening, and how we can replicate the issue -
-
Lets say there are two submissions on any form -
-
Excel exported using the Kobo Rest API - https://{kobo_domain}/api/v1/data/31.xls (31 is the form Id)
-
When the excel is exported there is an entry created in the âExcel Exportsâ which can be seen in the âLegacy Projectâ view
-
We deleted one of the submission -
-
We tried exporting again using the Kobo REST api - https://{kobo_domain}/api/v1/data/31.xls
Here we found that the data in the newly exported excel file is still the same, it did not change
-
We also noted that there was no new entry created in the excel export in the Legacy Project page -
Due to this, we are still getting the stale data, no new excel file gets added here, and every time we export the data using REST excel, we get the same stale data.
We also found when we delete the existing excel in the âExcel Export in the Legacy Projectâ page, the new export works properly.
We also found that this issue exists only when the submission is deleted, if the submissions are added, or updated the newly exported excel actually contains the updated data.
These were how the issue was replicatedâŚ
Just wanted to know if we are missing anything here? Thanks!
Any Help would always be appreciated.