CouchDB error using startkey&endkey in a key array

Question

Hi guys I'm trying to use the following request:

curl http://localhost:5984/contacts/_design/country/_view/USA?startkey=["USA",{}]&endkey=["USA",{}].

On the following view:

{
"_id": "_design/country",
"_rev": "1-51488ea3931fdca9b9e2de84ef99c4d9",
"language": "javascript",
"views": {
   "USA": {
       "map": "function(doc) {\nif(doc.type == \"contact\") \nemit([doc.country,doc.name] , {name: doc.name, email: doc.email});\n}\n"
   }
 }
 }

and I get this error: [globbing] bad range in column 72

Can you help me?

You should only include the ,{} for endkey, leave it out of the startkey. In addition, I would wrap your URL in single quotes so your shell won't try and expand the {} as a glob pattern. (or try Alexis' answer about adding -g) — Dominic Barnes
What does startkey=["USA",{}] do as opposed to startkey="USA" ? — ksav
i left the ,{} out of the startkey but i get the same error. if i use startkey="USA" i get {"error":"bad_request","reason":"invalid_json"}. — Francesco Rosa

Alexis Côté Alexis Côté · Accepted Answer · 2016-07-08T13:16:04

The problem is coming from cUrl I suppose ? Try this :

-g/--globoff
              This  option  switches  off  the "URL globbing parser". When you set this option, you can
              specify URLs that contain the letters {}[] without having them being interpreted by  curl
              itself.  Note  that  these  letters  are not normal legal URL contents but they should be
              encoded according to the URI standard.

CouchDB error using startkey&endkey in a key array

2 Answers