How to Handle dynamic QUERY Style key-value parameters in my request url?
Hello all,
When setting up a VirtAction with a path variable, I can use that variable from within the response. For instance, a VirtAction api/v1/clients/{client_id} will create a variable named client_id which I can now use in the response.
How can I do the same name with query (non path) parameters? Is there a way ServiceV Pro can store these query parameters into variables that I can use in the response message?
yes, my problem was solved like this :
function Delete()
{
var AConnection, Driver;
AConnection = ADO.CreateADOConnection();
AConnection.ConnectionString = "Provider=MSDAORA.1;Password=autocm931;User ID=autocm931;Data Source=srv28;Persist Security Info=True";
AConnection.LoginPrompt = false;
AConnection.Open();
var Driver = DDT.ExcelDriver("C:\\Add-Exchange.xls", "Sheet1");
var k = aqConvert.VarToStr(Driver.Value(0));
var str = "delete from exchange ex where ex.name like '"+k+"'"
AConnection.Execute_(str);
DDT.CloseDriver(Driver.Name);
AConnection.Close();}
Thanks for ur consideration