[ckan-dev] return specified results through datastore_search API

Wed May 15 08:17:13 UTC 2013

Thanks very much for your detailed answer and the docs you provided for me.
Best regards

2013/5/14 Dominik Moritz <dominik.moritz at okfn.org>

> Hi,
>
> On 14 May 2013, at 03:53, 天龙出云 <dragoniszhang at gmail.com> wrote:
>
> > hello everyone,
> >
> > I want to use datastore_search API to find specified results with curl
> > command like the following:
> > curl
> >
> http://127.0.0.1:5000/api/3/action/datastore_search?resource_id=adae6ab9-731d-462a-82c9-fd1e8c9ea3f6&fields='c,n
> > '
> > the value of fields 'c,n' are the column name of the table in datastore
> > database.
>
> It does work for me. See
> http://demo.ckan.org/api/action/datastore_search?resource_id=f6331f99-51f6-44d9-95b9-b20f3b74f360&fields=lat,lon
>
> If that does not work, you should try to use POST instead of GET requests.
>
> > The problem is that the returned results still contain all the
> information
> > instead of the specified results I wish. Is there any problem with my
> curl
> > command? I did not find a detailed tutorial to use datastore_search API
> > with multiple parameters.
>
> We have the docs at http://docs.ckan.org/en/latest/api.html and
> http://docs.ckan.org/en/latest/datastore-api.html. I'm afraid we don't
> have a tutorial but I hope you find help in the docs.
>
> >
> > Another question is that if I want to give aliases to a resource on the
> web
> > page, where can I input the aliases to send to the datastore_create API?
> I
> > did not see anywhere to input the aliases attribute when I create a
> > resource on web page.
>
> You can't create an alias through the Interface. It's really easy to do it
> through the API, though. You need to send a POST request with a json object
> like this:
>
> to datastore_create
>
> {
>     "resource_id": "adae6ab9-731d-462a-82c9",
>     "aliases": "my_alias",
>     "fields": [{"id": "book", "type": "text"},
>                    {"id": "author", "type": "text"}]
>    ...
> }
>
> Hope that helps,
> Dominik
>
> > _______________________________________________
> > 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
>
> Dominik Moritz
> CKAN developer  |  skype: d.moritz  |  @doobly_doo
> The Open Knowledge Foundation
> Empowering through Open Knowledge
> http://okfn.org/  |  @okfn  |  http://ckan.org  |  @CKANproject
>
>
> _______________________________________________
> 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/20130515/269457d0/attachment-0001.html>