Creator Server Api problem
Hi,
we have an application with some forms. We try to access the data via CSV API and it works only for a few forms. The sample code is attached to this email (api key and ticket hidden)
<form method="POST" action="http://creator.zoho.com/api/csv/read/apikey=*****&ticket=*******">
<input type="hidden" name="CSVString" value="mec314,Domains,
Domain,NotEqual,aasdasd,.">
<input type="submit" value="Sumit CSV String">
</form>
This should return all the records but the web services return this:
<b></b><b></b><b></b>
The same code with the form name modified works correctly.
This is the form definition:
form Domains
{
must have Customer
(
type = picklist
values = Customers.Name
sortorder = ascending
)
Group
(
type = picklist
values = Customers[Group].Name
)
must have unique Domain
(
type = text
)
Registrar
(
type = picklist
values = Supplier.Name
)
Web_Hosting
(
displayname = "Web Hosting"
type = picklist
values = Supplier.Name
on user input
{
//You can drag and drop tasks from the immediate left pane
//Below is the SAMPLE script for dynamic, condition based field manipulation
if (count(Servers[Supplier == input.Web_Hosting]) == 0)
{
clear Web_Server;
}
else
{
servers = Servers [Supplier == input.Web_Hosting];
for each s in servers
{
Web_Server.add(s.Name);
}
}
}
)
Web_Server
(
displayname = "Web Server"
type = picklist
values = Servers.Name
on user input
{
//You can drag and drop tasks from the immediate left pane
//Below is the SAMPLE script for dynamic, condition based field manipulation
if (count(Servers[Name == input.Web_Server]) == 0)
{
clear Web_IP;
}
else
{
ip = IP_Addresses [Refer_Server == input.Web_Server];
for each i in ip
{
Web_IP.add(i.IP);
}
ip1 = Servers [Name == input.Web_Server];
for each a in ip1
{
Web_IP.add(a.IP_Address);
}
}
}
)
Web_IP
(
displayname = "Web IP"
type = picklist
values = IP_Addresses.IP
)
Mail_Hosting
(
displayname = "Mail Hosting"
type = picklist
values = Supplier.Name
on user input
{
if (count(Servers[Supplier == input.Mail_Hosting]) == 0)
{
clear Mail_Server;
}
else
{
web = Servers [Supplier == input.Mail_Hosting];
for each s in web
{
Mail_Server.add(s.Name);
}
}
}
)
Mail_Server
(
displayname = "Mail Server"
type = picklist
values = Servers.IP_Address
)
Office_Module
(
displayname = "Office Module"
type = list
values = {"Forward", "Autoresponder", "Change Password"}
)
DNS_Hosting
(
displayname = "DNS Hosting"
type = picklist
values = Supplier.Name
on user input
{
if (count(Servers[Supplier == input.DNS_Hosting]) == 0)
{
clear DNS_Server;
}
else
{
dns = Servers [Supplier == input.DNS_Hosting];
for each s in dns
{
DNS_Server.add(s.IP_Address);
}
}
}
)
DNS_Server
(
displayname = "DNS Server"
type = picklist
values = Servers.IP_Address
)
DNS_User
(
displayname = "DNS User"
type = text
)
DNS_Pass
(
displayname = "DNS Pass"
type = text
)
Languages
(
type = list
values = {"italiano", "inglese", "francese", "tedesco", "spagnolo", "portoghese", "olandese", "giapponese", "koreano", "cinese", "arabo", "russo", "turco", "greco", "ungherese", "danese", "svedese", "islandese", "norvegese", "finlandese", "croato", "cecoslovacco", "polacco", "tailandese", "rumeno"}
)
Site_Admin_URL
(
displayname = "Site Admin URL"
type = text
)
Site_Admin_Username
(
displayname = "Site Admin Username"
type = text
)
Site_Admin_Password
(
displayname = "Site Admin Password"
type = text
)
Links_Admin
(
displayname = "Links Admin"
type = text
)
Stats
(
type = picklist
values = Stats.URL
)
CLab
(
type = checkbox
defaultvalue = false
)
FTP_Host
(
displayname = "FTP Host"
type = text
)
FTP_User
(
displayname = "FTP User"
type = text
)
FTP_Password
(
displayname = "FTP Password"
type = text
)
FTP_Path
(
displayname = "FTP Path"
type = text
)
Analytics_Code
(
displayname = "Analytics Code"
type = text
)
}
// End Form Definition
Thanks for your help!
Have a nice day : )