Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the connector beyond simple SELECT operations with Salesloft.
Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from Salesloft, along with an indication of whether the procedure succeeded or failed.
CData Power BI Connector for Salesloft Stored Procedures
| Name | Description |
| CadenceExport | New cadences can be created or steps can be imported onto existing cadences which do not have steps. |
| CadenceImport | New cadences can be created or steps can be imported onto existing cadences which do not have steps. |
| CreateActivity | Creates an activity. The creation of an activity marks the associated action as completed. Currently, only certain action types can have an activity explicitly created for them. |
| CreateConversationCall | Creates an activity. An activity will mark the associated action as completed. Currently, only certain action types can have an activity explicitly created for them. |
| CreateExternalEmail | Creates an external email object. Note: The external emails create endpoint requires special scopes that have to be enabled by the Salesloft engineering team. To enable the Scopes, please contact the Salesloft support center. |
| CreateOngoingAction | Creates an activity. An activity will mark the associated action as completed. Currently, only certain action types can have an activity explicitly created for them. |
| CreateSchema | Creates a schema file for the specified table or view. |
| GetCallerIds | Returns each entry that is a possible caller ID match for the number. Multiple entries may be returned if the phone number is present on more than one person in the system. Phone number should be in E.164 format. |
| GetOAuthAccessToken | Gets an authentication token from SalesLoft. |
| GetOAuthAuthorizationURL | Gets the authorization URL that must be opened separately by the user to grant access to your application. Only needed when developing Web apps. You will request the OAuthAccessToken from this URL. |
| GetRecordingSettings | Fetches the recording status for a given phone number, based on Do Not Record and Recording Governance for your team. Phone number should be in E.164 format. |
| RefreshOAuthAccessToken | Refreshes the OAuth access token used for authentication with SalesLoft. |