Service Virtualization

Expand all | Collapse all

Validating json response values against excel sheet values

  • 1.  Validating json response values against excel sheet values

    Posted Sep 26, 2017 01:36 PM

    # monika 

     

    Devtest 8.2 Automation 

    I have a requirement where i need to compare  the below JSON response values and the values in an excel sheet 

     

    The below mentioned values are defined in an excel sheet 

     

    Have filtered using below json path and its returning in json array. How do i compare the values returned in json response and excel sheet . pls let me know

     

    Tried with couple of assertions , but its checking for only the first value

     

    $.entitlements[*].actionName to  actionName

    [

      "REQUEST_MSISDN_BLOCK",

      "CHANGE_RATE_PLAN",

      "UPDATE_CUSTOMER_PIN",

      "VIEW_LOS_SOFTGOODS",

      "DELETE_LOS",

      "GET_CUSTOMER_INFO",

      "UPDATE_CUSTOMER_COMM_PREFERENCES",

      "UPDATE_LOS_FAN_NICKNAMES",

      "GET_RATE_PLAN_HISTORY",

      "UPDATE_PRIMARY_LINE_ASSIGNMENT",

      "ACTIVITY_ACCOUNT_OWNER",

      "REQUEST_REFUND",

      "REQUEST_MISSING_PAYMENT",

      "CREATE_AUTOPAY",

      "UPDATE_AUTOPAY",

      "CANCEL_AUTOPAY",

      "VIEW_AUTOPAY",

      "MANAGE_STORED_PAYMENT_METHODS",

      "UPDATE_ADDRESS",

      "ACCESS_WEB_PROFILE",

      "VIEW_SUBSCRIBER_ACCOUNT_ACTIVITY",

      "VIEW_ORDER_HISTORY",

      "VIEW_SESSION_PASS_HISTORY",

      "IMMEDIATE_DOWNGRADE",

      "SEND_DEVICE_UNLOCK_CODE",

      "VIEW_DEVICE_UNLOCK_CODE",

      "RETRIEVE_PUK_CODE",

      "BYPASS_PROMOTION_RESTRICTIONS",

      "OVERRIDE_DEFAULT_RATEPLAN_CHANGE_DATE",

      "RESTORE_SUSPENDED_LOS",

      "MANAGE_LOS_PARTY_ROLES",

      "MSISDN_CHANGE",

      "CREATE_SCORE_UPGRADE",

      "PURCHASE_SESSION_PASSES",

      "VIEW_ORDER_RECEIPT",

      "CREATE_PORT_IN",

      "MODIFY_LOS_FEATURES",

      "UPDATE_FAN_BILLCYCLE",

      "REMOVE_IMEI_FROM_BLACKLIST",

      "MANAGE_BLOCKING_ROAMING",

      "ADD_IMEI_TO_BLACKLIST"

    ]



  • 2.  Re: Validating json response values against excel sheet values
    Best Answer

    Broadcom Employee
    Posted Sep 26, 2017 04:42 PM

    Hi,

     

    You can apply an indexer to the JSON path such as:

     

    actionName[0]

    actionName[1]

    etc.

     

    --Mike