Add Excel column: StoreResponseVariables Add values as "completeResponse=." this will store the api response in the completeResponse variable. Can store all API response JSON as well in the variable. Reference project with example: #apitesting #restapi #bdd #idaithalam #agiletesting

{ "category": { "id": 200, "name": "Bulldog \r\n Testing \r\n again" }, "id": 201, "name": "Rocky", "photoUrls": [ "string" ], "status": "available", "tags": [ { "id": 201, "name": "red" } ] } In the Excel column StoreResponseVariables. Add semicolon separated key and value pair. like varName=name;varId=id; varTagName=tags[0].name; 3. Following api context varNAme will have "Rocky" and varId will have "201" and varTagName will have value as "red" Reference Project with Example: https://github.com/virtualansoftware/microservices-lowcode-testautomation/tree/main/rest-post #apitesting #restapi #bdd #idaithalam #agiletesting

Risk API response is 65. How can I validate API actual response 1. Add Excel column ResponseContent 2. Set value in the cell as 65. 3. Actual API response returns as 65. 4. Will see the success now. Reference project with Example: https://github.com/virtualansoftware/microservices-lowcode-testautomation/tree/main/rest-post #apitesting #restapi #bdd #idaithalam #agiletesting #insprintautomation

Set Excel column and value would be with Excel column: SchemaValidation value: pets_json.schema.json=true 1. Key should be the pets_json.schema.json file and should be present in the class path 2. value should either true or false. It is true means strict validation and false would be little relaxed Reference project: https://github.com/virtualansoftware/microservices-lowcode-testautomation/tree/main/rest-get #apitesting #restapi #bdd #idaithalam #agiletesting

Reference project: https://github.com/virtualansoftware/microservices-lowcode-testautomation/tree/main/rest-get Example API response: { "category": { "id": 200, "name": "Bulldog" }, "id": 201, "name": "Rocky", "photoUrls": [ "dog1.png" ], "status": "available", "tags": [ { "id": 201, "name": "red" } ] } Excel Column: ResponseByFields Csvson Need: Helps to compare specific fields Helps to compare multiple fields using using Json path comma separated json How: Validate status and name under tags Validate id, name, status Example: status=available;tags[0].name=red; id,name,status, i~201,Rockey,available #idaithalam #apitesting #apiresponse #agiletesing #openapi

You need to update the Excel based on new changes if required and Need to regenerate the VIRTUALAN Collection/Feature file which will track the changes in GIT Repo as well.

Using comma separated JSON(CSVSON), JSON PATH, EXCEL FUNCTION and JSON Object. Add your JSON expected response in the ResponseContent column. It helps to perform contract testing as well. Add all key and value with comma separated values under the ResponseByFields column in the excel. Idaithalam will validate specific fields in the response using key value pairs. Key is your JsonPath and values is Expected value.id=[petId];name=[petName]; <json-path>=<value> Compare the API response with given CSV. CSV would be converted as JSON and compared with the Actual Response. Add following entry in the Csvson column Example: |ppu,name,toppings,id,type | |d~0.55,Cake,i~5001\|i~2001\|,0001,donut |

Using EXCEL FUNCTION. You can build assertion using Excel functions using EvaluateFunctionVariables column Evaluate the variable created during workflow execution. This will help generate the dynamic variable and values. This execute command using pure EXCEL functions. I have added couple of Date functionality to define values dynamically. This will create variables with evaluated function. Any excel functions can be evaluated during runtime(which script execution) with BDD script. Of course this will support/evaluate dynamic variables and value needs in IDAITHALAM Example: 1. startDate=TEXT(TODAY(),"yyyy-mm-dd") #today date - String type 2. expiryDate=SUBSTITUTE(TEXT(NOW()+365, "yyyy-mm-dd HH:\mm:ss"), " ", "T") #future date with yyyy-mm-ddTHH:\mm:ss format 3. success=c~LEN("[firstname]")=3 # will verify if the firstname only 3 character then will succeed 4. fail=c~LEN("[firstname]")=3 # will verify if the firstname only 3 character then will fail 5. length=i~LEN("[firstname]") # will create Interger variable with value 6. isMatch=b~LEN("[firstname]")=3 # will create boolean variable with value 7. lenghtInDecimals=d~LEN("[lenght]")=3 # will create decimal variable with value

You can store generated VIRTUALAN Collection(JSON test script) or Generated feature file in the GIT repository. This will help track changes in the excel as well how many test cases are added or deleted(DELTA Change in the Excel).

a. Any type of user can develop test scripts. - Non technical user - Manual testers - Subject matter Experts - Test engineers b. Excel can be used only for creating test scripts during test script development. c. Use Excel to create Virtualan Collection( a.k.a. Test Scripts). d. You can execute Virtualan Collection directly in CI/CD PIPELINE in the PROD mode.

Idaithalam is a low code Test automation Framework, developed using Java and Cucumber. It leverages Behavior Driven Development (BDD). Tester can create test cases/scripts in simple Excel with API Spec. Excel is a simplified way to create Json based test scripts in Idaithalam. Test cases can be created quickly and tested in minutes. As a tester, you need to create Excel and pass it to Idaithalam Framework. First, generate the Json based test scripts(Virtualan Collection) from Excel. During test execution, this test script collection can be directly utilized. Then it generates Feature files from the Virtualan Collection and its executed. Lastly, It generates test report in BDD/Cucumber style. This provide complete testing support for REST APIs, GraphQL, RDBMS DB and Kafka Event messages #idaithalam #apitesting #testautomation #restapitesting #insprintautomation #rdbmstesting #graphqltesting #kafkamessagetesting #eventvalidation #messagevalidation #cucumber #bdd

Share your thoughts. Feel free to add GIFs, videos, #hashtags and more to your posts and comments. Get started by commenting below.

Creator of #Idaithalam Just a little intro about me! Passionate software craftsman and had developed complete suite of products.. ✳️ Service Virtualization - Virtualan(Open API Driven Service Virtualization, Kafka, SOAP, KAFKA, AMQ and IBMMQ Mocking Product) and ✳️ Test automation products ✅ Idaithalam(Low code Test Automation for API, KAFKA and DB with Cucumber BDD) ✅ Cucumblan (Predefined Step definition for API, KAFKA and DB with Cucumber BDD) These suites helps to test Microservices (Api, DB, and Kafka Events) in a minutes To make life easier and works with full potential. Product information: https://www.virtualan.io Framework information: https://tutorials.virtualan.io Follow on Twitter: https://twitter.com/VirtualanS Follow on LinkedIn: https://www.linkedin.com/company/virtualan-software

We want everyone to get the most out of this community, so we ask that you please read and follow these guidelines: Respect each other Keep posts relevant to the forum topic No spamming