Json_parse_exception - Unrecognized token 'analytics_query'

Elastic Stack Elasticsearch
1

I am using below command to get details about number of API calls for Product "IBM API Connect - kubernetes version" :
Command : kubectl exec -it r480b58da7f-analytics-storage-coordinating-7fc6b48b74-dq6f5 -n apic-analyt -- curl_es /apic-api-r/_search?pretty -d 'analytics_query' -H 'Content-Type: application/json'

Response Output :

{
  "error" : {
    "root_cause" : [
      {
        "type" : "json_parse_exception",
        "reason" : "Unrecognized token 'analytics_query': was expecting ('true', 'false' or 'null')\n at [Source: org.elasticsearch.transport.netty4.ByteBufStreamInput@735d0ec1; line: 1, column: 31]"
      }
    ],
    "type" : "json_parse_exception",
    "reason" : "Unrecognized token 'analytics_query': was expecting ('true', 'false' or 'null')\n at [Source: org.elasticsearch.transport.netty4.ByteBufStreamInput@735d0ec1; line: 1, column: 31]"
  },
  "status" : 500
}

The analytics_query i used is as below:

'{
  "size": 0,
  "query": {
    "range": {
      "datetime": {
        "gte": "now-1d/d",
        "lt": "now/d"
      }
    }
  },
  "aggs": {
    "status_codes": {
      "filters": {
        "filters": {
          "1xx": {
            "regexp": {
              "status_code": "1.*"
            }
          },
          "2xx": {
            "regexp": {
              "status_code": "2.*"
            }
          },
          "3xx": {
            "regexp": {
              "status_code": "3.*"
            }
          },
          "4xx": {
            "regexp": {
              "status_code": "4.*"
            }
          },
          "5xx": {
            "regexp": {
              "status_code": "5.*"
            }
          }
        }
      }
    }
  }
}'
2

When I ssh in pod and execute curl command (curl_es /apic-api-r) , Pod gives the following response:

