I can't fetch data from Zoho Reports table

I can't fetch data from Zoho Reports table

Hi there,

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("-|-"));

Is there a new version of the code or is that a known bug?

Thanks,