Forum Discussion

N78A's avatar
N78A
Contributor
7 years ago

Compare JSON & JDBC response using groovy

I am trying to compare json response with jdbc response. Please find screenshot for the responses. I am using below groovy to compare value by value, but its only picking the latest attribute from js...
JHunt's avatar
JHunt
Community Hero
7 years ago

You say this code is only comparing the date but not the id, but why do you say that? From your screenshot it looks like the end result is an assertion like this:

 

assert ['20170308','20170330'] == ['20170308','20170330']

And then it is not throwing an assertion error... so isn't it already correct?

 

Otherwise, can you explain differently what the problem is?

  • N78A's avatar
    N78A
    Contributor
    7 years ago

    Hi thanks for your response

     

    You are correct, it gives results :

     

    assert ['20170308','20170330'] == ['20170308','20170330']

     

    but it does not display the assertion it has performed for other attribute that is - transaction date. 

     

    so does it mean it is internally validating all the attributes and displaying only the latest in the result ? 

     

     

    I checked it by manually changing the value of ID in JDBC XML , it captures it correctly but still at the time of comparing it only compared date and not ID and passed the step. 

    • nmrao's avatar
      nmrao
      Champion Level 3
      7 years ago
      Would you mind providing both the responses in text format?
      • N78A's avatar
        N78A
        Contributor
        7 years ago

        Hi nmrao,

         

        Thanks for your response. Please find below

         

        JSON Response

         

        {
        "customerId": "1234",
        "yearMonth": "201703",
        "transactions": [
        {
        "transactionId": "C111.158",
        "transactionDate": 20170308,
        "storeId": 1123,
        "marketingName": "ABC Store",
        "storeVisitToCity": "StoreCity",
        "transactionChanel": "In-Store",
        "transactionValue": 566,
        "totalDiscount": -33
        },
        {
        "transactionId": "C123.876",
        "transactionDate": 20170330,
        "storeId": 1111
        "marketingName": "StoreName2",
        "storeVisitToCity": "cityStore",
        "transactionChanel": "In-Store",
        "transactionValue": 117,
        "totalDiscount": 0
        }
        ]
        }

        --------------------------------------------------------

         

        XML JDBC response

         

        <Results>
        <ResultSet fetchSize="10">
        <Row rowNumber="1">
        <TRANSACTION_ID>C111.158</TRANSACTION_ID>
        <TRANSACTION_DATE_KEY>20170309</TRANSACTION_DATE_KEY>
        <TRANSACTION_VALUE>566</TRANSACTION_VALUE>
        <TOTAL_DISCOUNT>-33</TOTAL_DISCOUNT>
        <STORE_ID>1123</STORE_ID>
        <MARKETING_NAME>ABC Store</MARKETING_NAME>
        <VISIT_TO_CITY>StoreCity</VISIT_TO_CITY>
        <TRANSACTION_CHANNEL_DESC>In-Store</TRANSACTION_CHANNEL_DESC>
        </Row>
        <Row rowNumber="2">
        <TRANSACTION_ID>C123.876</TRANSACTION_ID>
        <TRANSACTION_DATE_KEY>20170330</TRANSACTION_DATE_KEY>
        <TRANSACTION_VALUE>117</TRANSACTION_VALUE>
        <TOTAL_DISCOUNT/>
        <STORE_ID>1111</STORE_ID>
        <MARKETING_NAME>StoreName2</MARKETING_NAME>
        <VISIT_TO_CITY>cityStore</VISIT_TO_CITY>
        <TRANSACTION_CHANNEL_DESC>In-Store</TRANSACTION_CHANNEL_DESC>
        </Row>
        </ResultSet>
        </Results>