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?
Did John Wesley plagiarize Matthew Henry...?
What was the last profitable war?
Fit odd number of triplets in a measure?
Found this skink in my tomato plant bucket. Is he trapped? Or could he leave if he wanted?
Plotting a Maclaurin series
.bashrc alias for a command with fixed second parameter
Derived column in a data extension
Is there a verb for listening stealthily?
When does a function NOT have an antiderivative?
Random body shuffle every night—can we still function?
Is the time—manner—place ordering of adverbials an oversimplification?
Why are current probes so expensive?
Statistical analysis applied to methods coming out of Machine Learning
Should man-made satellites feature an intelligent inverted "cow catcher"?
Is it OK to use the testing sample to compare algorithms?
As a dual citizen, my US passport will expire one day after traveling to the US. Will this work?
Why is there so little support for joining EFTA in the British parliament?
Any stored/leased 737s that could substitute for grounded MAXs?
How does the body cool itself in a stillsuit?
Can the Haste spell grant both a Beast Master ranger and their animal companion extra attacks?
By what mechanism was the 2017 UK General Election called?
Is the Mordenkainen's Sword spell underpowered?
Where did Ptolemy compare the Earth to the distance of fixed stars?
How to achieve cat-like agility?
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