[ckan-dev] problem inserting a row in the dataset

Fri May 31 16:35:22 UTC 2013

hi there,
we tried to ask 
Gavin Chait | Head of Services | Open Knowledge Foundation
for  help, but were asked to post to the dev list - i hope someone can help - we have a deadline for this NYC BigApps contest of june 7, so this is timely critical!

i made a dataset, and i have no problem querying the set using this string (i blocked out the id number)

    NSString *feedURLString = @"http://sandboxdw.pediacities.com/api/3/action/datastore_search?resource_id=XXX&limit=5";

i am getting "http error" (400) when i try to insert a row in it 
here is the url i use

http://sandboxdw.pediacities.com/api/3/action/datastore_upsert?resource_id=XXX&records=%7B%22Division%22:%20%22BMTFake%22,%20%22Line%22:%20%22BroadwayFake%22,%22Station_Name%22:%20%2249th%20St%22,%22Station_Latitude%22:%20%22BMTFake%22,%22Station_Longitude%22:%20%20%22-73.984139%22%7D&method=insert

i am only providing a few of the columns on the dataset - that cant be the problem... it must be the syntax... i have spent hours researching this, to no avail - any ideas??
thnx,
fran

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20130531/ced3e694/attachment.html>