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

Popular posts from this blog

ios - MKAnnotationView layer is not of expected type: MKLayer -

ZeroMQ on Windows, with Qt Creator -

unity3d - Unity SceneManager.LoadScene quits application -