AnsweredAssumed Answered

Validating json response values against excel sheet values

Question asked by rajeswari.krishnan on Sep 26, 2017
Latest reply on Sep 26, 2017 by Mike_Gavaghan

# 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"

]

Outcomes