I am trying to edit my dataset with more than 10,000 submissions. One of my questions ask a name of country and the responses are different for countries like the US. For instance, I have ‘US’, ‘us’, ‘U.S’, ‘The US’, ‘United States’, ‘The United States of America’…
Is there a way to fix this without having to edit each submission manually? Can we do it through a Python , SQL scripts , or API?
I have multiple forms with ~10,000 submissions each. I was wondering if there is another way to access the data and make bulk editing.
It seems like REST API is the (may be?) only way to do it, but that would require my scripts to 1) identify the uuid of the submissions I want to edit OR 2) delete everything, fix the issue and re-upload all of the them back.