Forum Discussion

Raisa's avatar
Raisa
Occasional Contributor
9 years ago
Solved

Transfer response data

  Hi, Could you please help me with not trivial transfering data from response. I have a response with a lot of fields with the same name. for instance "$[x].CardProxyNumber" where x- number of e...
  • rupert_anderson's avatar
    rupert_anderson
    9 years ago

    Hi,

     

    Ok - how about this:

     

     

    def response ='''[{
"CardIssueCde": 3,
"CardLast4Digits": "0660",
"CardProxyNumber": "1100124371170660",
"CardStatusCode": 0,
"DependentId": "DepId",
"EmployeeId": "phase4001",
"FirstName": "first name",
"LastName": "last name",
"MailedDate": " ",
"MiddleInitial": "T",
"NamePrefix": ""
},
{
"CardIssueCde": 3,
"CardLast4Digits": "0678",
"CardProxyNumber": "1100124371180678",
"CardStatusCode": 1,
"DependentId": "DepId123",
"EmployeeId": "phase4001",
"FirstName": "first name",
"LastName": "last name",
"MailedDate": " ",
"MiddleInitial": "T",
"NamePrefix": ""
}]'''

import static com.jayway.jsonpath.JsonPath.parse

def selectedCardProxyNumber = parse(response).read('$..[?(@.CardStatusCode == 1)].CardProxyNumber')
log.info selectedCardProxyNumber[0]

    Notes:

     

    • Uses built in JsonPath library
    • The JsonPath expression should select ALL CardProxyNumber objects values (into an array) for objects that have a CardStatusCode=1
    • It will select CardProxyNumbermore than one if more than 1 object exists with CardStatusCode=1, so in the example I have taken the first element of the array.

    Regards,

    Rup

     

Raisa's avatar
Raisa
Occasional Contributor

Hi, thank for response!

Here is the part of my json sample:

[...{

"CardIssueCde": 3,
"CardLast4Digits": "0660",
"CardProxyNumber": "1100124371170660",
"CardStatusCode": 1,
"DependentId": "DepId",
"EmployeeId": "phase4001",
"FirstName": "first name",
"LastName": "last name",
"MailedDate": " ",
"MiddleInitial": "T",
"NamePrefix": ""
},
{
"CardIssueCde": 3,
"CardLast4Digits": "0678",
"CardProxyNumber": "1100124371180678",
"CardStatusCode": 1,
"DependentId": "DepId123",
"EmployeeId": "phase4001",
"FirstName": "first name",
"LastName": "last name",
"MailedDate": " ",
"MiddleInitial": "T",
"NamePrefix": ""

}..]

Raisa's avatar
Raisa
Occasional Contributor
9 years ago

So, all I need to transfer CardProxyNumber, but only for card with CardStatusCode=1;

  • rupert_anderson's avatar
    rupert_anderson
    Valued Contributor
    9 years ago

    Hi,

     

    Ok - how about this:

     

     

    def response ='''[{
"CardIssueCde": 3,
"CardLast4Digits": "0660",
"CardProxyNumber": "1100124371170660",
"CardStatusCode": 0,
"DependentId": "DepId",
"EmployeeId": "phase4001",
"FirstName": "first name",
"LastName": "last name",
"MailedDate": " ",
"MiddleInitial": "T",
"NamePrefix": ""
},
{
"CardIssueCde": 3,
"CardLast4Digits": "0678",
"CardProxyNumber": "1100124371180678",
"CardStatusCode": 1,
"DependentId": "DepId123",
"EmployeeId": "phase4001",
"FirstName": "first name",
"LastName": "last name",
"MailedDate": " ",
"MiddleInitial": "T",
"NamePrefix": ""
}]'''

import static com.jayway.jsonpath.JsonPath.parse

def selectedCardProxyNumber = parse(response).read('$..[?(@.CardStatusCode == 1)].CardProxyNumber')
log.info selectedCardProxyNumber[0]

    Notes:

     

    • Uses built in JsonPath library
    • The JsonPath expression should select ALL CardProxyNumber objects values (into an array) for objects that have a CardStatusCode=1
    • It will select CardProxyNumbermore than one if more than 1 object exists with CardStatusCode=1, so in the example I have taken the first element of the array.

    Regards,

    Rup

     

    • rupert_anderson's avatar
      rupert_anderson
      Valued Contributor
      9 years ago

      Thanks for the kudos :-)

       

      Did this solve your problem? If so please mark the post as resolved to help others or if not let me know if I can help?

       

      Thanks,

      Rup

      • Raisa's avatar
        Raisa
        Occasional Contributor
        9 years ago

         

        Thank you Rupert!

        That was really helpful!