I've managed to get the cbe_number and denominations values with the following settings:
Does it suit you?
The expression in the Row Path field is the beginning of the full expression. It's common for properties.
The expression in the Column Paths is the end of the expression.
So, the full expressions will look like:
$['cbe_number'] - for the cbe_number property
$['denominations']['value'] - for the denomination property
View solution in original post
Thanks a lot! It works as a sharm 🙂
But one more question please:
The expression in the Column Paths is the end of the expression."
what do you mean with " of the expression" please? Is this the beginning of the json file? the begin node?
"The Column Path is the end of expression" of the node from where it's reading? I'm a noob in json 😞
Thanks in advance
I'm glad to hear that the provided solution helped!
By the expression, I meant the JSONPath expression, you can read more about it here: https://goessner.net/articles/JsonPath/
In ReadyAPI, the full JSONPath expression is evaluated as:
Row Path + Column Path
BTW, there are some online validators:
Also, there is an example in our documentation which shows how you can work with the JSON DataSource:
I hope this helps.