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

Mon Jun 3 12:52:42 UTC 2013

Hi Fran,

Here is an example of the syntax for how to insert a new row into an
existing resource.

https://gist.github.com/amercader/5697832

Note you'll need to replace "XXXX" with your api key which you can get from
http://sandboxdw.pediacities.com/user/[yourusername] when logged in

This is the resource in question
http://sandboxdw.pediacities.com/dataset/test-tabular-data/resource/4f978bc5-fccd-4a74-85ef-f9f7bc05f38c

Hope this helps.

Best,

Darwin

On 3 June 2013 02:54, <fwolanczyk at cs.com> wrote:

>   hi all,
> okay, still problems - i tried the "post" in my ios request, and it isn't
> that,
>
>  more simply, if you just put the following line in a browser, you get
> output - the query works fine, the problem is with the insert
>
>
> http://sandboxdw.pediacities.com/api/3/action/datastore_search?resource_id=16d8ab0b-38bd-41b4-9b0c-49ff0420d4f1&limit=5
>
>  result is the 5 rows...
>
>   the problem is with the insert
>
>  http://sandboxdw.pediacities.com/api/3/action/datastore_upsert?resource_id=16d8ab0b-38bd-41b4-9b0c-49ff0420d4f1&records=[{\"Division\":\"BMTFake\",\"Line\":\"BroadwayFake\",\"Station_Name\":\"49th
> St\",\"Station_Latitude\":\"40.760621\",\"Station_Longitude\":\"-73.984139\"}]&method=insert
>
>  this line returns
>
>  "Bad request - JSON Error: No request body data"
>
>
> im at my wits end... help!!
>
> fran w
>
>
>
>
> _______________________________________________
> ckan-dev mailing list
> ckan-dev at lists.okfn.org
> http://lists.okfn.org/mailman/listinfo/ckan-dev
> Unsubscribe: http://lists.okfn.org/mailman/options/ckan-dev
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20130603/80022b59/attachment-0001.html>