Example for a valid delug criteria
Hi,
http://api.creator.zoho.com/REST-API-View-Records-in-View.html
The Api above has a criteria field as post parameter. I'd like to see and example how can I use that. It says I should enter a valid delug criteria, but don't know how is the format of that. I can set it from GUI, though.
To be more specific I'll give an example. I have a two forms, Accounts and Lists. A List belongs to an Account so the List have a lookup field in it for Accounts. I'd like to create the deluge criteria for Lists to query all the lists that belong to an Account with email = me@example.com (for instance, emails are unique). So I have Accounts.Email = "me@example.com" which works in GUI but returns an empty object when querying with API.
I managed to do this in two steps, first querying the Accounts_View with the deluge criteria email to get the Account id, then query the Lists_View with Account = ID (from the previous query) to get the lists.
How can I do this in one query?
Thanks.