Mixing
jmesPath query lookup help. Is this query right?
I have this JSON object:
{
id: {
name: "BBCommercialPropertyStructureFloodCoverage",
},
carrierData: null,
link: [
{
key: "Location",
select: {
key: "ARRAY_INDEX",
value: 0,
},
},
{
key: "structure",
select: {
key: "ARRAY_INDEX",
value: 1,
},
},
{
key: "Coverage",
select: {
key: "ARRAY_INDEX",
value: 0,
},
},
],
},
I have several of these objects with different index values. For example, if I want to match on this id/name: "BBCommercialPropertyStructureFloodCoverage" and also that the location is value 0 and the structure is value 1, how do I do this using jmespath?
I have this so far:
const floodCoverageQuery = [?id.name=='BBCommercialPropertyStructureFloodCoverage' && link[key=='Location' && select.value==0]] && link[key=="structure" && select.value==1]]
Is this right?
jmespath
asked Nov 19 '18 at 16:58
Jwan622
2,99342767
add a comment |
I have this JSON object:
{
id: {
name: "BBCommercialPropertyStructureFloodCoverage",
},
carrierData: null,
link: [
{
key: "Location",
select: {
key: "ARRAY_INDEX",
value: 0,
},
},
{
key: "structure",
select: {
key: "ARRAY_INDEX",
value: 1,
},
},
{
key: "Coverage",
select: {
key: "ARRAY_INDEX",
value: 0,
},
},
],
},
I have several of these objects with different index values. For example, if I want to match on this id/name: "BBCommercialPropertyStructureFloodCoverage" and also that the location is value 0 and the structure is value 1, how do I do this using jmespath?
I have this so far:
const floodCoverageQuery = [?id.name=='BBCommercialPropertyStructureFloodCoverage' && link[key=='Location' && select.value==0]] && link[key=="structure" && select.value==1]]
Is this right?
jmespath
asked Nov 19 '18 at 16:58
Jwan622
2,99342767
add a comment |
I have this JSON object:
{
id: {
name: "BBCommercialPropertyStructureFloodCoverage",
},
carrierData: null,
link: [
{
key: "Location",
select: {
key: "ARRAY_INDEX",
value: 0,
},
},
{
key: "structure",
select: {
key: "ARRAY_INDEX",
value: 1,
},
},
{
key: "Coverage",
select: {
key: "ARRAY_INDEX",
value: 0,
},
},
],
},
I have several of these objects with different index values. For example, if I want to match on this id/name: "BBCommercialPropertyStructureFloodCoverage" and also that the location is value 0 and the structure is value 1, how do I do this using jmespath?
I have this so far:
const floodCoverageQuery = [?id.name=='BBCommercialPropertyStructureFloodCoverage' && link[key=='Location' && select.value==0]] && link[key=="structure" && select.value==1]]
Is this right?
jmespath
asked Nov 19 '18 at 16:58
Jwan622
2,99342767
I have this JSON object:
{
id: {
name: "BBCommercialPropertyStructureFloodCoverage",
},
carrierData: null,
link: [
{
key: "Location",
select: {
key: "ARRAY_INDEX",
value: 0,
},
},
{
key: "structure",
select: {
key: "ARRAY_INDEX",
value: 1,
},
},
{
key: "Coverage",
select: {
key: "ARRAY_INDEX",
value: 0,
},
},
],
},
I have several of these objects with different index values. For example, if I want to match on this id/name: "BBCommercialPropertyStructureFloodCoverage" and also that the location is value 0 and the structure is value 1, how do I do this using jmespath?
I have this so far:
const floodCoverageQuery = [?id.name=='BBCommercialPropertyStructureFloodCoverage' && link[key=='Location' && select.value==0]] && link[key=="structure" && select.value==1]]
Is this right?
jmespath
jmespath
asked Nov 19 '18 at 16:58
Jwan622
2,99342767
asked Nov 19 '18 at 16:58
Jwan622
2,99342767
edited Nov 19 '18 at 18:59
asked Nov 19 '18 at 16:58
Jwan622
2,99342767
asked Nov 19 '18 at 16:58
Jwan622
2,99342767
asked Nov 19 '18 at 16:58
Jwan622
2,99342767
2,99342767
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
First of all, the object tree you put in your answer is not true JSON. I've converted it, see below. Also, I suppose the object needs to be wrapped in a list ([...]) because you say ”I have several of these objects“; and the code you have so far starts with [?..., which indicates you've got a list.
answer
this should work, I've tested it on jmespath.org:
[?id.name=='BBCommercialPropertyStructureFloodCoverage' && link[?key=='Location' && select.value==`0`] && link[?key=='structure' && select.value==`1`]]
what was wrong with your solution?
Your original query was this:
[?id.name=='BBCommercialPropertyStructureFloodCoverage' && link[key=='Location' && select.value==0]] && link[key=="structure" && select.value==1]]
This is what I had discovered:
- There are too many closing brackets (
]). So==0]] &&should be==0] &&(one bracket less). - You've mixed single and double quotes (
'and"). Only single quotes are valid raw string literals. (Alteratively, you could write`"string"`, which is equivalent to'string'.) - Wrap integer values (0 and 1) inside backticks (
`0`and`1`), see literal expressions. - The inner brackets, where you check
keyandselect.value, are filter expressions, so you need to wrap them inside[?and]instead of just[...].
FTR, the actual input as JSON
[
{
"id": {
"name": "BBCommercialPropertyStructureFloodCoverage"
},
"carrierData": null,
"link": [
{
"key": "Location",
"select": {
"key": "ARRAY_INDEX",
"value": 0
}
},
{
"key": "structure",
"select": {
"key": "ARRAY_INDEX",
"value": 1
}
},
{
"key": "Coverage",
"select": {
"key": "ARRAY_INDEX",
"value": 0
}
}
]
}
]
answered Dec 8 '18 at 15:41
myrdd
708614
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%2f53379400%2fjmespath-query-lookup-help-is-this-query-right%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
First of all, the object tree you put in your answer is not true JSON. I've converted it, see below. Also, I suppose the object needs to be wrapped in a list ([...]) because you say ”I have several of these objects“; and the code you have so far starts with [?..., which indicates you've got a list.
answer
this should work, I've tested it on jmespath.org:
[?id.name=='BBCommercialPropertyStructureFloodCoverage' && link[?key=='Location' && select.value==`0`] && link[?key=='structure' && select.value==`1`]]
what was wrong with your solution?
Your original query was this:
[?id.name=='BBCommercialPropertyStructureFloodCoverage' && link[key=='Location' && select.value==0]] && link[key=="structure" && select.value==1]]
This is what I had discovered:
- There are too many closing brackets (
]). So==0]] &&should be==0] &&(one bracket less). - You've mixed single and double quotes (
'and"). Only single quotes are valid raw string literals. (Alteratively, you could write`"string"`, which is equivalent to'string'.) - Wrap integer values (0 and 1) inside backticks (
`0`and`1`), see literal expressions. - The inner brackets, where you check
keyandselect.value, are filter expressions, so you need to wrap them inside[?and]instead of just[...].
FTR, the actual input as JSON
[
{
"id": {
"name": "BBCommercialPropertyStructureFloodCoverage"
},
"carrierData": null,
"link": [
{
"key": "Location",
"select": {
"key": "ARRAY_INDEX",
"value": 0
}
},
{
"key": "structure",
"select": {
"key": "ARRAY_INDEX",
"value": 1
}
},
{
"key": "Coverage",
"select": {
"key": "ARRAY_INDEX",
"value": 0
}
}
]
}
]
answered Dec 8 '18 at 15:41
myrdd
708614
add a comment |
First of all, the object tree you put in your answer is not true JSON. I've converted it, see below. Also, I suppose the object needs to be wrapped in a list ([...]) because you say ”I have several of these objects“; and the code you have so far starts with [?..., which indicates you've got a list.
answer
this should work, I've tested it on jmespath.org:
[?id.name=='BBCommercialPropertyStructureFloodCoverage' && link[?key=='Location' && select.value==`0`] && link[?key=='structure' && select.value==`1`]]
what was wrong with your solution?
Your original query was this:
[?id.name=='BBCommercialPropertyStructureFloodCoverage' && link[key=='Location' && select.value==0]] && link[key=="structure" && select.value==1]]
This is what I had discovered:
- There are too many closing brackets (
]). So==0]] &&should be==0] &&(one bracket less). - You've mixed single and double quotes (
'and"). Only single quotes are valid raw string literals. (Alteratively, you could write`"string"`, which is equivalent to'string'.) - Wrap integer values (0 and 1) inside backticks (
`0`and`1`), see literal expressions. - The inner brackets, where you check
keyandselect.value, are filter expressions, so you need to wrap them inside[?and]instead of just[...].
FTR, the actual input as JSON
[
{
"id": {
"name": "BBCommercialPropertyStructureFloodCoverage"
},
"carrierData": null,
"link": [
{
"key": "Location",
"select": {
"key": "ARRAY_INDEX",
"value": 0
}
},
{
"key": "structure",
"select": {
"key": "ARRAY_INDEX",
"value": 1
}
},
{
"key": "Coverage",
"select": {
"key": "ARRAY_INDEX",
"value": 0
}
}
]
}
]
answered Dec 8 '18 at 15:41
myrdd
708614
add a comment |
First of all, the object tree you put in your answer is not true JSON. I've converted it, see below. Also, I suppose the object needs to be wrapped in a list ([...]) because you say ”I have several of these objects“; and the code you have so far starts with [?..., which indicates you've got a list.
answer
this should work, I've tested it on jmespath.org:
[?id.name=='BBCommercialPropertyStructureFloodCoverage' && link[?key=='Location' && select.value==`0`] && link[?key=='structure' && select.value==`1`]]
what was wrong with your solution?
Your original query was this:
[?id.name=='BBCommercialPropertyStructureFloodCoverage' && link[key=='Location' && select.value==0]] && link[key=="structure" && select.value==1]]
This is what I had discovered:
- There are too many closing brackets (
]). So==0]] &&should be==0] &&(one bracket less). - You've mixed single and double quotes (
'and"). Only single quotes are valid raw string literals. (Alteratively, you could write`"string"`, which is equivalent to'string'.) - Wrap integer values (0 and 1) inside backticks (
`0`and`1`), see literal expressions. - The inner brackets, where you check
keyandselect.value, are filter expressions, so you need to wrap them inside[?and]instead of just[...].
FTR, the actual input as JSON
[
{
"id": {
"name": "BBCommercialPropertyStructureFloodCoverage"
},
"carrierData": null,
"link": [
{
"key": "Location",
"select": {
"key": "ARRAY_INDEX",
"value": 0
}
},
{
"key": "structure",
"select": {
"key": "ARRAY_INDEX",
"value": 1
}
},
{
"key": "Coverage",
"select": {
"key": "ARRAY_INDEX",
"value": 0
}
}
]
}
]
answered Dec 8 '18 at 15:41
myrdd
708614
First of all, the object tree you put in your answer is not true JSON. I've converted it, see below. Also, I suppose the object needs to be wrapped in a list ([...]) because you say ”I have several of these objects“; and the code you have so far starts with [?..., which indicates you've got a list.
answer
this should work, I've tested it on jmespath.org:
[?id.name=='BBCommercialPropertyStructureFloodCoverage' && link[?key=='Location' && select.value==`0`] && link[?key=='structure' && select.value==`1`]]
what was wrong with your solution?
Your original query was this:
[?id.name=='BBCommercialPropertyStructureFloodCoverage' && link[key=='Location' && select.value==0]] && link[key=="structure" && select.value==1]]
This is what I had discovered:
- There are too many closing brackets (
]). So==0]] &&should be==0] &&(one bracket less). - You've mixed single and double quotes (
'and"). Only single quotes are valid raw string literals. (Alteratively, you could write`"string"`, which is equivalent to'string'.) - Wrap integer values (0 and 1) inside backticks (
`0`and`1`), see literal expressions. - The inner brackets, where you check
keyandselect.value, are filter expressions, so you need to wrap them inside[?and]instead of just[...].
FTR, the actual input as JSON
[
{
"id": {
"name": "BBCommercialPropertyStructureFloodCoverage"
},
"carrierData": null,
"link": [
{
"key": "Location",
"select": {
"key": "ARRAY_INDEX",
"value": 0
}
},
{
"key": "structure",
"select": {
"key": "ARRAY_INDEX",
"value": 1
}
},
{
"key": "Coverage",
"select": {
"key": "ARRAY_INDEX",
"value": 0
}
}
]
}
]
answered Dec 8 '18 at 15:41
myrdd
708614
answered Dec 8 '18 at 15:41
myrdd
708614
answered Dec 8 '18 at 15:41
myrdd
708614
answered Dec 8 '18 at 15:41
myrdd
708614
708614
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.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- 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%2f53379400%2fjmespath-query-lookup-help-is-this-query-right%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
