Can a Katalon test call another Katalon test that uses variables from an excel file?

Miscellaneous
13

In case that the “Data-driven testing” feature of Katalon Studio does not fulfill your requirement, you need to invent a solution how to manage the data of “Persons” for your self.

If I were to make a Test Case that inserts data record during a run, and want let other Test Cases to use the updated data set, I would design my test as follows.

  1. I will make a GlobalVariable named GlobalVariable.Persons of type List<Map<String, String>>
  2. I will manually make a JSON file like
[
  {
    "GENERATED ID": "1871703", "LAST NAME": "Excel05", "FIRST NAME": "MOM", "DOB": "12/15/80", "GENDER":"F", "ROW ID": "1"
  },
  {
    "GENERATED ID": ....
  },
...
  1. On startup, my test script will read the JSON file; parse the JSON; convert it into the GlobalVariable.Persons.
  2. My test script will work on the GlobalVariable.Persons (add/modify/delete Person records). My test script will NOT serialize the variable into file during the processing.
  3. The other Test Cases will refer the GlobalVariable.Persons as needed. These scripts can refer to the updates into the GlobalVariable.Persons by other Test Cases. Thse script do not read/write the external file. No need to make I/O to the file during the processing.
  4. On closing, my test script will serialize the GlobalVariable.Persons into a JSON text, and write it into an external file. The file might be the same one as the script read in on the starup; or it could be a new one.

Your code should refer to a GlobalVariable of type List<Map<String,String>> to share the data while you keep full accessiblity (add/modify/delete) to the data set.

Excel or JSON — the format of the file as external persistence is not really important. Either will do. Up to your preference.

If you want to read and write a Excel file in Katalon Test Case. So please refer to the following post