VERIFY DATA TABLE WS
Description
Verify all values of specified data table with the result of running WS
NOTE: This keyword is used after running [RUN SOAPUI] keyword
– Locator(*): Locator of [tbody] element
– Value 1(*): The name of table contains WS information in ‘Extension’ Sheet
— Value 1.1(*): xpath (xml) / jsonPath (json) is defined in [locator.properties]
— Value 1.2(*): Type of result (STRING/NUMBER/DATE)
— Value 1.3: Format of result
Result with NUMBER format: Number of digits after the decimal point. Ex: With Value 2 = [NUMBER] and Value 3 = [2]. The result will be formatted as X.YY (2 digits after the decimal point)
Result with DATE format: Date format. Ex: MM/dd/yyyy
— Value 1.4: Default value if WS does not return value
— Value 1.5: Order the result (ASC/DESC). Default is ASC
— Value 1.6: Aggregate the result (SUM/AVG/MIN/MAX/COUNT)
— Value 1.7: The name of table in ‘Extension’ Sheet contains specified value list to be removed in the result
Ex: The result = [$2,500.50], the specified value list = [$] and [,]. The final result will be [2500.50]
— Value 1.8: Prefix value – a letter or group of letters added to the beginning of the result
Ex: The result = [25], Value 8 = [$]. The final result will be [$25]
— Value 1.9: Suffix value – a letter or group of letters added to the end of the result
Ex: The result = [25], Value 9 = [ VND]. The final result will be [25 VND]
– Value 2: The index of start column to be verified. Default is the index of first column [1]
– Value 3: The index of end column to be verified. Default is getting the last column
NOTE: The maximum index of end row is the index of end row on per page (It isn’t on all pages)
– Value 4: The index of start row to be verified. Default is the index of first row [1]
– Value 5: The index of end row to be verified. Default is getting the last row
– Value 6: xpath of [Next] button if want to verify data on all pages. If [Value 6] is empty, it will be verified on current page
– Value 7: The stop condition when using [Next] button. It’s the xpath of disabled [Next] button
– Value 8: The name of table in ‘Extension’ Sheet contains specified value list to be removed in the value of each cell
Example