How to use Katalon to insert record into sql database

Question

Hi anyone can guide me on how can I insert record into database by using Katalon. I am able to login database in Katalon using custom keyword.

score 0 · Answer 1 · answered Jul 27 '22 at 05:10

0

try to use groovy string :

insertquery = "INSERT INTO <<TableName>> VALUES ('${email}', '${number}', 'DEV_CH')"

answered Jul 27 '22 at 05:10

Kishan Mevada

Thank Kishan. I have another question. If I need to create a custom keyword for REST API for GET and POST in Katalon so that I will add into the test case to check for the response – user19610349 Jul 27 '22 at 11:55
Hi Kishan how does this multiple insert query work because whenever i run i have met an error – user19610349 Aug 05 '22 at 01:33
can you please show your logcat ? or the error part you are getting !! – Kishan Mevada Aug 05 '22 at 03:57
1

Hi Kishan Mevada I have solve it thank you – user19610349 Aug 06 '22 at 01:05

1 Answers1