Combining JSON elements using JsonPath (JayWay)

Question

Given a basic json structure:

{ "Keys": [
  {"Format": "A", "Subtype": "A1"},
  {"Format": "A",  "Subtype": "A2"},
  {"Format": "B",  "Subtype": "A1"}]
}

I am looking to create a new output by combining the Format and Subtype values using JsonPath expressions (excluding Java specific code):

 AA1
 AA2
 BA1

Is it achievable to merge string components with jsonPath?

Appreciate your help!

Answer 1

Answer №1

If you run the code snippet below, you will get the output AA1:

$.concat($.Keys[0].Format,$.Keys[0].Subtype)

In a similar fashion, these codes will produce the following results:

$.concat($.Keys[1].Format,$.Keys[1].Subtype) -- AA2
$.concat($.Keys[2].Format,$.Keys[2].Subtype) -- BA1

Answer 2

If you run the code snippet below, you will get the output AA1:

$.concat($.Keys[0].Format,$.Keys[0].Subtype)

In a similar fashion, these codes will produce the following results:

$.concat($.Keys[1].Format,$.Keys[1].Subtype) -- AA2
$.concat($.Keys[2].Format,$.Keys[2].Subtype) -- BA1

Answer 3

Although this post is from some time ago, I am currently looking for comparable issues. Could this be the answer?

  $.Keys[0].Style$.Keys[0].Category
  $.Keys[1].Style$.Keys[1].Category
  $.Keys[2].Style$.Keys[2].Category

Answer 4

Although this post is from some time ago, I am currently looking for comparable issues. Could this be the answer?

  $.Keys[0].Style$.Keys[0].Category
  $.Keys[1].Style$.Keys[1].Category
  $.Keys[2].Style$.Keys[2].Category

Answer 5

To construct JSON path expressions, you can use the following format:

$.Items[0].Type -- X
$.Items[1].Type -- Y
$.Items[2].Type -- Z

For more information on using JSONPath in Java, you can visit this SO thread.

Answer 6

To construct JSON path expressions, you can use the following format:

$.Items[0].Type -- X
$.Items[1].Type -- Y
$.Items[2].Type -- Z

For more information on using JSONPath in Java, you can visit this SO thread.