Extract nested element value from JSON object using JMESPath

Question

I am trying to extract and transform elements from a JSON document using JMESPath. Here is my test JSON array:

const search = jmespath.search;
const testData =
{
"ServiceAccount": [
    {
        "Type": "WIDGET",
        "ID": [
            {
                "OrderNum": "12345",
                "OrderTyp": "ABDCD"
            }
        ]
      }
    ]
};

I am trying to extract the value of the OrderNum key using the following JMESPath expression, but it returns null. Here is my search expression:

const result = search(testData, 'ServiceAccount.ID.OrderNum');
console.log(result);

Why is this not working?

BJT · Accepted Answer · 2018-08-08 06:37:00Z

2

const testData =
{
"ServiceAccount": [
    {
        "Type": "WIDGET",
        "ID": [
            {
                "OrderNum": "12345",
                "OrderTyp": "ABDCD"
            }
        ]
      }
    ]
};

const result = jmespath.search(testData, 'ServiceAccount[].ID[].OrderNum');
console.log(result);

edited Aug 8, 2018 at 6:37

answered Aug 6, 2018 at 21:06

BJT

6585 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

DanielAttard Over a year ago

Thanks @josip. Yes, your suggestion worked. I did not appreciate the significance of the square brackets. My sample testData represents only a small portion of a much larger JSON object that contains lots of square brackets.

DanielAttard Over a year ago

Hi @josip - Do you know if it is a problem to use square brackets with JMESPath? Your solution involved removing the square brackets, but this renders my JSON object invalid.

BJT Over a year ago

@DanielAttard no it is not problem, i should not modify your example data, i took too little time to inspect the problem, my bad, i fixed my answer, now it works with your data structure. Regards.

Collectives™ on Stack Overflow

Extract nested element value from JSON object using JMESPath

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related