How do you call an internal PL/SQL server method/function (like BusinessOpportunityHandling's GetDefaultsForSendMail) from a Custom Event's custom attribute or an Execute Online SQL event action, when API Explorer only documents the OData/REST projection layer and there's no equivalent PL/SQL function reference?

All FAQ questions / Integrations and APIs

Answer

First, reconsider the approach itself: IFS explicitly recommends against using the Execute Online SQL event action type going forward (it's on a path toward removal in a future update), recommending BPA Workflows instead for anything beyond simple needs — this is documented in the Best Practices for Custom Events section of the Configuration documentation. If you still need to find the actual underlying PL/SQL function signature for something like GetDefaultsForSendMail (since API Explorer only covers the REST/OData layer, not internal PL/SQL), download the core source code zip from Build Place, unpack it, and search for the relevant .plsvc file (for example crm\source\crm\database\BusinessOpportunityHandling.plsvc) — the actual implementing function (e.g. Get_Defaults_For_Send_Mail___) and its real parameter signature are defined there, which is the only reliable way to find this kind of undocumented internal function's exact calling convention.

Documentation-based answer. Confirm the product and release before applying it. This answer has not been verified in an IFS environment.

← Browse Integrations and APIs questions