Hi Priyank,

we have logged the IN issue, but meanwhile you can use a nested OR query for taxon_key to do the same. Here is a modified query that searches for 3 taxon keys:

{ "creator": "markus", "predicate": { "type": "and", "predicates": [ { "key": "HAS_COORDINATE", "type": "equals", "value": "true" }, { "key": "HAS_GEOSPATIAL_ISSUE", "type": "equals", "value": "false" }, { "key": "YEAR", "type": "greaterThanOrEquals", "value": 1995 }, { "key": "COUNTRY", "type": "equals", "value": "IN" }, { "type": "or", "predicates": [ { "key": "TAXON_KEY", "type": "equals", "value": 797 }, { "key": "TAXON_KEY", "type": "equals", "value": 798 }, { "key": "TAXON_KEY", "type": "equals", "value": 799 } ] } ] } }

See my download here which I created using curl: http://www.gbif.org/occurrence/download/0000326-150523225239109 http://www.gbif.org/occurrence/download/0000326-150523225239109

best, Markus

On 26 May 2015, at 09:54, Priyank Tiwari priyankgt@gmail.com wrote:

Thanks Tim.

So to emulate the 'in' behaviour, can I use 'TAXON_KEY' = 'XXX' OR 'TAXON_KEY' = 'YYY' kind of predicate? Any other efficient solution to emulate 'in' behaviour?

On Tue, May 26, 2015 at 1:21 PM, Tim Robertson <trobertson@gbif.org mailto:trobertson@gbif.org> wrote: Hi Priyank

The TAXON_KEY currently only supports the equals predicate. We will look to support an array of values in the future.

Please let me know if that solves your problem.

Thanks, Tim

...

...

From: Priyank Tiwari <priyankgt@gmail.com mailto:priyankgt@gmail.com> Subject: [API-users] Getting server error 500 while trying to post a download request Date: 26 May 2015 08:16:09 GMT+2 To: api-users@lists.gbif.org mailto:api-users@lists.gbif.org

Hi,

I am trying to post a download request which is as follows,

curl -i -u username:password -H "Content-Type: application/json" -H "Accept: application/json" -X POST -d '{"creator":"username","notification_address": ["username@domain.com mailto:username@domain.com"],"predicate":{"type":"and","predicates":[{"type":"equals","key":"HAS_COORDINATE","value":"true"},{"type":"equals","key":"HAS_GEOSPATIAL_ISSUE","value":"false"},{"type":"greaterThanOrEquals","key":"YEAR","value":1995},{"type":"greaterThanOrEquals","key":"MONTH","value":1},{"type":"equals","key":"COUNTRY","value":"IN"},{"type":"in","key":"TAXON_KEY","values":[797]}]}}' http://api.gbif.org/v1/occurrence/download/request http://api.gbif.org/v1/occurrence/download/request

But the server is throwing a 500 error. The relevant part among the entire printed error trace I think is

Caused by: java.lang.IllegalArgumentException: Search parameter TAXON_KEY is not mapped to Hive

at org.gbif.occurrence.download.service.HiveQueryVisitor.toHiveField(HiveQueryVisitor.java:147)

at org.gbif.occurrence.download.service.HiveQueryVisitor.visit(HiveQueryVisitor.java:209)

... 58 more

It says that search parameter TAXON_KEY is not mapped, but I see TAXON_KEY being used in the examples at http://www.gbif.org/developer/occurrence#predicates http://www.gbif.org/developer/occurrence#predicates.

Is it a documentation issue or 'in' predicate does not support 'TAXON_KEY'?

Thanks, Priyank _______________________________________________ API-users mailing list API-users@lists.gbif.org mailto:API-users@lists.gbif.org http://lists.gbif.org/mailman/listinfo/api-users http://lists.gbif.org/mailman/listinfo/api-users

---

API-users mailing list API-users@lists.gbif.org mailto:API-users@lists.gbif.org http://lists.gbif.org/mailman/listinfo/api-users http://lists.gbif.org/mailman/listinfo/api-users

-- ~ Priyank _______________________________________________ API-users mailing list API-users@lists.gbif.org http://lists.gbif.org/mailman/listinfo/api-users