Katalon Studio API Data Driven Testing

Katalon Studio
Sample API Testing Project
Today we will learn
Data Driven Testing
How to get data from excel or csv files
BECOME A MEMBER & GET EXCLUSIVE PERKS
/ @raghavpal
ONLINE COURSES TO LEARN
visit - automationstepbystep.com/
----------- UI TESTING -----------
Selenium Beginners - bit.ly/2MGRS8K
Selenium Java Framework from Scratch - bit.ly/2N9xvR6
Selenium Python - bit.ly/2oyMp5x
Selenium Tips - bit.ly/2owxc50
Selenium Builder - bit.ly/2MKNtlq
Katalon Studio - bit.ly/2wARFdi
Robot Framework - bit.ly/2Px6Ue9
----------- API TESTING -----------
Web Services (API) - bit.ly/2MGafL7
SoapUI - bit.ly/2MGahmd
Postman - bit.ly/2wz8LrW
General - bit.ly/2PYdwmV
----------- MOBILE TESTING -----------
Mobile Playlist - bit.ly/2PxpeUv
----------- CI | CD | DEVOPS -----------
Jenkins Beginner - bit.ly/2MIn8EC
Jenkins Tips & Trick - bit.ly/2LRt6xC
Docker - bit.ly/2MInnzx
----------- VERSION CONTROL SYSTEM -----------
Git & GitHub - bit.ly/2Q1pagY
----------- PERFORMANCE TESTING -----------
JMeter Beginner - bit.ly/2oBbtIU
JMeter Intermediate - bit.ly/2oziNVB
JMeter Advanced - bit.ly/2Q22Y6a
JMeter Tips & Tricks - bit.ly/2NOfWD2
Performance Testing - bit.ly/2wEXbLS
----------- JAVA -----------
Java Beginners - bit.ly/2PVUcXs
Java Tips & Tricks - bit.ly/2CdcDnJ
----------- MAVEN -----------
Maven - bit.ly/2NJdDRS
----------- OTHERS -----------
Redis- bit.ly/2N9jyCG
Misc - bit.ly/2Q2q5xQ
Tools & Tips - bit.ly/2oBfwoR
QnA Friday- bit.ly/2NgwGpw
Sunday Special - bit.ly/2wB23BO
Ask Raghav- bit.ly/2CoJGWf
Interviews - bit.ly/2NIPPxk
All Playlists - bit.ly/2LSiezA
----------- Follow -----------
Facebook - / automationstepbystep
Twitter - / automationsbs
KZbin - / automationstepbystep
_

[@33cute33]

Raghav, your videos are very helpful and detailed.Thanks.

[@RaghavPal]

You're welcome Dub.

[@testingtrail]

This is gold! thanks Raghav!

[@RaghavPal]

Humbled to know this Jorge

[@jagadeeshb5445]

Hi Raghav, Do we have any libraries in Katalon(or outside, that can be imported in Katalon)to validate JSON Response schema like we do in Postman / RestAssured ??

[@RaghavPal]

Hi Jagadeesh, can check this forum.katalon.com/t/justify-a-json-schema-validator-in-katalon-studio/25560

[@ShalomMura]

Hi Gud Mng, With Katalone is it possible ,copy data from Excel and past on web browser,like application form filling and submit

[@RaghavPal]

Hi Abhilash, in your test scripts where you are providing the values, you can refer them from variables, as shown in the video for username and password. and can get these values from excel.

[@keerthibkv8435]

Hi Raghav, is it possible to write data to excel . Example : capturing data from response API and storing that value to excel

[@RaghavPal]

Hi Keerthi, you can do it. Will have to do some scripting for that. docs.katalon.com/katalon-studio/docs/write-data-into-excel-file-at-runtime-during-test-execution.html

[@EdLove]

Shukriyaa!

[@RaghavPal]

most welcome

[@rameshblack]

Hi Raghav, Your videos are very helpful. In this video, you have shown only SOAP API Data Driven Testing. How can we do Data Driven for REST API? Can you please make a video on REST API Data Driven Testing? Thanks for your time.

[@RaghavPal]

Hi Ramesh, I will be creating a session on that soon. Moreover, you can follow a similar approach of creating a variable and then getting the value from excel file

[@albertopelaezrivera3853]

Hi Raghav, I have a doubt. Can we select randomly the data we want to use for data testing instead of testing one by one? Thanks

[@RaghavPal]

Hi Alberto, yes, this will help you - forum.katalon.com/t/random-select-value-from-data-file/12299/7

[@albertopelaezrivera3853]

@@RaghavPal Thanks mate

[@kamarajusahu1318]

Hi Rahul, Can we run 2 testcases in one suite. when I am running every time need to change the sheet name for each testcase.

[@RaghavPal]

Hi Kamaraju, yes you can

[@klobdaya564]

hi Raghav, i found some problem when i want to make automation on filter like on ecommerce website. can you show me how to solve my problem?

[@RaghavPal]

Hi Klob, where exactly you got error, what are the details/logs

[@aslliesablan5848]

Hi Raghav do you have a video tutorial in Katalon studio where we will learn on how to write the POST API Response in excel file?

[@RaghavPal]

Hi Asllie, not exactly, will plan. You can find all tutorials here - automationstepbystep.com/

[@aslliesablan5848]

