I sent a ticket to Zoho creator support but didn't get an answer as yet, so trying my luck here.
Since yesterday all the forms in my application have stopped fetching data from Zoho reports to Zoho creator dropdowns:
//QUERY FOR Usernames
query = "select DISTINCT Username from Usernames where Status='Active' ORDER BY Username;";
url = "http://reports.zoho.com/api/<username>/<database>/Usernames?ZOHO_ACTION=EXPORT&ZOHO_OUTPUT_FORMAT=JSON&ZOHO_ERROR_FORMAT=XML&authtoken=<authtoken>&scope=reportsapi&EMAIL_ID=[emailaddress]&PASSWORD=[password]" + "&ZOHO_API_VERSION=1.0&ZOHO_SQLQUERY=" + query;
response = getUrl(url);
result = response.executeXPath("/root/response/result/rows/text()");
Username:ui.add(result.toList("-|-"));