immediate_client_ip":{"type":"ip"},"latency_info":{"properties":{"started":{"type":"text","fields":{"keyword":{"type":"keyword","ignore_above":256}}},"task":{"type":"text","fields":{"keyword":{"type":"keyword","ignore_above":256}}}}},"log_policy":{"type":"keyword"},"org_id":{"type":"keyword"},"org_name":{"type":"text","fields":{"keyword":{"type":"keyword"}}},"plan_id":{"type":"keyword"},"plan_name":{"type":"text","fields":{"keyword":{"type":"keyword"}}},"plan_version":{"type":"keyword"},"product_id":{"type":"keyword"},"product_name":{"type":"text","fields":{"keyword":{"type":"keyword"}}},"product_title":{"type":"text","fields":{"keyword":{"type":"keyword"}}},"product_version":{"type":"keyword"},"query_string":{"type":"object","enabled":false},"rate_limit":{"properties":{"default":{"properties":{"count":{"type":"text","fields":{"keyword":{"type":"keyword","ignore_above":256}}},"interval":{"type":"text","fields":{"keyword":{"type":"keyword","ignore_above":256}}},"limit":{"type":"text","fields":{"keyword":{"type":"keyword","ignore_above":256}}},"period":{"type":"text","fields":{"keyword":{"type":"keyword","ignore_above":256}}},"reject":{"type":"text","fields":{"keyword":{"type":"keyword","ignore_above":256}}},"shared":{"type":"text","fields":{"keyword":{"type":"keyword","ignore_above":256}}},"unit":{"type":"text","fields":{"keyword":{"type":"keyword","ignore_above":256}}}}},"per-minute":{"properties":{"count":{"type":"long"},"limit":{"type":"long"}}},"rate-limit":{"properties":{"count":{"type":"long"},"limit":{"type":"long"}}},"rate-limit-1":{"properties":{"count":{"type":"long"},"limit":{"type":"long"}}},"rate-limit-2":{"properties":{"count":{"type":"long"},"limit":{"type":"long"}}}}},"request_body":{"type":"keyword","doc_values":false,"ignore_above":10922},"request_http_headers":{"dynamic":"false","properties":{"Accept":{"type":"keyword"},"Accept-Charset":{"type":"keyword"},"Accept-Datetime":{"type":"keyword"},"Accept-Encoding":{"type":"keyword"},"Accept-Language":{"type":"keyword"},"Accept-Patch":{"type":"keyword"},"Accept-Ranges":{"type":"keyword"},"Access-Control-Allow-Credentials":{"type":"keyword"},"Access-Control-Allow-Methods":{"type":"text","fields":{"raw":{"type":"keyword"}}},"Access-Control-Allow-Origin":{"type":"keyword"},"Access-Control-Expose-Headers":{"type":"text","fields":{"raw":{"type":"keyword"}}},"Age":{"type":"long"},"Allow":{"type":"text","fields":{"raw":{"type":"keyword"}}},"Alt-Svc":{"type":"keyword"},"Cache-Control":{"type":"keyword"},"Connection":{"type":"keyword"},"Content-Disposition":{"type":"keyword"},"Content-Encoding":{"type":"keyword"},"Content-Language":{"type":"keyword"},"Content-Length":{"type":"long"},"Content-Location":{"type":"keyword"},"Content-Range":{"type":"keyword"},"Content-Security-Policy":{"type":"keyword"},"Content-Type":{"type":"text","fields":{"keyword":{"type":"keyword"}}},"Cookie":{"type":"keyword","ignore_above":10922},"DNT":{"type":"keyword"},"Date":{"type":"keyword"},"ETag":{"type":"keyword"},"Expect":{"type":"keyword"},"Expires":{"type":"keyword"},"Forwarded":{"type":"keyword"},"From":{"type":"keyword"},"Front-End-Https":{"type":"keyword"},"Host":{"type":"keyword"},"If-Match":{"type":"keyword"},"If-Modified-Since":{"type":"keyword"},"If-None-Match":{"type":"keyword"},"If-Range":{"type":"keyword"},"If-Unmodified-Since":{"type":"keyword"},"Last-Modified":{"type":"keyword"},"Link":{"type":"keyword"},"Location":{"type":"keyword"},"Max-Forwards":{"type":"long"},"Origin":{"type":"keyword"},"P3P":{"type":"keyword"},"Pragma":{"type":"keyword"},"Proxy-Authenticate":{"type":"keyword"},"Proxy-Connection":{"type":"keyword"},"Range":{"type":"keyword"},"Referer":{"type":"keyword"},"Refresh":{"type":"keyword"},"Retry-After":{"type":"keyword"},"Server":{"type":"keyword"},"Set-Cookie":{"type":"keyword"},"Status":{"type":"keyword"},"Strict-Transport-Security":{"type":"keyword"},"TE":{"type":"keyword"},"TSV":{"type":"keyword"},"Trailer":{"type":"keyword"},"Transfer-Encoding":{"type":"keyword"},"Upgrade":{"type":"keyword"},"User-Agent":{"type":"text","fields":{"raw":{"type":"keyword"}}},"Via":{"type":"keyword"},"WWW-Authenticate":{"type":"keyword"},"Warning":{"type":"keyword"},"X-ATT-DeviceId":{"type":"keyword"},"X-Backside-Transport":{"type":"keyword"},"X-Client-IP":{"type":"keyword"},"X-Content-Duration":{"type":"keyword"},"X-Content-Security-Policy":{"type":"keyword"},"X-Content-Type-Options":{"type":"keyword"},"X-Correlation-ID":{"type":"keyword"},"X-Csrf-Token":{"type":"keyword"},"X-Forwarded-For":{"type":"keyword"},"X-Forwarded-Host":{"type":"keyword"},"X-Forwarded-Proto":{"type":"keyword"},"X-Global-Transaction-ID":{"type":"keyword"},"X-Http-Method-Override":{"type":"keyword"},"X-Powered-By":{"type":"keyword"},"X-RateLimit-Limit":{"type":"keyword"},"X-RateLimit-Remaining":{"type":"keyword"},"X-Request-ID":{"type":"keyword"},"X-Requested-With":{"type":"keyword"},"X-UA-Compatible":{"type":"keyword"},"X-UIDH":{"type":"keyword"},"X-Wap-Profile":{"type":"keyword"},"X-XSS-Protection":{"type":"keyword"}}},"request_method":{"type":"keyword"},"request_protocol":{"type":"keyword"},"resource":{"type":"text","fields":{"keyword":{"type":"keyword"}}},"resource_id":{"type":"text","fields":{"keyword":{"type":"keyword"}}},"resource_path":{"type":"text","fields":{"keyword":{"type":"keyword"}}},"response_body":{"type":"keyword","doc_values":false,"ignore_above":10922},"response_http_headers":{"type":"object","enabled":false},"space_id":{"type":"keyword"},"space_name":{"type":"text","fields":{"keyword":{"type":"keyword"}}},"status_code":{"type":"text","fields":{"keyword":{"type":"keyword"}}},"tags":{"type":"text","fields":{"keyword":{"type":"keyword","ignore_above":256}}},"time_to_serve_request":{"type":"long"},"transaction_id":{"type":"keyword"},"uri_path":{"type":"text","fields":{"keyword":{"type":"keyword"}}}}}},"settings":{"index":{"mapping":{"total_fields":{"limit":"1000000"}},"refresh_interval":"10s","number_of_shards":"5","auto_expand_replicas":"false","provided_name":"<apic-api-{now/d}-000158>","creation_date":"1586655902977","number_of_replicas":"2","uuid":"P_-9jwxYReyDR7UaGq8KEw","version":{"created":"5061699"}
3

So, I have made a successful response outcome. The only change i made was passing query string directly in command itself.
The command, 'analytics_query' should be replaced by the actual content of the file.
kubectl exec -it r480b58da7f-analytics-storage-coordinating-7fc6b48b74-dq6f5 -n apic-analyt -- curl_es /apic-api-r/_search?pretty -d 'analytics_query' -H 'Content-Type: application/json'

In a curl command, the -d option is followed by the payload data.
Example:
curl - d '{"key1":"value1", "key2":"value2"}' -H "Content-Type: application/json" -X POST http://localhost:3000/data

4

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.