rest - JSONpath to access a JSON array element by values in multiple sibling array elements -
i have service returns json 2 dimensional list. need find value in second dimension based of values of 2 of elements siblings.
a sublisting of json response looks this:
{ "rows" : [ ["15053518617", "myitemname", "callactivityactivated", "4", "354687456539856756757577547674562234", "callactivity", "2010913-e8345ac7-6c54-4835-933b-3f7ddd2dd777", "b0012345-2017-01-13", "activated", "", "\"null\"" ], ...more rows... ] }
i need access element 7 in array element. but, don't know order in these rows returned. need jsonpath
syntax can use in soapui property transfer identify row combination of 2 other elements in row.
i can access row hard-coded values in particular response with:
$.rows.[0].[7]
this returns:
b0012345-2017-01-13
because can't depend on rows being in same order (unlike first dimension, order of elements in second dimension consistent.)
i need able replace "[0]" query return array offset finding 2 siblings of target value in second dimension:
$.rows.[?([1] == 'myitemname' , [2] == 'callactivityactivated')].[7]
that syntax not work. [null]. have tried many combinations. listing them here add clutter.
can explain how construct necessary jsonpath statement?
Comments
Post a Comment