JSON Parse Exception when creating Index Template

Question

I'm using Powershell (via Cmder) along with curl (GoW) to create an index template in elasticsearch.

Here's my curl:

curl -XPUT http://myAddress:9200/_template/logstash_per_iis -u user:password -d' 
{
    "template" : "logstash*",
    "mappings" : {
      "iis" : {
        "properties" : {
            "response":{"type":"int"},
            "site":{"type":"ip"},
            "supresponse":{"type":"int"},
            "time_taken":{"type":"int"},
            "clientHost":{"type":"ip"},
            "port":{"type":"int"},
            "scstatus":{"type":"int"}
        }
      }
    }
}
'

Here's the response from ES:

{
  "error": {
    "root_cause": [
      {
        "type": "illegal_argument_exception",
        "reason": "failed to parse template source"
      }
    ],
    "type": "illegal_argument_exception",
    "reason": "failed to parse template source",
    "caused_by": {
      "type": "json_parse_exception",
      "reason": "Unrecognized token 'logstash': was expecting ('true', 'false' or 'null')\n at [Source: [B@38a6a400; line: 3, column: 25]"
    }
  },
  "status": 400
}

ES is stating a json_parse_exception, however, I cannot figure out where my JSON package is invalid.

What is wrong with my JSON or am I doing something else incorrectly?

It's weird, I could execute that exact curl command (after replacing myAddress with localhost) on both ES 1.x and ES 2.x clusters without any problem (on MacOS). — Val
– Val, Commented Jan 4, 2016 at 19:18
@Val, I should have noted more explicitly that I'm on windows. Looks like the answer is I needed """ vs ". Thanks for your time, though. Much appreciated. — Justin Self
– Justin Self, Commented Jan 4, 2016 at 19:19
No prob, I'll leave my comment for the Mac folks landing on this question ;) — Val
– Val, Commented Jan 4, 2016 at 19:20

Community · Accepted Answer · 2017-05-23 12:22:58Z

2

Turns out curl on windows needs """ instead of just ".

Found the answer from this question: https://stackoverflow.com/a/27761856/899048

So, my curl ends up looking like this:..

curl -XPUT http://myAddress:9200/_template/logstash_per_iis -u user:password -d' 
{
    """template""" : """logstash*"""
    """mappings""" : {
      """iis""" : {
          """response""":{"""type""":"""int"""},
          """site""":{"""type""":"""ip"""},
          """supresponse""":{"""type""":"""int"""},
          """time_taken""":{"""type""":"""int"""},
          """clientHost""":{"""type""":"""ip"""},
          """port""":{"""type""":"""int"""},
          """scstatus""":{"""type""":"""int"""}
      }
    }
}
'

Looks horrible, but it worked.

edited May 23, 2017 at 12:22

CommunityBot

11 silver badge

answered Jan 4, 2016 at 19:18

Justin Self

6,3053 gold badges35 silver badges49 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

LogicalKip Over a year ago

One of the comments on that question mentions \", which works for me and looks better.

Collectives™ on Stack Overflow

JSON Parse Exception when creating Index Template

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related