The ‘Google Workspace friendly application’ series – table of contents
- What is Google Workspace, and why should we integrate with it?
- Project configuration in Google API Console – use of Google Service Account.
- Configuration of Oracle Database and APEX application – use of Google Service Account.
This article is the second part of instructions on configuring the Google Workspace project with the Oracle APEX application. In the first part, we created a new project in Google API Console, then we enabled Google Drive API library, and finally, we configured the Consent Screen. If you are interested in those steps, go to the previous article. This time we will obtain all necessary information about credentials used for calling particular Google APIs.
Step by step guide
Let’s generate all necessary credentials to use Google API. Go to https://console.developers.google.com/start – at this point, you can use the Google account in your organization’s domain to log in. Pick the project that you created previously. Select the 'Credentials' option from the menu on the left. Select the '+ Create Credentials' option from the top bar. Select 'OAuth client ID' from the available menu.
Additionally, for integrations that do not require the OAuth 2.0 protocol, generate an API key. In the Credentials tab, select „+ Create Credentials” and select the API Key option. The key will be generated. You can choose restrictions on API keys' use due to the allowed application types that can use API Key. You can also select which of the activated Google API libraries in our project will be authorized to use the key. We use the generated key in Google API calls by adding the key=YOUR_API_KEY parameter to the request.
Google Workspace is set up!