jmesPath query lookup help. Is this query right?
up vote
0
down vote
favorite
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
add a comment |
up vote
0
down vote
favorite
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
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
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
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
edited Nov 19 at 18:59
asked Nov 19 at 16:58
Jwan622
2,95042766
2,95042766
add a comment |
add a comment |
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
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