[ckan-dev] List of datasets that have an URL link in their resource

Tue Apr 23 04:17:20 UTC 2019

Thanks Stephan will try you example command.

Judy

From: ckan-dev [mailto:ckan-dev-bounces at lists.okfn.org] On Behalf Of Stefan Oderbolz
Sent: Thursday, 18 April 2019 5:54 PM
To: CKAN Development Discussions <ckan-dev at lists.okfn.org>
Subject: Re: [ckan-dev] List of datasets that have an URL link in their resource

The fields you can use to search/filter with package_search are defined in your solr schema. If you need additional fields, it's easy to extend the schema and re-index your datasets. However for the case you describe the standard schema should be enough.

In the default CKAN solr schema, there is a field called "res_type" that coresponds to the "resource_type" field in the CKAN model.

For file uploads the value of this field is set to "file", so you could use that to filter out all datasets containing a resource with the resource_type "file" (note the "-" to exclude results that match):

fq=-res_type:file

E.g. for the City of Zurich portal:

https://data.stadt-zuerich.ch/api/3/action/package_search?fq=-res_type:file

- Stefan

On Thu, Apr 18, 2019, 05:51 Judith Moran <Judith.Moran at nt.gov.au<mailto:Judith.Moran at nt.gov.au>> wrote:
Hi,

We need a list of dataset that have only resources that use a LINK.

I have run this and see them in the list but don’t know the parameters to filter only resources that use a link (not the file option).

curl 'http://opendata.nt.gov.au/api/3/action/package_search?fq=tags:*' > AllTags.xlsx

Is there is fq for resources and further filter for those that have a URL link only?

Regards,

Judy Moran
Manager Data Strategy
Department of Corporate and Information Services
Northern Territory Government of Australia
T:  892 96550
E:  DataStrategy.NTG at nt.gov.au<mailto:DataStrategy.NTG at nt.gov.au>

_______________________________________________
ckan-dev mailing list
ckan-dev at lists.okfn.org<mailto:ckan-dev at lists.okfn.org>
https://lists.okfn.org/mailman/listinfo/ckan-dev
Unsubscribe: https://lists.okfn.org/mailman/options/ckan-dev
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20190423/9612c94a/attachment-0002.html>