json - How to use `jq` to obtain the keys -


my json looks : 

{   "20160522201409-jobsv1-1": {     "vmstatedisplayname": "ready",     "servers": {       "20160522201409 jobs_v1 1": {         "serverstatedisplayname": "ready",         "creationdate": "2016-05-22t20:14:22.000+0000",         "state": "ready",         "provisionstatus": "pending",         "serverrole": "role",         "servertype": "server",         "servername": "20160522201409 jobs_v1 1",         "serverid": 2902       }     },     "isadminnode": true,     "creationdate": "2016-05-22t20:14:23.000+0000",     "totalstorage": 15360,     "shapeid": "ot1",     "state": "ready",     "vmid": 4353,     "hostname": "20160522201409-jobsv1-1",     "label": "20160522201409 jobs_v1 admin_server 1",     "ipaddress": "10.252.159.39",     "publicipaddress": "10.252.159.39",     "usagetype": "admin_server",     "role": "admin_server",     "componenttype": "jobs_v1"   } }

my key keeps changing time time. example 20160522201409-jobsv1-1 may else tomorrow. may more 1 such entry in json payload.

i want echo $keys , trying using jq.

things have tried : | jq .keys command use frequently.

is there jq command display primary keys in json?

i care hostname field. , extract out. know how using grep not clean approach.

you can use: keys:

% jq 'keys' my.json [   "20160522201409-jobsv1-1" ]

and first:

% jq -r 'keys[0]' my.json 20160522201409-jobsv1-1

-r raw output:

--raw-output / -r: option, if filter’s result string written directly standard output rather being formatted json string quotes. can useful making jq filters talk non-json-based systems.

source

if want known value below unknown property, eg xxx.hostname:

% jq -r '.[].hostname' my.json 20160522201409-jobsv1-1

-

Popular posts from this blog

Apache NiFi ExecuteScript: Groovy script to replace Json values via a mapping file -

i working apache nifi 0.5.1 on groovy script replace incoming json values ones contained in mapping file. mapping file looks (it simple .txt): header1;header2;header3 a;some text;a2 i have started following: import groovy.json.jsonbuilder import groovy.json.jsonslurper import java.nio.charset.standardcharsets def flowfile = session.get(); if (flowfile == null) { return; } flowfile = session.write(flowfile, { inputstream, outputstream -> def content = """ { "field1": "a" "field2": "a", "field3": "a" }""" def slurped = new jsonslurper().parsetext(content) def builder = new jsonbuilder(slurped) builder.content.field1 = "a" builder.content.field2 = "some text" builder.content.field3 = "a2" outputstream.write(builder.toprettystring().ge...
Read more

node.js - How do I prevent MongoDB replica set from querying the primary? -

read-operations-only: is there way have mongodb replica set, make mongodb instance on box connected to, mongodb gets queried? i have 3 ec2 instances behind aws load balancer. on each ec2 instance runs mongodb, part of replica set. i have express endpoints on nodejs , connect replica set follows mongodb.mongoclient.connect('mongodb://1.1.1.1,2.2.2.2,3.3.3.3.', function (err, db) { if (err) { complete('{}'); } else { i distribute load of queries evenly across 3 instances of mongodb replica set instead of default having queries routed ec2 instance primary mongodb defined, because destroys point of load balancer (which balance load of queries across 3 instances evenly). my understanding when connecting mongodb replica set, primary instance selected unless primary instance down, , therefore purpose of every secondary instance serve backup. in example people call hot,cold,cold. because there 2...
Read more