Test data from external data source like Excel or SQL server

Archive
,
1

Hi All

Looking for any simple code snippet to read the data from an external data source like excel and post to API endpoint.

Basically, we need to create 1000’s resource by calling API endpoint. We are automating the data creating a task for volume testing.

Any code reference help.

2

Hello Rams,
there is extensive library of examples already written, all you need is to try it:
for data driven testing and how to get data from DB/excel, check this tutorial:


for API specific topics this tutorial is what you are searching for:
https://docs.katalon.com/katalon-studio/tutorials/api-testing/index.html
spacially last part, manual creation of API request
if you run into any problem, just ask with specific informations an detailed description of your problem.

3

These pointers will help me to get started. Thanks Andrej.

4

Hi Rams,

If you want it to be hardcoded then this might help you as well:
https://api-docs.katalon.com/index.html?overview-summary.html

Hope that helps… :slight_smile: