How to extract specific fields recursively from json output?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?
Are astronomers waiting to see something in an image from a gravitational lens that they've already seen in an adjacent image?
Unable to deploy metadata from Partner Developer scratch org because of extra fields
What's the point of deactivating Num Lock on login screens?
Rock identification in KY
Can I make popcorn with any corn?
What defenses are there against being summoned by the Gate spell?
Theorems that impeded progress
Malformed Address '10.10.21.08/24', must be X.X.X.X/NN or
Languages that we cannot (dis)prove to be Context-Free
How can I make my BBEG immortal short of making them a Lich or Vampire?
High voltage LED indicator 40-1000 VDC without additional power supply
Is it legal for company to use my work email to pretend I still work there?
Why is Minecraft giving an OpenGL error?
Modeling an IP Address
Was any UN Security Council vote triple-vetoed?
How much RAM could one put in a typical 80386 setup?
Does an object always see its latest internal state irrespective of thread?
Does detail obscure or enhance action?
What are these boxed doors outside store fronts in New York?
Do infinite dimensional systems make sense?
Doing something right before you need it - expression for this?
A newer friend of my brother's gave him a load of baseball cards that are supposedly extremely valuable. Is this a scam?
Why does Kotter return in Welcome Back Kotter?
Paid for article while in US on F-1 visa?
How to extract specific fields recursively from json output?
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
351520
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
351520
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
351520
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
351520
asked Mar 9 at 0:54
sqlcheckpointsqlcheckpoint
351520
edited Mar 9 at 4:18
sqlcheckpoint
asked Mar 9 at 0:54
sqlcheckpointsqlcheckpoint
351520
asked Mar 9 at 0:54
sqlcheckpointsqlcheckpoint
351520
asked Mar 9 at 0:54
sqlcheckpointsqlcheckpoint
351520
351520
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
731518
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
731518
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
731518
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
731518
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
731518
edited Mar 9 at 2:44
answered Mar 9 at 2:14
Life is complexLife is complex
731518
answered Mar 9 at 2:14
Life is complexLife is complex
731518
answered Mar 9 at 2:14
Life is complexLife is complex
731518
731518
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