AnsweredAssumed Answered

Cannot call Free SQL Resource with custom parameter

Question asked by scgapiadmins on Sep 19, 2018
Latest reply on Oct 8, 2018 by scgapiadmins

Cannot call Free SQL Resource with custom parameter

 

I would like to call CountRow with parameter arg_table

 

Cannot call Free SQL Resource with custom parameter

 

I would like to call CountRow with parameter arg_table

I wrote JavaScript as below

var Response = SysUtility.getResource("CountRow", {arg_table: "ADR2_CEP"});

return Response;

the result is error like didn't send any parameter

{
"statusCode": 500,
"errorCode": 50045,
"errorMessage": "Error while executing Resource JavaScript API-level function FuctionByPostParameters - line 0: Free SQL arg_table or arg.table value not found in url parameters"
}

 

So I try to create FIX free SQL Resource

 

I wrote JavaScript as below

var Response = SysUtility.getResource("CountRowFix");

return Response;

and the result is success

[{"ADR2_CEP":211252}]

Outcomes