Forum Discussion

nkasemsan's avatar
nkasemsan
Occasional Contributor
8 years ago

jsonpathRetrieve array element in an array from JSON response

Hi All,   I'm trying to retrieve an array element within an array (sample response attached) from a test step in a test case.   Within this response, I want to retrieve an array of Telecoms values ...
  • PaulMS's avatar
    PaulMS
    8 years ago

    The result of JSONPath expression $..Telecoms[?(@.SystemCode=='phone')].ValueString has more than 25 elements because there are different use codes.  Do you want to filter only mobile or home phone numbers?

     

    $..Telecoms[?(@.SystemCode=='phone') && @.UseCode=='mobile')].ValueString

     

    If the use code for the first element doesn't matter then

    $..Telecoms[?(@.SystemCode=='phone')][0].ValueString

PaulMS's avatar
PaulMS
Super Contributor

The result of JSONPath expression $..Telecoms[?(@.SystemCode=='phone')].ValueString has more than 25 elements because there are different use codes.  Do you want to filter only mobile or home phone numbers?

 

$..Telecoms[?(@.SystemCode=='phone') && @.UseCode=='mobile')].ValueString

 

If the use code for the first element doesn't matter then

$..Telecoms[?(@.SystemCode=='phone')][0].ValueString

nkasemsan's avatar
nkasemsan
Occasional Contributor
8 years ago

That was my problem.  I'm now getting the first phone number.  I will eventually need to create a step to filter by phone type so this will be very helpful. Thank you!