Stored procedures are available to complement the data available from the Data Model. It may be necessary to update data available from a view using a stored procedure because the data does not provide for direct, table-like, two-way updates. In these situations, the retrieval of the data is done using the appropriate view or table, while the update is done by calling a stored procedure. Stored procedures take a list of parameters and return back a dataset that contains the collection of tuples that constitute the response.
Google Campaign Manager Adapter Stored Procedures
|CheckReportStatus||Checks the status of a report.|
|CreateCustomSchema||Creates a custom schema file based for the given ReportID.|
|GetOAuthAccessToken||Obtains the OAuth access token to be used for authentication with various Google services.|
|GetOAuthAuthorizationURL||Obtains the OAuth authorization URL used for authentication with various Google services.|
|RefreshOAuthAccessToken||Obtains the OAuth access token to be used for authentication with various Google services.|
|RunReport||Runs a given report and returns the file ID which can be used to retrieve the results after processing is complete.|