How to use Mango Queries with special characters in Windows shell

[janl]

This came up over in the CouchDB Slack that I think is worth keeping here as well:

Original Question

Hi i'm using _find on Windows with CURL command. I need to query with "accents" or "tilde" for example:

curl -X POST http://anna:secret@127.0.0.1:5984/pruebaproyecto/_find -H "Accept: application/json" -H "Content-Type: application/json" -d "{  \"selector\": {    \"age\": 29,    \"$or\": [      {        \"name\": \"Martín\"      },      {        \"name\": \"Daniela\"      }    ]  },  \"fields\": [    \"name\",    \"age\",    \"_id\"  ]}"
Martín has accent in the letter "i", but i get the below error:
 {"error":"bad_request","reason":"invalid UTF-8 JSON"}

I'm using CouchDB 3.1.0 on Windows 10.

First Response

try storing the selector in a file and use curl -d @filename.json

Original Continued

Hi, would it work for me?
Now i have to create a filename.json and add in this only de query or all the parameter curl.
Example:

Option 1: "{ \"selector\": { \"age\": 29, \"$or\": [ { \"name\": \"Martín\" }, { \"name\": \"Daniela\" } ] }, \"fields\": [ \"name\", \"age\", \"_id\" ]}"
Option 2: curl -X POST http://anna:secret@127.0.0.1:5984/pruebaproyecto/_find -H "Accept: application/json" -H "Content-Type: application/json" -d "{ \"selector\": { \"age\": 29, \"$or\": [ { \"name\": \"Martín\" }, { \"name\": \"Daniela\" } ] }, \"fields\": [ \"name\", \"age\", \"_id\" ]}"

[janl]

Solution

Thank you! I try both options, The firts option worked me. And use the json structure with special caracters for windows:

{  
    "selector": {    
        "age": 29,    
        "$or": [      
            {        
                "name": "Martín"      
            },      
            {        
                "name": "Daniela"      
            }    
        ]  
    },  
    "fields": [    
        "name",    "age",    "_id"  
    ]
}

And my curl command on Windos was:
curl -X POST http://anna:secret@127.0.0.1:5984/pruebaproyecto/_find -H "Accept: application/json" -H "Content-Type: application/json" -d @query1.json