[ckan-discuss] Query about DataStore API - datastore_search_sql, API key of sysadmin required

Adrià Mercader adria.mercader at okfn.org
Wed Sep 11 10:09:03 BST 2013

Hi Joel,

That is bizarre, authorization for datastore_search_sql depends on the
resource_show one, which in turn depends on package_show. Ie if the
dataset is public you should not need an API key at all as everybody
can see public datasets.

Perhaps an auth setting in your extension or a configuration setting
is not working as expected?


On 10 September 2013 15:05, Joel Natividad <joel.natividad at ontodia.com> wrote:
> Hi Folks!
> Looking forward to OKCon.  Sami and I are both ready and have even figured
> out how to multiplex the different tracks next week :)
> As luck would have it, we're also launching the a CKAN portal next week for
> one of our clients.
> We've assembled a localized tutorial using their cleaned, normalized, linked
> data.
> However, it seems that we can't do datastore_search_sql call unless the API
> key is that of a sysadmin.  When we use an API key for a "normal" CKAN user,
> I get an authorization error.
> And yes, we did check that the datasets are public.
> Any hints?
> Thanks,
> Joel
> --
> Joel Natividad
> +1 347-565-5635
> @jqnatividad
> Ontodia, Inc.
> 137 Varick Street, 2nd Floor
> New York, NY 10013
> pediacities.com * nycpedia.com
> _______________________________________________
> ckan-discuss mailing list
> ckan-discuss at lists.okfn.org
> http://lists.okfn.org/mailman/listinfo/ckan-discuss
> Unsubscribe: http://lists.okfn.org/mailman/options/ckan-discuss

More information about the ckan-discuss mailing list