Hi there, I have some spreadsheets that automatically download data from Kobo whenever the API Connector browser extension is refreshed. One has stopped working even though nothing changed in the spreadsheet or the form on Kobo. I looked up the csv url in assets (api V2) and copied and pasted it again into the spreadsheet but the cell just produces ‘#N/A’.
Any ideas what could be wrong?
Many thanks
Gemma
@childrenontheedge, maybe you will need to go through this support article Connecting to your data using synchronous exports again.
Thanks very much - it’s now working again! 
@Kal_Lam It has now stopped working again! The way I got it working before was to try the xls url, which didn’t work, then put the csv one back in, this showed an error that there wasn’t space for the data so I moved a column of formulae and then it worked.
Since it has stopped working again, I tried the same thing, then went through all the troubleshooting, then resorted to ChatGPT and ended up working on Google Apps Script Editor. Still no joy. I just went back to the Google sheet and instead of =IMPORTDATA, I tried the suggested =IMPORTAPI. When I added the csv url it came back with Error: Request https://eu.kobotoolbox.org/api/v2/assets/a7MMq43mCRftarD2L4L7L2/export-settings/esbgR8Nx4tLjgSRRLFckdJE/data.csv doesn’t exist!
I have checked it so many times on eu.kobotoolbox.org/ api/v2/assets/.
Any ideas anyone?
