python and simplejson to extract data from Zoho Creator

python and simplejson to extract data from Zoho Creator

Hello,
I'm trying to tinker with Zoho Creator. It's really a cool tool to populate a database quickly. However ...

I want to access the database via a json permalink. I use python and its json module, simplejson. I get the following error from the python console:

>>> import urllib, simplejson
>>> x = simplejson.load(urllib.urlopen(http://put/here/a/zoho/creator/json/permalink))
(...)
ValueError: No JSON object could be decoded

I know I'm doing things ok because if I put a yahoo json search query url I don't get the error.

Do you guys know how to do this properly in python (to load the json data from the permalink)?

Another couple of questions:
1 - I know you are going to release an API for Zoho Creator soon. When?
2 - Will we be able to query to our databases stored in zoho creator google-like(or yahoo-like) and get the results in json? Because, right now, I get the whole database in a json permalink. In the future i'd like to apply some filter, criteria or search query ...

I hope you can answer some of my (three) questions. I whish you all the best for your web-software. It really rocks!

Cheers,
Guillaume

http://webtopmania.blogspot.com
guillaume.maretec