Some AdoScript CC commands do not return a correct result when the right dataType is selected in a request to /dao/execute
When deployed as part of the ADOxxWeb API the /dao/execute
operation seems to have issues with the dataType
parameter.
Depending on the code, for some variables from CC commands that are integer or string in AdoScript these work with the proper dataType
parameter (integer
or string
).
For other variables from CC commands the response instead has null
as the value when the associated dataType
is selected (integer
for integer, string
for string).
However, a proper value is returned (at least in some of) those cases when dataType
is set to error
.
This issue happens both through Swagger and when performing HTTP requests directly (through Bruno).
Example where it works as expected:
- AdoScript:
CC "Core" GET_ALL_MODEL_VERSIONS
- AdoScriptResultVariable:
modelversionids
- dataType:
string
- URL for POST request:
http://localhost:8080/ADOxxWEBAPI/services/rest/dao/execute?AdoScript=CC%20%22Core%22%20GET_ALL_MODEL_VERSIONS&AdoScriptResultVariable=modelversionids&dataType=string
- Response:
{ "result": "90853 90879 91201 91215", "ecode": "0", "duration": 130, "startTime": "19.09.2025,09:54:44", "endTime": "19.09.2025,09:54:44", "script": { "script": "CC \"Core\" GET_ALL_MODEL_VERSIONS\r\nSET adowsresponse:(modelversionids + \"@@@\" + STR ecode)", "name": null, "waitTime": "30000", "executeTime": "30000", "retries": "1", "userType": "usertype_one", "dataType": "string", "dbname": "adoxx18lbrs" }, "errorText": "No error", "success": true }
Example where it doesn't work as expected:
- AdoScript:
CC "Application" GET_PATH
- AdoScriptResultVariable:
path
- dataType:
string
- URL for POST request:
http://localhost:8080/ADOxxWEBAPI/services/rest/dao/execute?AdoScript=CC%20%22Application%22%20GET_PATH&AdoScriptResultVariable=path&dataType=string
- Response:
{ "result": null, "ecode": null, "duration": 92, "startTime": "19.09.2025,09:55:21", "endTime": "19.09.2025,09:55:21", "script": { "script": "CC \"Application\" GET_PATH\r\nSET adowsresponse:(path + \"@@@\" + STR ecode)", "name": null, "waitTime": "30000", "executeTime": "30000", "retries": "1", "userType": "usertype_one", "dataType": "string", "dbname": "adoxx18lbrs" }, "errorText": "Unknown error", "success": false }
Example where the "doesn't work as expected" gives the correct result when using the wrong dataType
:
- AdoScript:
CC "Modeling" GET_ACT_MODEL
- AdoScriptResultVariable:
path
- dataType:
error
- URL for POST request:
http://localhost:8080/ADOxxWEBAPI/services/rest/dao/execute?AdoScript=CC%20%22Application%22%20GET_PATH&AdoScriptResultVariable=path&dataType=error
- Response:
{ "result": "c:\\Other Programs\\ADOxx_1.8.0 with awssrv", "ecode": "0", "duration": 91, "startTime": "19.09.2025,09:55:42", "endTime": "19.09.2025,09:55:42", "script": { "script": "CC \"Application\" GET_PATH\r\nSET adowsresponse:(path)", "name": null, "waitTime": "30000", "executeTime": "30000", "retries": "1", "userType": "usertype_one", "dataType": "error", "dbname": "adoxx18lbrs" }, "errorText": "No error", "success": true }
Some other commands that have this issue:
CC "Application" GET_USER
CC "Modeling" GET_ACT_MODEL