Katalon Studio API Testing 13 | Extracting data from JSON responses and chaining requests

[@pratheepkumar4218]

Hi Raghav, in list user how to filter all the Id value. We have a scenario like list pending company to activate using I'd dynamic way.

[@RaghavPal]

Hi Pratheep, you can store the id in variables and use it later

[@dhanushkodiraj6153]

How to handle arraylist in the Request body? I have a json request something like { "Data": { "ItemsList": [ "value1", "value2","value3", "value4"], "DateTime":"datetimevalue" } } I am trying to check invalid and empty values in Itemslist array. On using Globalvariable.ItemsList, its printing me [value1, value2,value3,value4] If I pass Globalvariable.ItemsList in the script of SendRequest, i am getting 400 error, invalid request params

[@RaghavPal]

Hi Dhanushkodi , Try to print and check if the data is getting referred properly from Global Variables

[@shakuntalan6398]

Please help with how to add multiple API requests combined in single requests in Python. and to run through postman

[@RaghavPal]

I will check on this Shakuntala

[@albertopelaezrivera3853]

How can I parameterize default value in Request Body to take it from another stored variable? Thanks

[@RaghavPal]

Hi Alberto, not sure if I understood your scenario, but you should be able to follow the same steps and syntax (as shown in the video) for parameterizing any value in your request. Where did you face the issue

[@albertopelaezrivera3853]

@@RaghavPal I can explain you what I'm doing. I am automating a CRUD. But my intention is to update and delete the same thing I created for not creating trash in my DB. I need to do this without any manual action. JsonSlurper slurper = new JsonSlurper() Map parsedJson = slurper.parseText(serviceResponse.responseBodyContent) String brandId = parsedJson.id GlobalVariable.brandId = brandId I used this code to equal my created "Id" to a GlobalVariable in order to set it as a variable in my update request body, but I don't know if it's good to use a Global variable, or if it would be better to use a local or a private.

[@RaghavPal]

If you want to refer this value in some other test case or other location, you will have to store in GlobalVariables

[@albertopelaezrivera3853]

@@RaghavPal Thanks Raghav, your videos helped me to finish my CRUD automation.

[@test-jx7gj]

Is there a way to get and parse the JSON response as variable in another test case. I have a test case which sends the text message, the message should be a Json value. Please advise

[@RaghavPal]

Hi do you want to store complete json msg in a variable, can do programatically

[@BIRDSCAMPBD]

How to get Advance course directly from you?

[@RaghavPal]

Hi, Can check all courses here - automationstepbystep.com/

[@kushalpanchal5571]

Hi Raghav, Can we parameterize the HTTP Body Payload by using Internal Test Data in Katalon Studion

[@RaghavPal]

Yes you can Kushal, just parameterize the data using variables. Add your request in a test case and then add test case in a test suite. In test suite you can refer data file as shown here kzbin.info/www/bejne/qqaYi5ZubtxppbM

[@aalokmayekar7214]

Hi, is there any way to get the count of first_name?

[@RaghavPal]

Hi Aalok, you should be able to. Check this docs.katalon.com/katalon-studio/docs/ws-verify-elements-count.html#example

[@rizwan3564]

How to validate the json schema in katalon?

[@RaghavPal]

Hi Rizwan, this will help forum.katalon.com/t/justify-a-json-schema-validator-in-katalon-studio/25560

[@anu017]

Hi Rahav, Thank you very much for your video's. They are really helping a lot. I have one question regarding json sluper. I have written code to connect to so many API's(From Azure Devops) in for loop and get the content and update them in Excel. Actually my code was working perfectly some times. But some times I am getting an error. " Test Cases/Creating Traceability/Traceability Matrix Epic-Test Result FAILED. Reason: groovy.json.JsonException: Unable to determine the current character, it is not a string, number, array, or object The current character read is '

[@RaghavPal]

Hi Anuradha, seems there is some character in your response body. Just check the line it is pointing to, May have to get some online help

[@bongtv3670]

Can I extract the value and put it in an excel file?

[@RaghavPal]

You can, will have to use a custom script

[@Jerson0702]

Hi there, thanks! This helped me a lot! Another question, what if you want to extract multiple instances?

[@RaghavPal]

You can use the same process of using JSON path to extract and store values.

[@Jerson0702]

@@RaghavPal Oh ok, thanks a lot!

[@notch7751]

Thanks once again :) this helped a lot

[@RaghavPal]

You're welcome Notshe

[@lawsonconner1611]

I guess it is pretty off topic but does anyone know a good site to stream new tv shows online ?

[@melvinvan3799]

@Lawson Conner I use FlixZone. You can find it by googling =)

[@emilioangelo4753]

@Melvin Van Definitely, been watching on FlixZone for months myself :D

[@lawsonconner1611]

@Melvin Van thank you, I signed up and it seems like a nice service :D I appreciate it!!

[@xsimplyellex]

thank you!!! needed this

[@RaghavPal]

Happy to know

[@jayeshdalal7]

Hi Raghav, Can i use this technique with below cases. case -1 Header let suppose -API1 response is token. and this token is header of API2 . can we parametrized this header like body ? or we need to hardcode that header? case-2 in API endpoint let suppose API is account-staging.abc.com/user/account/email/ here after email some email id like [e-mail] (this is not parameter) it is look like account-staging.abc.com/user/account/email/[e-mail]? can we do parameterized ? need some suggestion Thanks, jayesh

[@jayeshdalal7]

I found the way to solve case -1 but regarding case -2 (path variable i am unable to find any hint)

[@RaghavPal]

Hi Jayesh, I checked, you should be able to use the same way for parameterizing url. For e.g. This is my api endpoint thomas-bayer.com/sqlrest Now I want to parameterize the last part sqlrest So I go to variables tab in api request and add a variable url and provide its value and then use in endpoint like thomas-bayer.com/${url} In the variables section you can also refer the value from global variable

[@anasswelam9574]

i don't understand groovy code ?!

[@RaghavPal]

Hi Anas, you can learn Groovy from here - automationstepbystep.com/

[@ilmroshni5925]

make a playlist

[@RaghavPal]

Hi Roshni, its here - kzbin.info/aero/PLhW3qG5bs-L-yy1HtdxKcp-blmG5qeWgg