Extract data from json file throush “powershell” command
I am trying to get data from my json file but my code is still not working. Do you have any suggestion ?
JSON file :
"nodes": [
{
"id": "elfe",
"apps": [
{
"id": "man1",
"age" = "5"
"power" ="strenght"
},
{
"id": "man2",
"age" = "10"
"power" ="strenght"
}],
"id": "monster",
"apps": [
{
"id": "man3",
"age" = "5"
"power" ="strenght"
},
{
"id": "man4",
"age" = "10"
"power" ="strenght"
}],
And there, my code in PowerShell. I just want to get man1, man2, man3, man4 values in my file for each id elfe and monster like that :
man1
man2
in one file and in the other file:
man3
man4
My batch script :
Powershell -Nop -C "(Get-Content .config.json |ConvertFrom-Json).Nodes | Select-Object -ExpandProperty id | Where-Object id -eq elfe" >> file.txt
EDIT : I can't modify my JSON file...
json powershell
asked Nov 25 '18 at 0:42
joemilerjoemiler
93
add a comment |
I am trying to get data from my json file but my code is still not working. Do you have any suggestion ?
JSON file :
"nodes": [
{
"id": "elfe",
"apps": [
{
"id": "man1",
"age" = "5"
"power" ="strenght"
},
{
"id": "man2",
"age" = "10"
"power" ="strenght"
}],
"id": "monster",
"apps": [
{
"id": "man3",
"age" = "5"
"power" ="strenght"
},
{
"id": "man4",
"age" = "10"
"power" ="strenght"
}],
And there, my code in PowerShell. I just want to get man1, man2, man3, man4 values in my file for each id elfe and monster like that :
man1
man2
in one file and in the other file:
man3
man4
My batch script :
Powershell -Nop -C "(Get-Content .config.json |ConvertFrom-Json).Nodes | Select-Object -ExpandProperty id | Where-Object id -eq elfe" >> file.txt
EDIT : I can't modify my JSON file...
json powershell
asked Nov 25 '18 at 0:42
joemilerjoemiler
93
when i try to use your sample withConvertFrom-JSON, i get the following error =ConvertFrom-Json : Invalid JSON primitive: [. have you tested the file to see if it is actually valid?
– Lee_Dailey
Nov 25 '18 at 1:54
add a comment |
I am trying to get data from my json file but my code is still not working. Do you have any suggestion ?
JSON file :
"nodes": [
{
"id": "elfe",
"apps": [
{
"id": "man1",
"age" = "5"
"power" ="strenght"
},
{
"id": "man2",
"age" = "10"
"power" ="strenght"
}],
"id": "monster",
"apps": [
{
"id": "man3",
"age" = "5"
"power" ="strenght"
},
{
"id": "man4",
"age" = "10"
"power" ="strenght"
}],
And there, my code in PowerShell. I just want to get man1, man2, man3, man4 values in my file for each id elfe and monster like that :
man1
man2
in one file and in the other file:
man3
man4
My batch script :
Powershell -Nop -C "(Get-Content .config.json |ConvertFrom-Json).Nodes | Select-Object -ExpandProperty id | Where-Object id -eq elfe" >> file.txt
EDIT : I can't modify my JSON file...
json powershell
asked Nov 25 '18 at 0:42
joemilerjoemiler
93
I am trying to get data from my json file but my code is still not working. Do you have any suggestion ?
JSON file :
"nodes": [
{
"id": "elfe",
"apps": [
{
"id": "man1",
"age" = "5"
"power" ="strenght"
},
{
"id": "man2",
"age" = "10"
"power" ="strenght"
}],
"id": "monster",
"apps": [
{
"id": "man3",
"age" = "5"
"power" ="strenght"
},
{
"id": "man4",
"age" = "10"
"power" ="strenght"
}],
And there, my code in PowerShell. I just want to get man1, man2, man3, man4 values in my file for each id elfe and monster like that :
man1
man2
in one file and in the other file:
man3
man4
My batch script :
Powershell -Nop -C "(Get-Content .config.json |ConvertFrom-Json).Nodes | Select-Object -ExpandProperty id | Where-Object id -eq elfe" >> file.txt
EDIT : I can't modify my JSON file...
json powershell
json powershell
asked Nov 25 '18 at 0:42
joemilerjoemiler
93
asked Nov 25 '18 at 0:42
joemilerjoemiler
93
edited Nov 25 '18 at 17:42
joemiler
asked Nov 25 '18 at 0:42
joemilerjoemiler
93
asked Nov 25 '18 at 0:42
joemilerjoemiler
93
asked Nov 25 '18 at 0:42
joemilerjoemiler
93
93
when i try to use your sample withConvertFrom-JSON, i get the following error =ConvertFrom-Json : Invalid JSON primitive: [. have you tested the file to see if it is actually valid?
– Lee_Dailey
Nov 25 '18 at 1:54
add a comment |
when i try to use your sample withConvertFrom-JSON, i get the following error =ConvertFrom-Json : Invalid JSON primitive: [. have you tested the file to see if it is actually valid?
– Lee_Dailey
Nov 25 '18 at 1:54
when i try to use your sample with
ConvertFrom-JSON, i get the following error = ConvertFrom-Json : Invalid JSON primitive: [. have you tested the file to see if it is actually valid?– Lee_Dailey
Nov 25 '18 at 1:54
when i try to use your sample with
ConvertFrom-JSON, i get the following error = ConvertFrom-Json : Invalid JSON primitive: [. have you tested the file to see if it is actually valid?– Lee_Dailey
Nov 25 '18 at 1:54
add a comment |
1 Answer
1
active
oldest
votes
Your json is not valid, below is corrected version with data extraction:
$json = @"
{
"nodes":[
{
"id":"elfe",
"apps":[
{
"id":"man1",
"age":5,
"power":"strenght"
},
{
"id":"man2",
"age":10,
"power":"strenght"
}]},
{ "id":"monster",
"apps":[
{
"id":"man3",
"age" :"5",
"power":"strenght"
},
{
"id":"man4",
"age":"10",
"power":"strenght"
}]}
]}
"@
$data = $json | ConvertFrom-Json
$data.nodes | where {$_.id -eq "elfe"} | foreach {$_.apps.id >> "elfe.txt"}
But probably you just had troubles with quoting that command. Below is a working version. I replaced >> with tee - it will overwrite output file and also prints results on the screen.
powershell -nop -c "(cat test.json | ConvertFrom-Json).nodes | where {$_.id -eq 'elfe'} | foreach {$_.apps.id} | tee out.txt"
answered Nov 25 '18 at 2:18
Mike TwcMike Twc
1,1361312
ok thans for your answer ! is it possible to have the same result with using : Powershell -Nop -C "(Get-Content .config.json | where {$_.id -eq "elfe"} | foreach {$_apps.id} >> "elfe.txt" ?
– joemiler
Nov 25 '18 at 13:38
updated my answer
– Mike Twc
Nov 25 '18 at 19:16
Thank you very much !
– joemiler
Nov 25 '18 at 20:37
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%2f53463715%2fextract-data-from-json-file-throush-powershell-command%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Your json is not valid, below is corrected version with data extraction:
$json = @"
{
"nodes":[
{
"id":"elfe",
"apps":[
{
"id":"man1",
"age":5,
"power":"strenght"
},
{
"id":"man2",
"age":10,
"power":"strenght"
}]},
{ "id":"monster",
"apps":[
{
"id":"man3",
"age" :"5",
"power":"strenght"
},
{
"id":"man4",
"age":"10",
"power":"strenght"
}]}
]}
"@
$data = $json | ConvertFrom-Json
$data.nodes | where {$_.id -eq "elfe"} | foreach {$_.apps.id >> "elfe.txt"}
But probably you just had troubles with quoting that command. Below is a working version. I replaced >> with tee - it will overwrite output file and also prints results on the screen.
powershell -nop -c "(cat test.json | ConvertFrom-Json).nodes | where {$_.id -eq 'elfe'} | foreach {$_.apps.id} | tee out.txt"
answered Nov 25 '18 at 2:18
Mike TwcMike Twc
1,1361312
ok thans for your answer ! is it possible to have the same result with using : Powershell -Nop -C "(Get-Content .config.json | where {$_.id -eq "elfe"} | foreach {$_apps.id} >> "elfe.txt" ?
– joemiler
Nov 25 '18 at 13:38
updated my answer
– Mike Twc
Nov 25 '18 at 19:16
Thank you very much !
– joemiler
Nov 25 '18 at 20:37
add a comment |
Your json is not valid, below is corrected version with data extraction:
$json = @"
{
"nodes":[
{
"id":"elfe",
"apps":[
{
"id":"man1",
"age":5,
"power":"strenght"
},
{
"id":"man2",
"age":10,
"power":"strenght"
}]},
{ "id":"monster",
"apps":[
{
"id":"man3",
"age" :"5",
"power":"strenght"
},
{
"id":"man4",
"age":"10",
"power":"strenght"
}]}
]}
"@
$data = $json | ConvertFrom-Json
$data.nodes | where {$_.id -eq "elfe"} | foreach {$_.apps.id >> "elfe.txt"}
But probably you just had troubles with quoting that command. Below is a working version. I replaced >> with tee - it will overwrite output file and also prints results on the screen.
powershell -nop -c "(cat test.json | ConvertFrom-Json).nodes | where {$_.id -eq 'elfe'} | foreach {$_.apps.id} | tee out.txt"
answered Nov 25 '18 at 2:18
Mike TwcMike Twc
1,1361312
ok thans for your answer ! is it possible to have the same result with using : Powershell -Nop -C "(Get-Content .config.json | where {$_.id -eq "elfe"} | foreach {$_apps.id} >> "elfe.txt" ?
– joemiler
Nov 25 '18 at 13:38
updated my answer
– Mike Twc
Nov 25 '18 at 19:16
Thank you very much !
– joemiler
Nov 25 '18 at 20:37
add a comment |
Your json is not valid, below is corrected version with data extraction:
$json = @"
{
"nodes":[
{
"id":"elfe",
"apps":[
{
"id":"man1",
"age":5,
"power":"strenght"
},
{
"id":"man2",
"age":10,
"power":"strenght"
}]},
{ "id":"monster",
"apps":[
{
"id":"man3",
"age" :"5",
"power":"strenght"
},
{
"id":"man4",
"age":"10",
"power":"strenght"
}]}
]}
"@
$data = $json | ConvertFrom-Json
$data.nodes | where {$_.id -eq "elfe"} | foreach {$_.apps.id >> "elfe.txt"}
But probably you just had troubles with quoting that command. Below is a working version. I replaced >> with tee - it will overwrite output file and also prints results on the screen.
powershell -nop -c "(cat test.json | ConvertFrom-Json).nodes | where {$_.id -eq 'elfe'} | foreach {$_.apps.id} | tee out.txt"
answered Nov 25 '18 at 2:18
Mike TwcMike Twc
1,1361312
Your json is not valid, below is corrected version with data extraction:
$json = @"
{
"nodes":[
{
"id":"elfe",
"apps":[
{
"id":"man1",
"age":5,
"power":"strenght"
},
{
"id":"man2",
"age":10,
"power":"strenght"
}]},
{ "id":"monster",
"apps":[
{
"id":"man3",
"age" :"5",
"power":"strenght"
},
{
"id":"man4",
"age":"10",
"power":"strenght"
}]}
]}
"@
$data = $json | ConvertFrom-Json
$data.nodes | where {$_.id -eq "elfe"} | foreach {$_.apps.id >> "elfe.txt"}
But probably you just had troubles with quoting that command. Below is a working version. I replaced >> with tee - it will overwrite output file and also prints results on the screen.
powershell -nop -c "(cat test.json | ConvertFrom-Json).nodes | where {$_.id -eq 'elfe'} | foreach {$_.apps.id} | tee out.txt"
answered Nov 25 '18 at 2:18
Mike TwcMike Twc
1,1361312
edited Nov 25 '18 at 19:15
answered Nov 25 '18 at 2:18
Mike TwcMike Twc
1,1361312
answered Nov 25 '18 at 2:18
Mike TwcMike Twc
1,1361312
answered Nov 25 '18 at 2:18
Mike TwcMike Twc
1,1361312
1,1361312
ok thans for your answer ! is it possible to have the same result with using : Powershell -Nop -C "(Get-Content .config.json | where {$_.id -eq "elfe"} | foreach {$_apps.id} >> "elfe.txt" ?
– joemiler
Nov 25 '18 at 13:38
updated my answer
– Mike Twc
Nov 25 '18 at 19:16
Thank you very much !
– joemiler
Nov 25 '18 at 20:37
add a comment |
ok thans for your answer ! is it possible to have the same result with using : Powershell -Nop -C "(Get-Content .config.json | where {$_.id -eq "elfe"} | foreach {$_apps.id} >> "elfe.txt" ?
– joemiler
Nov 25 '18 at 13:38
updated my answer
– Mike Twc
Nov 25 '18 at 19:16
Thank you very much !
– joemiler
Nov 25 '18 at 20:37
ok thans for your answer ! is it possible to have the same result with using : Powershell -Nop -C "(Get-Content .config.json | where {$_.id -eq "elfe"} | foreach {$_apps.id} >> "elfe.txt" ?
– joemiler
Nov 25 '18 at 13:38
ok thans for your answer ! is it possible to have the same result with using : Powershell -Nop -C "(Get-Content .config.json | where {$_.id -eq "elfe"} | foreach {$_apps.id} >> "elfe.txt" ?
– joemiler
Nov 25 '18 at 13:38
updated my answer
– Mike Twc
Nov 25 '18 at 19:16
updated my answer
– Mike Twc
Nov 25 '18 at 19:16
Thank you very much !
– joemiler
Nov 25 '18 at 20:37
Thank you very much !
– joemiler
Nov 25 '18 at 20:37
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%2f53463715%2fextract-data-from-json-file-throush-powershell-command%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
when i try to use your sample with
ConvertFrom-JSON, i get the following error =ConvertFrom-Json : Invalid JSON primitive: [. have you tested the file to see if it is actually valid?– Lee_Dailey
Nov 25 '18 at 1:54