Re: [API-users] Getting server error 500 while trying to post a download request
![](https://secure.gravatar.com/avatar/eebfe70782eddbd0e4c77a144ef6b9d6.jpg?s=120&d=mm&r=g)
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 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
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"],"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
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.
Is it a documentation issue or 'in' predicate does not support 'TAXON_KEY'?
Thanks, Priyank _______________________________________________ API-users mailing list API-users@lists.gbif.org http://lists.gbif.org/mailman/listinfo/api-users
![](https://secure.gravatar.com/avatar/22750478a951ac4b6172a46a3176b9a4.jpg?s=120&d=mm&r=g)
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 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 *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
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"],"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
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.
Is it a documentation issue or 'in' predicate does not support 'TAXON_KEY'?
Thanks, Priyank _______________________________________________ API-users mailing list API-users@lists.gbif.org http://lists.gbif.org/mailman/listinfo/api-users
API-users mailing list API-users@lists.gbif.org http://lists.gbif.org/mailman/listinfo/api-users
![](https://secure.gravatar.com/avatar/38270e964a45066ea7ecea84b985120d.jpg?s=120&d=mm&r=g)
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
participants (3)
-
Markus Döring
-
Priyank Tiwari
-
Tim Robertson