Hi All, We have a requirement to fetch data from external systems by

Hi All,

We have a requirement to fetch data from external systems by making some API calls for one of the customer. They have Oracle packages which we have to call from Appian. One sample is as below:

Role_id :=
asdata.sec_api.get_role_id@asrtw(CpaddRec.carrier_role_name);
ret := asdata.sec_api.grant_ROLE_ACCESS@asrtw(APPID,APPUSER,Role_id,'CP', CpaddRec.client_program_num,'V','L','N');
if ret = 'Y' then

Is there a way with which we can achieve this? This is not a stored procedure or a query which can be executed using the Execute stored proc smart service or Query DB node.

If yes, how can we achieve this?...

OriginalPostID-106226

OriginalPostID-106226