Extract JSON fromo Message | KONG Api Manager

Hi Guys! I do not have much experience, but I would like you to help me extract a JSON and interpret it. It is a KONG log, where an API Server is consumed.

These are the steps that I followed and the JSON that is in the message field.

1.The Message

  1. The JSON

    {“latencies”:{“request”:10,“kong”:1,“proxy”:9},“service”:{“host”:“10.0.2.14”,“created_at”:1552150001,“connect_timeout”:60000,“id”:“6bf175cb-f51b-4a2f-bc59-e3ca956db38d”,“protocol”:“http”,“name”:“API_Usuario”,“read_timeout”:60000,“port”:5000,“updated_at”:1552318277,“retries”:5,“write_timeout”:60000},“request”:{“querystring”:{},“size”:“82”,“uri”:"/user",“url”:“http://10.0.2.16:8000/user",“headers”:{“host”:“10.0.2.16:8000”,“accept”:"/”,“user-agent”:“curl/7.58.0”},“method”:“GET”},“tries”:[{“balancer_latency”:0,“port”:5000,“balancer_start”:1552930179545,“ip”:“10.0.2.14”}],“client_ip”:“10.0.2.16”,“api”:{},“upstream_uri”:"/user",“response”:{“headers”:{“via”:“kong/0.14.1”,“content-type”:“application/json”,“date”:“Mon, 18 Mar 2019 17:29:39 GMT”,“server”:“Werkzeug/0.14.1 Python/2.7.15+”,“connection”:“close”,“x-kong-proxy-latency”:“0”,“x-kong-upstream-latency”:“9”,“content-length”:“53”},“status”:200,“size”:“296”},“route”:{“created_at”:1552150052,“strip_path”:false,“hosts”:,“preserve_host”:false,“regex_priority”:0,“updated_at”:1552332829,“paths”:["/user"],“service”:{“id”:“6bf175cb-f51b-4a2f-bc59-e3ca956db38d”},“methods”:[“GET”,“POST”,“DELETE”],“protocols”:[“http”,“https”],“id”:“7a85b4ce-c034-4a2b-8783-f52f7efc7949”},“started_at”:1552930179545}

  2. The Step to Extract

  1. And here, What it’s List Item separator? Or Key Separator? Its " and :?

After applying, the extrator. What is the procedure?

Regarts! And Thanks!

When apply the extractor:

And now? What is the next step?

I resolved it!

I created an Extractor to split the messege! And the created the metrics!

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