Using excel value for insert query from Katalon to database

API Testing
,
1

Hi anyone can help me how to use excel row and column value for insert query from katalon so that I would able to see my data in database

So far I have hardcode the value for insert query below:-

String insert query = (‘Insert into document (Document_Id,App_ref_no) values ('567D','12345)’

CustomKeywords.‘com.database.database.execute’(insert query).

Appericate if someone can help me with this solution.

Thank you.

2

You can check these docs for some ideas:

3

Hi Chen.lee i am not using anying enterprise version.

I understand that we can set variable in katalon to parameterize it.

Example i have more value to input i would prefer to use excel to link the value with my insert query value.