Hi,
I am in process of recommending Katalon Studio for the entire enterprise organization of more than 5000 + people. We are in POC stage and checking how Katalon works for API Testing. We are enable to figure out how data from excel is passed as body to API request object ? We have followed the process of 1) Creating object repository 2) Test case is created and use test object created in object repository 3) Create excel file and filled in the request columns and data in excel. 4) In test suite, did mapping of data. 5) Created variables in test cases and mapped the variables with data columns in excel.
Code looks as below. In sendrequest how do we map the data from excel in request body is the question ?
import static com.kms.katalon.core.checkpoint.CheckpointFactory.findCheckpoint
import static com.kms.katalon.core.testcase.TestCaseFactory.findTestCase
import static com.kms.katalon.core.testdata.TestDataFactory.findTestData
import static com.kms.katalon.core.testobject.ObjectRepository.findTestObject
import com.kms.katalon.core.checkpoint.Checkpoint as Checkpoint
import com.kms.katalon.core.checkpoint.CheckpointFactory as CheckpointFactory
import com.kms.katalon.core.mobile.keyword.MobileBuiltInKeywords as MobileBuiltInKeywords
import com.kms.katalon.core.mobile.keyword.MobileBuiltInKeywords as Mobile
import com.kms.katalon.core.model.FailureHandling as FailureHandling
import com.kms.katalon.core.testcase.TestCase as TestCase
import com.kms.katalon.core.testcase.TestCaseFactory as TestCaseFactory
import com.kms.katalon.core.testdata.TestData as TestData
import com.kms.katalon.core.testdata.TestDataFactory as TestDataFactory
import com.kms.katalon.core.testobject.ObjectRepository as ObjectRepository
import com.kms.katalon.core.testobject.TestObject as TestObject
import com.kms.katalon.core.webservice.keyword.WSBuiltInKeywords as WSBuiltInKeywords
import com.kms.katalon.core.webservice.keyword.WSBuiltInKeywords as WS
import com.kms.katalon.core.webui.keyword.WebUiBuiltInKeywords as WebUiBuiltInKeywords
import com.kms.katalon.core.webui.keyword.WebUiBuiltInKeywords as WebUI
import internal.GlobalVariable as GlobalVariable
import groovy.json.JsonSlurper
var1 = WS.sendRequest(findTestObject(‘CreateIssue’)
if (WS.verifyResponseStatusCode(var1, 200)) {
responseText = var1.getResponseText()
def jsonSlurper = new JsonSlurper()
def doc = jsonSlurper.parseText(responseText);
uniqueIdent1 = (doc.uniqueIdent);
print(doc);
print(doc.responses.uniqueIdent);