How to extract specific fields recursively from json output? Announcing the arrival of Valued Associate #679: Cesar Manara Planned maintenance scheduled April 23, 2019 at 23:30 UTC (7:30pm US/Eastern) Data science time! April 2019 and salary with experience The Ask Question Wizard is Live!How do I format a Microsoft JSON date?How can I pretty-print JSON in a shell script?Extracting extension from filename in PythonHow to parse JSON in JavaWhy can't Python parse this JSON data?How can I pretty-print JSON using JavaScript?How to parse JSON using Node.js?How do I POST JSON data with Curl from a terminal/commandline to Test Spring REST?How do I write JSON data to a file?How to prettyprint a JSON file?
Why isn't everyone flabbergasted about Bran's "gift"?
Converting a text document with special format to Pandas DataFrame
“Since the train was delayed for more than an hour, passengers were given a full refund.” – Why is there no article before “passengers”?
Are there any AGPL-style licences that require source code modifications to be public?
Would I be safe to drive a 23 year old truck for 7 hours / 450 miles?
Recursive calls to a function - why is the address of the parameter passed to it lowering with each call?
How is an IPA symbol that lacks a name (e.g. ɲ) called?
How can I introduce the names of fantasy creatures to the reader?
Why did Israel vote against lifting the American embargo on Cuba?
What were wait-states, and why was it only an issue for PCs?
Why do C and C++ allow the expression (int) + 4*5?
What is the definining line between a helicopter and a drone a person can ride in?
Continue tikz picture on next page
What is the difference between 准时 and 按时?
Is "ein Herz wie das meine" an antiquated or colloquial use of the possesive pronoun?
Who can become a wight?
Does Prince Arnaud cause someone holding the Princess to lose?
Compiling and throwing simple dynamic exceptions at runtime for JVM
Why aren't these two solutions equivalent? Combinatorics problem
Unix AIX passing variable and arguments to expect and spawn
What helicopter has the most rotor blades?
Is Bran literally the world's memory?
Weaponising the Grasp-at-a-Distance spell
Is my guitar’s action too high?
How to extract specific fields recursively from json output?
Announcing the arrival of Valued Associate #679: Cesar Manara
Planned maintenance scheduled April 23, 2019 at 23:30 UTC (7:30pm US/Eastern)
Data science time! April 2019 and salary with experience
The Ask Question Wizard is Live!How do I format a Microsoft JSON date?How can I pretty-print JSON in a shell script?Extracting extension from filename in PythonHow to parse JSON in JavaWhy can't Python parse this JSON data?How can I pretty-print JSON using JavaScript?How to parse JSON using Node.js?How do I POST JSON data with Curl from a terminal/commandline to Test Spring REST?How do I write JSON data to a file?How to prettyprint a JSON file?
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;
Below is the sample json document or json variable I have. I'm using python for extracting the required fields as mentioned int the output section.
Can someone help on how to do this?
json_variable =
"server01":
"address":"server01:5454",
"options": ,
"state":"online"
,
"server02":
"address":"server02:5454",
"options": ,
"state":"online"
,
"server03":
"address":"server03:5454",
"options": ,
"state":"online"
for x in json_variable:
print(x["address"])
Error:
Traceback (most recent call last):
File "<string>", line 30, in <module>
File "<string>", line 18, in getServerStatus
TypeError: 'shell.Dict' object is not iterable
I can get the required output by hard coding the fields as below, but i would like to do it dynamically as the number of servers vary depending upon the system queried and json returned.
print(json_variable["server01"]["address"])
print(json_variable["server02"]["address"])
print(json_variable["server03"]["address"])
Required Output:
server01:5454 --> online
server02:5454 --> online
server03:5454 --> online
python json python-2.7
asked Mar 9 at 0:54
sqlcheckpointsqlcheckpoint
353520
add a comment |
Below is the sample json document or json variable I have. I'm using python for extracting the required fields as mentioned int the output section.
Can someone help on how to do this?
json_variable =
"server01":
"address":"server01:5454",
"options": ,
"state":"online"
,
"server02":
"address":"server02:5454",
"options": ,
"state":"online"
,
"server03":
"address":"server03:5454",
"options": ,
"state":"online"
for x in json_variable:
print(x["address"])
Error:
Traceback (most recent call last):
File "<string>", line 30, in <module>
File "<string>", line 18, in getServerStatus
TypeError: 'shell.Dict' object is not iterable
I can get the required output by hard coding the fields as below, but i would like to do it dynamically as the number of servers vary depending upon the system queried and json returned.
print(json_variable["server01"]["address"])
print(json_variable["server02"]["address"])
print(json_variable["server03"]["address"])
Required Output:
server01:5454 --> online
server02:5454 --> online
server03:5454 --> online
python json python-2.7
asked Mar 9 at 0:54
sqlcheckpointsqlcheckpoint
353520
To do this generically, you're going to have to at least hardcode the patterns to look for so the code has a clue as to what you're interested in retrieving. Not sure why you seem to think it needs to be done recursively, however.
– martineau
Mar 9 at 1:00
2
What have you tried so far?
– Klaus D.
Mar 9 at 1:00
1
for server in json_variable.values(): print(f"server['address'] --> server['status']")
– Jab
Mar 9 at 1:02
@KlausD. I added the code that I tried.
– sqlcheckpoint
Mar 9 at 1:17
add a comment |
Below is the sample json document or json variable I have. I'm using python for extracting the required fields as mentioned int the output section.
Can someone help on how to do this?
json_variable =
"server01":
"address":"server01:5454",
"options": ,
"state":"online"
,
"server02":
"address":"server02:5454",
"options": ,
"state":"online"
,
"server03":
"address":"server03:5454",
"options": ,
"state":"online"
for x in json_variable:
print(x["address"])
Error:
Traceback (most recent call last):
File "<string>", line 30, in <module>
File "<string>", line 18, in getServerStatus
TypeError: 'shell.Dict' object is not iterable
I can get the required output by hard coding the fields as below, but i would like to do it dynamically as the number of servers vary depending upon the system queried and json returned.
print(json_variable["server01"]["address"])
print(json_variable["server02"]["address"])
print(json_variable["server03"]["address"])
Required Output:
server01:5454 --> online
server02:5454 --> online
server03:5454 --> online
python json python-2.7
asked Mar 9 at 0:54
sqlcheckpointsqlcheckpoint
353520
Below is the sample json document or json variable I have. I'm using python for extracting the required fields as mentioned int the output section.
Can someone help on how to do this?
json_variable =
"server01":
"address":"server01:5454",
"options": ,
"state":"online"
,
"server02":
"address":"server02:5454",
"options": ,
"state":"online"
,
"server03":
"address":"server03:5454",
"options": ,
"state":"online"
for x in json_variable:
print(x["address"])
Error:
Traceback (most recent call last):
File "<string>", line 30, in <module>
File "<string>", line 18, in getServerStatus
TypeError: 'shell.Dict' object is not iterable
I can get the required output by hard coding the fields as below, but i would like to do it dynamically as the number of servers vary depending upon the system queried and json returned.
print(json_variable["server01"]["address"])
print(json_variable["server02"]["address"])
print(json_variable["server03"]["address"])
Required Output:
server01:5454 --> online
server02:5454 --> online
server03:5454 --> online
python json python-2.7
python json python-2.7
asked Mar 9 at 0:54
sqlcheckpointsqlcheckpoint
353520
asked Mar 9 at 0:54
sqlcheckpointsqlcheckpoint
353520
edited Mar 9 at 4:18
sqlcheckpoint
asked Mar 9 at 0:54
sqlcheckpointsqlcheckpoint
353520
asked Mar 9 at 0:54
sqlcheckpointsqlcheckpoint
353520
asked Mar 9 at 0:54
sqlcheckpointsqlcheckpoint
353520
353520
To do this generically, you're going to have to at least hardcode the patterns to look for so the code has a clue as to what you're interested in retrieving. Not sure why you seem to think it needs to be done recursively, however.
– martineau
Mar 9 at 1:00
2
What have you tried so far?
– Klaus D.
Mar 9 at 1:00
1
for server in json_variable.values(): print(f"server['address'] --> server['status']")
– Jab
Mar 9 at 1:02
@KlausD. I added the code that I tried.
– sqlcheckpoint
Mar 9 at 1:17
add a comment |
To do this generically, you're going to have to at least hardcode the patterns to look for so the code has a clue as to what you're interested in retrieving. Not sure why you seem to think it needs to be done recursively, however.
– martineau
Mar 9 at 1:00
2
What have you tried so far?
– Klaus D.
Mar 9 at 1:00
1
for server in json_variable.values(): print(f"server['address'] --> server['status']")
– Jab
Mar 9 at 1:02
@KlausD. I added the code that I tried.
– sqlcheckpoint
Mar 9 at 1:17
To do this generically, you're going to have to at least hardcode the patterns to look for so the code has a clue as to what you're interested in retrieving. Not sure why you seem to think it needs to be done recursively, however.
– martineau
Mar 9 at 1:00
To do this generically, you're going to have to at least hardcode the patterns to look for so the code has a clue as to what you're interested in retrieving. Not sure why you seem to think it needs to be done recursively, however.
– martineau
Mar 9 at 1:00
2
2
What have you tried so far?
– Klaus D.
Mar 9 at 1:00
What have you tried so far?
– Klaus D.
Mar 9 at 1:00
1
1
for server in json_variable.values(): print(f"server['address'] --> server['status']")– Jab
Mar 9 at 1:02
for server in json_variable.values(): print(f"server['address'] --> server['status']")– Jab
Mar 9 at 1:02
@KlausD. I added the code that I tried.
– sqlcheckpoint
Mar 9 at 1:17
@KlausD. I added the code that I tried.
– sqlcheckpoint
Mar 9 at 1:17
add a comment |
2 Answers
2
active
oldest
votes
Here's another way to get the server status from the JSON.
json_info =
"server01":
"address":"server01:5454",
"options": ,
"state":"online"
,
"server02":
"address":"server02:5454",
"options": ,
"state":"online"
,
"server03":
"address":"server03:5454",
"options": ,
"state":"online"
for server in json_info.values():
server_status = server['state']
if 'online' in server_status:
server_name = server.get('address')
print (' is online'.format(server_name.split(':')[0]))
# output
# server01 is online
# server02 is online
# server03 is online
#
# print (' --> online'.format(server_name))
# output
# server01:5454 --> online
# server02:5454 --> online
# server03:5454 --> online
else:
server_name = server.get('address')
print(' is offline'.format(server_name.split(':')[0]))
answered Mar 9 at 2:14
Life is complexLife is complex
809518
add a comment |
Treat it as a dictionary:
for k, v in sample.items():
print(v['address'] + "-->" + v['state'])
answered Mar 9 at 2:05
S. WangS. Wang
112
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55072939%2fhow-to-extract-specific-fields-recursively-from-json-output%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
Here's another way to get the server status from the JSON.
json_info =
"server01":
"address":"server01:5454",
"options": ,
"state":"online"
,
"server02":
"address":"server02:5454",
"options": ,
"state":"online"
,
"server03":
"address":"server03:5454",
"options": ,
"state":"online"
for server in json_info.values():
server_status = server['state']
if 'online' in server_status:
server_name = server.get('address')
print (' is online'.format(server_name.split(':')[0]))
# output
# server01 is online
# server02 is online
# server03 is online
#
# print (' --> online'.format(server_name))
# output
# server01:5454 --> online
# server02:5454 --> online
# server03:5454 --> online
else:
server_name = server.get('address')
print(' is offline'.format(server_name.split(':')[0]))
answered Mar 9 at 2:14
Life is complexLife is complex
809518
add a comment |
Here's another way to get the server status from the JSON.
json_info =
"server01":
"address":"server01:5454",
"options": ,
"state":"online"
,
"server02":
"address":"server02:5454",
"options": ,
"state":"online"
,
"server03":
"address":"server03:5454",
"options": ,
"state":"online"
for server in json_info.values():
server_status = server['state']
if 'online' in server_status:
server_name = server.get('address')
print (' is online'.format(server_name.split(':')[0]))
# output
# server01 is online
# server02 is online
# server03 is online
#
# print (' --> online'.format(server_name))
# output
# server01:5454 --> online
# server02:5454 --> online
# server03:5454 --> online
else:
server_name = server.get('address')
print(' is offline'.format(server_name.split(':')[0]))
answered Mar 9 at 2:14
Life is complexLife is complex
809518
add a comment |
Here's another way to get the server status from the JSON.
json_info =
"server01":
"address":"server01:5454",
"options": ,
"state":"online"
,
"server02":
"address":"server02:5454",
"options": ,
"state":"online"
,
"server03":
"address":"server03:5454",
"options": ,
"state":"online"
for server in json_info.values():
server_status = server['state']
if 'online' in server_status:
server_name = server.get('address')
print (' is online'.format(server_name.split(':')[0]))
# output
# server01 is online
# server02 is online
# server03 is online
#
# print (' --> online'.format(server_name))
# output
# server01:5454 --> online
# server02:5454 --> online
# server03:5454 --> online
else:
server_name = server.get('address')
print(' is offline'.format(server_name.split(':')[0]))
answered Mar 9 at 2:14
Life is complexLife is complex
809518
Here's another way to get the server status from the JSON.
json_info =
"server01":
"address":"server01:5454",
"options": ,
"state":"online"
,
"server02":
"address":"server02:5454",
"options": ,
"state":"online"
,
"server03":
"address":"server03:5454",
"options": ,
"state":"online"
for server in json_info.values():
server_status = server['state']
if 'online' in server_status:
server_name = server.get('address')
print (' is online'.format(server_name.split(':')[0]))
# output
# server01 is online
# server02 is online
# server03 is online
#
# print (' --> online'.format(server_name))
# output
# server01:5454 --> online
# server02:5454 --> online
# server03:5454 --> online
else:
server_name = server.get('address')
print(' is offline'.format(server_name.split(':')[0]))
answered Mar 9 at 2:14
Life is complexLife is complex
809518
edited Mar 9 at 2:44
answered Mar 9 at 2:14
Life is complexLife is complex
809518
answered Mar 9 at 2:14
Life is complexLife is complex
809518
answered Mar 9 at 2:14
Life is complexLife is complex
809518
809518
add a comment |
add a comment |
Treat it as a dictionary:
for k, v in sample.items():
print(v['address'] + "-->" + v['state'])
answered Mar 9 at 2:05
S. WangS. Wang
112
add a comment |
Treat it as a dictionary:
for k, v in sample.items():
print(v['address'] + "-->" + v['state'])
answered Mar 9 at 2:05
S. WangS. Wang
112
add a comment |
Treat it as a dictionary:
for k, v in sample.items():
print(v['address'] + "-->" + v['state'])
answered Mar 9 at 2:05
S. WangS. Wang
112
Treat it as a dictionary:
for k, v in sample.items():
print(v['address'] + "-->" + v['state'])
answered Mar 9 at 2:05
S. WangS. Wang
112
answered Mar 9 at 2:05
S. WangS. Wang
112
answered Mar 9 at 2:05
S. WangS. Wang
112
answered Mar 9 at 2:05
S. WangS. Wang
112
112
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55072939%2fhow-to-extract-specific-fields-recursively-from-json-output%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
To do this generically, you're going to have to at least hardcode the patterns to look for so the code has a clue as to what you're interested in retrieving. Not sure why you seem to think it needs to be done recursively, however.
– martineau
Mar 9 at 1:00
2
What have you tried so far?
– Klaus D.
Mar 9 at 1:00
1
for server in json_variable.values(): print(f"server['address'] --> server['status']")– Jab
Mar 9 at 1:02
@KlausD. I added the code that I tried.
– sqlcheckpoint
Mar 9 at 1:17