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.
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
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.
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 ??
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.
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
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.
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
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
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
@@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 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 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?
![F.HERO Ft. JSPKK x ลำไย ไหทองคำ x M-PEE - ไม่สนิทบิดหมด (Thai Riders Anthem) [Official MV]](http://i.ytimg.com/vi/kPJZ0UihBfk/mqdefault.jpg)
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.
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
Raghav, your videos are very helpful and detailed.Thanks.
You're welcome Dub.
This is gold! thanks Raghav!
Humbled to know this Jorge
Shukriyaa!
most welcome
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)
I will check on this
Waiting for your valuable video on this.. thanks in advance!!
Hey Raghav!! Hope you are doing well..
Just wanted to let you know that your students are still waiting for this😊
@@RaghavPal did you get any chance to look into it? It's been a blocker for me. You are the ray of hope.
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.
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 ??
Hi Jagadeesh, can check this forum.katalon.com/t/justify-a-json-schema-validator-in-katalon-studio/25560
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.
Hi Kamaraju, yes you can
Hi Raghav, where can we write Pre-Request scripts in Katalon like we do in Postman??
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
@@RaghavPal tried, working as expected, thanks raghav.
Hi Gud Mng,
With Katalone is it possible ,copy data from Excel and past on web browser,like application form filling and submit
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.
Hi Raghav, is it possible to write data to excel . Example : capturing data from response API and storing that value to excel
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
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?
Hi Asllie, not exactly, will plan. You can find all tutorials here - automationstepbystep.com/
Automation Step by Step - Raghav Pal thank you for the response.. hoping you will create tutorial soon thanks
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
Hi Alberto, yes, this will help you - forum.katalon.com/t/random-select-value-from-data-file/12299/7
@@RaghavPal Thanks mate
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?
Hi Klob, where exactly you got error, what are the details/logs
Hi Raghav, how to do katalon API testing using upload files.
Hi Pratheep, there is a keyword File Upload. Pls try
Hi Raghav, can you please create the same video for POST request wherein the payload has to read the data from excel
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.
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
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
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
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
Hi Raghav, Could you please create a video on using Robot class in Katalon.
I will check and plan for it Avishek
@@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.
Hi Avishek, will check on this and plan a session
@@RaghavPal Much Thanks!
Hi Raghav, how can i pass the excel data in variable's
Yes we can Trilok
@@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?
the data is taken one by one based on rows
@@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?
There are some options on how to select the row. Pls check
Hi Raghav, the video is stuck at one screen for the entire time. Could you please remake the video. Thanks.
Hi Venkatesh, I just checked, its working fine. Might be some network issue at the time you checked. Pls try again.