Automation Step by Step - Raghav Pal thank you for the response.. hoping you will create tutorial soon thanks

[@pratheepkumar4218]

Hi Raghav, how to do katalon API testing using upload files.

[@RaghavPal]

Hi Pratheep, there is a keyword File Upload. Pls try

[@ashm9034]

Hi Raghav, can you please create the same video for POST request wherein the payload has to read the data from excel

[@RaghavPal]

Hi Ash, I will try to do as soon as I get some time. For now, try to follow the same steps by parameterizing data in the body of request as per your need.

[@ashm9034]

Please do it for an API n I tried doing that in an API POST payload by reading values from global variable , but even that's not working. Please come up with a solution for reading data from Excel sheet in an API POST payload n from global variables

[@RaghavPal]

Hi Ash, sure let me try. So basically you need to refer a value in the request body from a global variable? Pls let me know the complete scenario

[@ashm9034]

Hi Raghav, I have an API with POST payload. Now the endpoint for this API is something like this : localhost:9090/rest/customer/customer ID/laptops. 1. The customerID should be read from the Excel sheet or the ID obtained from POST/customer. How can I read this data to be used in my endpoint URL as it's dynamic in nature 2. The payload for POST API for the above mentioned endpoint is to be read from Excel sheet and the payload looks like the following : { CustomerName : "Ash", Address : "Bangalore" } Now these values I want it to be read from the Excel sheet. How can I do that. 3. Is multiple payloading and multiple endpoints can be used at a time for end to end scenario perspective? Kindly answer to the above mentioned scenarios

[@RaghavPal]

Hi Ash, so what have you tried, I see this as follows 1. Create and excel as per your data needs 2. In Katalon Studio. In Data Files folder, create new excel data and refer from your excel. 3. In your test create variables for values that you want to refer from excel. 4. Parameterize the values with variables in your request as shown in video. 5. In TestSuite refer the variables from the excel data added in step 2. Pls try and let me know if you face any issue in this process

[@jagadeeshb5445]

Hi Raghav, where can we write Pre-Request scripts in Katalon like we do in Postman??

[@RaghavPal]

Hi Jagadeesh, within the API editor, there is no option, but you can add it as a step in your test case, before calling the API step

[@jagadeeshb5445]

@@RaghavPal tried, working as expected, thanks raghav.

[@ObhiReads]

Hi Raghav, Could you please create a video on using Robot class in Katalon.

[@RaghavPal]

I will check and plan for it Avishek

[@ObhiReads]

@@RaghavPal As always thank you so much.Will be waiting for it.Using windows I can still manage but actually facing real issues with mac.So checked with you like last time.Thanks for replying.

[@RaghavPal]

Hi Avishek, will check on this and plan a session

[@ObhiReads]

@@RaghavPal Much Thanks!

[@suprasupra132]

Hello Raghav, your videos are really helpful.. thanks a lot. Could you explain how to create video and image data files (for API Automation testing)

[@RaghavPal]

I will check on this

[@suprasupra132]

Waiting for your valuable video on this.. thanks in advance!!

[@suprasupra132]

Hey Raghav!! Hope you are doing well.. Just wanted to let you know that your students are still waiting for this😊

[@suprasupra132]

@@RaghavPal did you get any chance to look into it? It's been a blocker for me. You are the ray of hope.

[@RaghavPal]

Hi Supra, Can check if these steps help you: Record the video or capture the screenshot: Use a screen recording or screenshot tool to capture the video or image you want to use for your API automation testing. Save the video or image: Save the video or image file to your local machine in a format that is compatible with Katalon Studio, such as MP4 or PNG. Add the file to your Katalon Studio project: In your Katalon Studio project, navigate to the location where you want to add the video or image file. Right-click on the location and select "Add" from the context menu. Choose "File" and then select the video or image file you saved in step 2. Use the file in your test case: In your test case script, you can now reference the video or image file using its file path. For example, if you saved the file in a folder called "Test Resources" in your project, you can reference the file like this: TestObject video = findTestObject('Test Resources/video.mp4'). Use the file in your API automation testing: Once you have added the video or image file to your Katalon Studio project and referenced it in your test case script, you can use it as needed in your API automation testing. For example, you could include the video in your test report or use the image in a verification step to confirm that a particular element is present on a page.

[@venkateshkulkarni619]

Hi Raghav, the video is stuck at one screen for the entire time. Could you please remake the video. Thanks.

[@RaghavPal]

Hi Venkatesh, I just checked, its working fine. Might be some network issue at the time you checked. Pls try again.

[@trilokvooka7925]

Hi Raghav, how can i pass the excel data in variable's

[@RaghavPal]

Yes we can Trilok

[@trilokvooka7925]

@@RaghavPal thanks Raghav for reply but I can map the excel data of only one row and one column data, actually I want send the three rows, one row after another like iteration, is it anyway to do like that Raghav?

[@RaghavPal]

the data is taken one by one based on rows

[@trilokvooka7925]

@@RaghavPal sorry Raghav I didn't read properly but when I try row 3 or 4, it's picking only row number 3 not one by one Raghav, this is happened for there is ID in URL , so I need to pass multiple ID's one by one in the URL. Is there any possibility to pass dynamic way Raghav?

[@RaghavPal]

There are some options on how to select the row. Pls check