<html><head><meta http-equiv="Content-Type" content="text/html charset=us-ascii"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">Hi Priyank,<div class=""><br class=""></div><div class="">we have logged the IN issue, but meanwhile you can use a nested OR query for taxon_key to do the same.</div><div class="">Here is a modified query that searches for 3 taxon keys:</div><div class=""><br class=""></div><div class=""><div class="">{</div><div class=""> "creator": "markus",</div><div class=""> "predicate": {</div><div class=""> "type": "and",</div><div class=""> "predicates": [</div><div class=""> {</div><div class=""> "key": "HAS_COORDINATE",</div><div class=""> "type": "equals",</div><div class=""> "value": "true"</div><div class=""> },</div><div class=""> {</div><div class=""> "key": "HAS_GEOSPATIAL_ISSUE",</div><div class=""> "type": "equals",</div><div class=""> "value": "false"</div><div class=""> },</div><div class=""> {</div><div class=""> "key": "YEAR",</div><div class=""> "type": "greaterThanOrEquals",</div><div class=""> "value": 1995</div><div class=""> },</div><div class=""> {</div><div class=""> "key": "COUNTRY",</div><div class=""> "type": "equals",</div><div class=""> "value": "IN"</div><div class=""> },</div><div class=""> {</div><div class=""> "type": "or",</div><div class=""> "predicates": [</div><div class=""> {</div><div class=""> "key": "TAXON_KEY",</div><div class=""> "type": "equals",</div><div class=""> "value": 797</div><div class=""> },</div><div class=""> {</div><div class=""> "key": "TAXON_KEY",</div><div class=""> "type": "equals",</div><div class=""> "value": 798</div><div class=""> },</div><div class=""> {</div><div class=""> "key": "TAXON_KEY",</div><div class=""> "type": "equals",</div><div class=""> "value": 799</div><div class=""> }</div><div class=""> ]</div><div class=""> }</div><div class=""> ]</div><div class=""> }</div><div class="">}</div></div><div class=""><br class=""></div><div class=""><br class=""></div><div class=""><br class=""></div><div class="">See my download here which I created using curl:</div><div class=""><a href="http://www.gbif.org/occurrence/download/0000326-150523225239109" class="">http://www.gbif.org/occurrence/download/0000326-150523225239109</a></div><div class=""><br class=""></div><div class=""><br class=""></div><div class="">best,</div><div class="">Markus</div><div class=""><br class=""></div><div class=""><br class=""></div><div class=""><br class=""><div><blockquote type="cite" class=""><div class="">On 26 May 2015, at 09:54, Priyank Tiwari <<a href="mailto:priyankgt@gmail.com" class="">priyankgt@gmail.com</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div dir="ltr" class="">Thanks Tim.<div class=""><br class=""></div><div class="">So to emulate the 'in' behaviour, can I use 'TAXON_KEY' = 'XXX' OR 'TAXON_KEY' = 'YYY' kind of predicate?</div><div class="">Any other efficient solution to emulate 'in' behaviour?</div></div><div class="gmail_extra"><br class=""><div class="gmail_quote">On Tue, May 26, 2015 at 1:21 PM, Tim Robertson <span dir="ltr" class=""><<a href="mailto:trobertson@gbif.org" target="_blank" class="">trobertson@gbif.org</a>></span> wrote:<br class=""><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div style="word-wrap:break-word" class=""><div class="">Hi Priyank</div><div class=""><br class=""></div><div class="">The TAXON_KEY currently only supports the equals predicate. We will look to support an array of values in the future.</div><div class=""><br class=""></div><div class="">Please let me know if that solves your problem.</div><div class=""><br class=""></div><div class="">Thanks,</div><div class="">Tim</div><div class=""><br class=""></div><div class=""><br class=""><blockquote type="cite" class=""><div style="word-wrap:break-word" class=""><div class=""><div class=""><blockquote type="cite" class=""><div style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px" class=""><span style="font-family:Helvetica" class=""><b class="">From: </b></span><span style="font-family:'Helvetica'" class="">Priyank Tiwari <<a href="mailto:priyankgt@gmail.com" target="_blank" class="">priyankgt@gmail.com</a>><br class=""></span></div><div style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px" class=""><span style="font-family:Helvetica" class=""><b class="">Subject: </b></span><span style="font-family:'Helvetica'" class=""><b class="">[API-users] Getting server error 500 while trying to post a download request</b><br class=""></span></div><div style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px" class=""><span style="font-family:Helvetica" class=""><b class="">Date: </b></span><span style="font-family:'Helvetica'" class="">26 May 2015 08:16:09 GMT+2<br class=""></span></div><div style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px" class=""><span style="font-family:Helvetica" class=""><b class="">To: </b></span><span style="font-family:'Helvetica'" class=""><a href="mailto:api-users@lists.gbif.org" target="_blank" class="">api-users@lists.gbif.org</a><br class=""></span></div><br class=""><div class=""><div class=""><div class="h5"><div dir="ltr" class="">Hi,<div class=""><br class=""></div><div class="">I am trying to post a download request which is as follows,</div><div class=""><br class=""></div><div class="">curl -i -u username:password -H "Content-Type: application/json" -H "Accept: application/json" -X POST -d '{"creator":"username","notification_address": ["<a href="mailto:username@domain.com" target="_blank" class="">username@domain.com</a>"],"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]}]}}' <a href="http://api.gbif.org/v1/occurrence/download/request" target="_blank" class="">http://api.gbif.org/v1/occurrence/download/request</a></div><div class=""><br class=""></div><div class="">But the server is throwing a 500 error. The relevant part among the entire printed error trace I think is</div><div class=""><br class=""></div><div class=""><p class="">Caused by: java.lang.IllegalArgumentException: Search parameter TAXON_KEY is not mapped to Hive</p><p class="">at org.gbif.occurrence.download.service.HiveQueryVisitor.toHiveField(HiveQueryVisitor.java:147)</p><p class=""><span class=""> </span>at org.gbif.occurrence.download.service.HiveQueryVisitor.visit(HiveQueryVisitor.java:209)</p><p class=""><span class=""> </span>... 58 more</p><div class="">It says that search parameter TAXON_KEY is not mapped, but I see TAXON_KEY being used in the examples at <a href="http://www.gbif.org/developer/occurrence#predicates" target="_blank" class="">http://www.gbif.org/developer/occurrence#predicates</a>.</div><div class=""><br class=""></div><div class="">Is it a documentation issue or 'in' predicate does not support 'TAXON_KEY'?</div><div class=""><br class=""></div><div class=""><br class=""></div>Thanks,<br class=""><div class="">Priyank</div>
</div></div></div></div>
_______________________________________________<br class="">API-users mailing list<br class=""><a href="mailto:API-users@lists.gbif.org" target="_blank" class="">API-users@lists.gbif.org</a><br class=""><a href="http://lists.gbif.org/mailman/listinfo/api-users" target="_blank" class="">http://lists.gbif.org/mailman/listinfo/api-users</a><br class=""></div></blockquote></div><br class=""></div></div></blockquote></div><br class=""></div><br class="">_______________________________________________<br class="">
API-users mailing list<br class="">
<a href="mailto:API-users@lists.gbif.org" class="">API-users@lists.gbif.org</a><br class="">
<a href="http://lists.gbif.org/mailman/listinfo/api-users" target="_blank" class="">http://lists.gbif.org/mailman/listinfo/api-users</a><br class="">
<br class=""></blockquote></div><br class=""><br clear="all" class=""><div class=""><br class=""></div>-- <br class=""><div class="gmail_signature">~ Priyank</div>
</div>
_______________________________________________<br class="">API-users mailing list<br class=""><a href="mailto:API-users@lists.gbif.org" class="">API-users@lists.gbif.org</a><br class="">http://lists.gbif.org/mailman/listinfo/api-users<br class=""></div></blockquote></div><br class=""></div></body></html>