{"id":431,"date":"2016-04-09T21:25:18","date_gmt":"2016-04-09T21:25:18","guid":{"rendered":"http:\/\/zappysys.com\/blog\/?p=431"},"modified":"2024-06-05T21:35:54","modified_gmt":"2024-06-05T21:35:54","slug":"register-google-oauth-application-get-clientid-clientsecret","status":"publish","type":"post","link":"https:\/\/zappysys.com\/blog\/register-google-oauth-application-get-clientid-clientsecret\/","title":{"rendered":"How to register Google OAuth Application (Get ClientID and ClientSecret)"},"content":{"rendered":"<h2>Introduction<\/h2>\n<p>In our previous article we understood little bit about <a href=\"https:\/\/zappysys.com\/blog\/rest-api-authentication-with-oauth-2-0-using-ssis\/\" target=\"_blank\" rel=\"noopener\">OAuth 2.0 Protocol<\/a>. We talked how to use Default App for ease of use. However In this post you will learn <strong>how to register Google OAuth Application<\/strong> so you can access various Google Services programmatically (e.g Youtube, Google Analytics, AdWords, DoubleClick etc.). Here is the link to find all services: <a href=\"https:\/\/developers.google.com\/oauthplayground\/\" target=\"_blank\" rel=\"noopener\">Google API Services (Using OAuth 2.0)<\/a><\/p>\n<p>Recently google started supporting <a href=\"https:\/\/developers.google.com\/identity\/protocols\/OAuth2\" target=\"_blank\" rel=\"noopener\">OAuth 2.0<\/a> Protocol. There are many articles written explaining OAuth 2.0 protocol so we are not going to cover that in this article.<\/p>\n<p>Following SSIS Connectors support OAuth Connectivity. When you use below connectors no coding required to pull data from OAuth enabled services.<\/p>\n<p><strong>SSIS Tasks \/ Components which Supports OAuth Connection \/ Google API<\/strong><\/p>\n<div class=\"su-table su-table-alternate\">\n<table>\n<tbody>\n<tr>\n<td width=\"36\"><img decoding=\"async\" src=\"\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/api-source\/ssis-api-source.png\" alt=\"Custom SSIS Tasks - API Source\" width=\"32\" \/><\/td>\n<td><a href=\"\/products\/ssis-powerpack\/ssis-api-source\/\" target=\"_blank\" rel=\"noopener\">API Source<\/a><\/td>\n<\/tr>\n<tr>\n<td width=\"36\"><img decoding=\"async\" src=\"\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/google-analytics-source\/ssis-google-analytics-source.png\" alt=\"Custom SSIS Tasks - Google Analytics Source\" width=\"32\" \/><\/td>\n<td><a href=\"\/\/zappysys.com\/products\/ssis-powerpack\/ssis-google-analytics-source-connector\/\" target=\"_blank\" rel=\"noopener\">Google Analytics Source<\/a><\/td>\n<\/tr>\n<tr>\n<td width=\"36\"><img decoding=\"async\" src=\"\/\/zappysys.com\/images\/ssis-powerpack\/SSIS-Json-Source-Adapter.png\" alt=\"Custom SSIS Components - JSON Source (File and REST API Connector)\" width=\"32\" \/><\/td>\n<td><a href=\"\/\/zappysys.com\/products\/ssis-powerpack\/ssis-json-file-source\/\" target=\"_blank\" rel=\"noopener\">JSON Source Connector (File, REST API)<\/a><\/td>\n<\/tr>\n<tr>\n<td width=\"36\"><img decoding=\"async\" src=\"\/\/zappysys.com\/images\/ssis-powerpack\/ssis-rest-api-web-service-task.png\" alt=\"Custom SSIS Tasks - Call REST API Webservice (GET, POST, DELETE etc)\" width=\"32\" \/><\/td>\n<td><a href=\"\/\/zappysys.com\/products\/ssis-powerpack\/ssis-rest-api-web-service-task\/\" target=\"_blank\" rel=\"noopener\">REST API Webservice Task<\/a><\/td>\n<\/tr>\n<tr>\n<td width=\"36\"><img decoding=\"async\" src=\"\/\/zappysys.com\/images\/ssis-powerpack\/ssis-xml-source.png\" alt=\"Custom SSIS Components - XML Source (File, REST, SOAP)\" width=\"32\" \/><\/td>\n<td><a href=\"\/\/zappysys.com\/products\/ssis-powerpack\/ssis-xml-source\/\" target=\"_blank\" rel=\"noopener\">XML Source (File, REST, SOAP)<\/a><\/td>\n<\/tr>\n<tr>\n<td width=\"36\"><img decoding=\"async\" src=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/web-api-destination\/ssis-web-api-destination.png\" alt=\"SSIS Web API destination\" width=\"32\" \/><\/td>\n<td><a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/ssis-web-api-destination-connector\/\" target=\"_blank\" rel=\"noopener\">Web API Destination<\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p><strong>ODBC Drivers which Supports OAuth Connection \/ Google API (Call in Power BI, Excel, Informatica, MS Access)<\/strong><\/p>\n<div class=\"su-table su-table-alternate\">\n<table>\n<tbody>\n<tr>\n<td width=\"36\"><img decoding=\"async\" src=\"https:\/\/zappysys.com\/images\/odbc-powerpack\/odbc-api-driver.png\" alt=\"API ODBC Driver\" width=\"32\" \/><\/td>\n<td><a href=\"https:\/\/zappysys.com\/products\/odbc-powerpack\/odbc-api-driver\/\" target=\"_blank\" rel=\"noopener\">API ODBC Driver<\/a><\/td>\n<\/tr>\n<tr>\n<td width=\"36\"><img decoding=\"async\" src=\"https:\/\/zappysys.com\/images\/odbc-powerpack\/odbc-json-api-driver.png\" alt=\"JSON ODBC Driver\" width=\"32\" \/><\/td>\n<td><a href=\"https:\/\/zappysys.com\/products\/odbc-powerpack\/odbc-json-rest-api-driver\/\" target=\"_blank\" rel=\"noopener\">JSON ODBC Driver<\/a><\/td>\n<\/tr>\n<tr>\n<td width=\"36\"><img decoding=\"async\" src=\"https:\/\/zappysys.com\/images\/odbc-powerpack\/odbc-xml-api-driver.png\" alt=\"XML ODBC Driver\" width=\"32\" \/><\/td>\n<td><a href=\"https:\/\/zappysys.com\/products\/odbc-powerpack\/odbc-xml-soap-api-driver\/\" target=\"_blank\" rel=\"noopener\">XML ODBC Driver<\/a><\/td>\n<\/tr>\n<tr>\n<td width=\"36\"><img decoding=\"async\" src=\"https:\/\/zappysys.com\/images\/odbc-powerpack\/odbc-csv-api-driver.png\" alt=\"CSV ODBC Driver\" width=\"32\" \/><\/td>\n<td><a href=\"https:\/\/zappysys.com\/products\/odbc-powerpack\/odbc-csv-rest-api-driver\/\" target=\"_blank\" rel=\"noopener\">CSV ODBC Driver<\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<h2>Create Google Project<\/h2>\n<p>Registering OAuth App in Google first requires you to create API Project. API Project is a container which can host many OAuth Apps or other API Keys.<\/p>\n<ol>\n<li>To create API Project Visit <a href=\"https:\/\/console.developers.google.com\/project\" target=\"_blank\" rel=\"noopener\">https:\/\/console.developers.google.com\/project<\/a><br \/>\nIf you already have existing API Project then once you click above link you can pick desired API Project from dropdown (Found in the top bar). If you using existing API Project then you may skip next few steps and directly move to step which explains [how to create OAuth ClientId].<\/li>\n<li>To create new project Click on <strong>&#8220;Create Project&#8221;<\/strong> button.\u00a0Once you click Create it will take few seconds to create project for you.\n<div id=\"attachment_434\" style=\"width: 394px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/04\/google-api-create-new-project-for-oauth-app.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-434\" class=\"size-full wp-image-434\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/04\/google-api-create-new-project-for-oauth-app.png\" alt=\"Create New Google API Project (Google API - Register new OAuth App)\" width=\"384\" height=\"260\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/04\/google-api-create-new-project-for-oauth-app.png 384w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/04\/google-api-create-new-project-for-oauth-app-300x203.png 300w\" sizes=\"(max-width: 384px) 100vw, 384px\" \/><\/a><p id=\"caption-attachment-434\" class=\"wp-caption-text\">Create New Google API Project (Google API &#8211; Register new OAuth App)<\/p><\/div><\/li>\n<li>Now give some friendly name and change default Project ID (optional) for your project and click Create (See below).<br \/>\n<strong><br \/>\nNOTE:<\/strong>\u00a0Before you click create you can <strong>change default Project ID<\/strong>\u00a0suggested by Google by clicking <strong>Edit<\/strong>. This Project ID is used everywhere when calling many APIs <a href=\"https:\/\/cloud.google.com\/bigquery\/docs\/reference\/rest\/v2\/jobs\/query\" target=\"_blank\" rel=\"noopener\">like this one<\/a> so copy this ID somewhere (You can also see this on project screen so dont worry if you miss it).Project ID is unique across google system so you may not get your preferred ID but if you can get one then its easy to remember for sure.<\/p>\n<div id=\"attachment_441\" style=\"width: 385px\" class=\"wp-caption alignnone\"><a href=\"\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/04\/google-api-create-new-project-for-oauth-app-2.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-441\" class=\"size-full wp-image-441\" src=\"\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/04\/google-api-create-new-project-for-oauth-app-2.png\" alt=\"Create new Google Api Project for OAuth App (Set project name)\" width=\"375\" height=\"271\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/04\/google-api-create-new-project-for-oauth-app-2.png 375w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/04\/google-api-create-new-project-for-oauth-app-2-300x217.png 300w\" sizes=\"(max-width: 375px) 100vw, 375px\" \/><\/a><p id=\"caption-attachment-441\" class=\"wp-caption-text\">Create new Google Api Project for OAuth App (Set project name \/ edit default project ID)<\/p><\/div><\/li>\n<\/ol>\n<h2>Enable Google API for Integration<\/h2>\n<p>Once your Project is created, next step is enable APIs you like to call. By default most Google APIs are disabled so make sure you enable each APi category manually using below steps.<\/p>\n<ol>\n<li>Once project is created it will redirect you to the API Home page where you will see many common Google API you can use.If you do not see that you can always click below option to enable API manually.Visit :\u00a0<a href=\"https:\/\/console.cloud.google.com\/apis\/library\" target=\"_blank\" rel=\"noopener\">https:\/\/console.cloud.google.com\/apis\/library<\/a>\n<div id=\"attachment_8446\" style=\"width: 722px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/04\/enable-google-api-services.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-8446\" class=\"size-full wp-image-8446\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/04\/enable-google-api-services.png\" alt=\"Enable Google APIs \/ Services\" width=\"712\" height=\"418\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/04\/enable-google-api-services.png 712w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/04\/enable-google-api-services-300x176.png 300w\" sizes=\"(max-width: 712px) 100vw, 712px\" \/><\/a><p id=\"caption-attachment-8446\" class=\"wp-caption-text\">Enable Google APIs \/ Services<\/p><\/div><\/li>\n<li>By default API you like to call might not be enabled. Search for API you wish to enable, click on the API name and <strong>click Enable<\/strong>.<span style=\"text-decoration: underline;\">Some common Google API Examples:<\/span>\n<ol>\n<li>To enable <strong>Google YouTube API<\/strong><br \/>\n&gt; search for &#8220;<a href=\"https:\/\/console.cloud.google.com\/apis\/library?q=youtube\" target=\"_blank\" rel=\"noopener\">YouTube<\/a>&#8220;. It has few APIs so pick the one you need under this,<br \/>\n&gt; For example To manage\/view channel use Data API, for Reporting use Analytics API)<\/li>\n<li>To enable <strong>Google Drive API<\/strong><br \/>\nsearch for &#8220;<a href=\"https:\/\/console.cloud.google.com\/apis\/library?q=drive\" target=\"_blank\" rel=\"noopener\">Drive<\/a>&#8221; and click Enable<\/li>\n<li>To enable <strong>Google Sheets API<\/strong><br \/>\nsearch for &#8220;<a href=\"https:\/\/console.cloud.google.com\/apis\/library?q=sheet\" target=\"_blank\" rel=\"noopener\">Sheet<\/a>&#8221; (Some Sheets API operations need Drive API too see enable that as well)<\/li>\n<li>To enable <strong>Google BigQuery API<\/strong><br \/>\n&gt; search for &#8220;<a href=\"https:\/\/console.cloud.google.com\/apis\/library?q=bigquery\" target=\"_blank\" rel=\"noopener\">BigQuery<\/a><strong>&#8220;<\/strong><\/li>\n<li>To enable <strong>Google Analytics (GA3)<\/strong><br \/>\n&gt; search <strong>&#8220;<\/strong><a href=\"https:\/\/console.cloud.google.com\/apis\/library?q=analytics\" target=\"_blank\" rel=\"noopener\">Analytics<\/a><strong>&#8220;<\/strong> and enable <em>Google Analytics API<\/em><\/li>\n<li>To enable <strong>Google Analytics (GA4)<\/strong><br \/>\n&gt; search for <em>Google Analytics Data API<\/em> and click Enable, Search for <em>Google Analytics Admin API<\/em>\u00a0and click enable (needed this to query available properties)<\/p>\n<div id=\"attachment_440\" style=\"width: 481px\" class=\"wp-caption alignnone\"><a href=\"\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/04\/google-api-project-enable-api-screen.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-440\" class=\"size-full wp-image-440\" src=\"\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/04\/google-api-project-enable-api-screen.png\" alt=\"Enable Google API for OAuth Application Access (register Google OAuth Application)\" width=\"471\" height=\"356\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/04\/google-api-project-enable-api-screen.png 471w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/04\/google-api-project-enable-api-screen-300x227.png 300w\" sizes=\"(max-width: 471px) 100vw, 471px\" \/><\/a><p id=\"caption-attachment-440\" class=\"wp-caption-text\">Search Google API for OAuth Application Access<\/p><\/div>\n<p>&nbsp;<\/p>\n<div id=\"attachment_439\" style=\"width: 444px\" class=\"wp-caption alignnone\"><a href=\"\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/04\/google-api-project-enable-api-screen-2.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-439\" class=\"size-full wp-image-439\" src=\"\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/04\/google-api-project-enable-api-screen-2.png\" alt=\"Enable Google API for OAuth Application Access (register Google OAuth Application)\" width=\"434\" height=\"193\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/04\/google-api-project-enable-api-screen-2.png 434w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/04\/google-api-project-enable-api-screen-2-300x133.png 300w\" sizes=\"(max-width: 434px) 100vw, 434px\" \/><\/a><p id=\"caption-attachment-439\" class=\"wp-caption-text\">Enable Google API for OAuth Application Access<\/p><\/div>\n<p>&nbsp;<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<h2>Create OAuth Credentials (Client ID \/ Secret)<\/h2>\n<p>Once we create project and enable APIs our next step is to obtain OAuth ClientID \/ Secret. Before you can obtain that you have to configure few properties of your OAuth Consent Screen. Most fields are optional on this screen but fill out them if you plan to publish this API App for other users (i.e. Public App).<\/p>\n<ol>\n<li>Now click on the credentials tab and click &#8220;OAuth consent screen&#8221;. Fill out necessary information which will be visible to the user (such as App Name).\u00a0Once you are done, continue on with credentials creation:<img loading=\"lazy\" decoding=\"async\" class=\"wp-image-9916 size-full\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/04\/google-configure-api-oauth-consent-screen.png\" alt=\"\" width=\"806\" height=\"906\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/04\/google-configure-api-oauth-consent-screen.png 806w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/04\/google-configure-api-oauth-consent-screen-267x300.png 267w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/04\/google-configure-api-oauth-consent-screen-768x863.png 768w\" sizes=\"(max-width: 806px) 100vw, 806px\" \/>Google OAuth API &#8211; Create OAuth App &#8211; Set Application Name on Consent Screen<\/li>\n<li>Click on [Create credentials] button and select OAuth Client Id option.\n<div id=\"attachment_438\" style=\"width: 855px\" class=\"wp-caption alignnone\"><a href=\"\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/04\/google-api-create-oauth-credentials.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-438\" class=\"wp-image-438 size-full\" src=\"\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/04\/google-api-create-oauth-credentials.png\" alt=\"Create OAuth Client ID Credentials for Google API access\" width=\"845\" height=\"519\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/04\/google-api-create-oauth-credentials.png 845w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/04\/google-api-create-oauth-credentials-300x184.png 300w\" sizes=\"(max-width: 845px) 100vw, 845px\" \/><\/a><p id=\"caption-attachment-438\" class=\"wp-caption-text\">Create OAuth Client ID Credentials for Google API access<\/p><\/div><\/li>\n<li>Next you will be asked to select Application Type. Pick &#8220;<strong>Desktop app<\/strong>&#8221;\u00a0if your Application is Desktop style application. If your app is web site or running browser then pick Web Application. Click on Create and you will see your ClientID and ClientSecret which you can use\u00a0during OAuth Authentication. <strong>Keep these both information secret<\/strong>.\u00a0This is used to call OAuth Approval Screen by your Desktop App or Web App&#8230; and then\u00a0user can obtain Token which can be used to call desired Google API.<div class=\"su-note\"  style=\"border-color:#e5de9d;border-radius:3px;-moz-border-radius:3px;-webkit-border-radius:3px;\"><div class=\"su-note-inner su-u-clearfix su-u-trim\" style=\"background-color:#FFF8B7;border-color:#ffffff;color:#333333;border-radius:3px;-moz-border-radius:3px;-webkit-border-radius:3px;\">NOTE: Make sure you do not choose Web App and only select Desktop App. Desktop App doesnt have Redirect URL making it simple to setup and use with ZappySys software.<\/div><\/div>\n<div id=\"attachment_9229\" style=\"width: 732px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/04\/create-google-oauth-credentials-new-desktop-application.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-9229\" class=\"size-full wp-image-9229\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/04\/create-google-oauth-credentials-new-desktop-application.png\" alt=\"Create Google OAuth 2.0 Credentials - Desktop App\" width=\"722\" height=\"445\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/04\/create-google-oauth-credentials-new-desktop-application.png 722w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/04\/create-google-oauth-credentials-new-desktop-application-300x185.png 300w\" sizes=\"(max-width: 722px) 100vw, 722px\" \/><\/a><p id=\"caption-attachment-9229\" class=\"wp-caption-text\">Create Google OAuth 2.0 Credentials &#8211; Desktop App<\/p><\/div>\n<div id=\"attachment_444\" style=\"width: 617px\" class=\"wp-caption alignnone\"><a href=\"\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/04\/api-client-generate-google-oauth-app-clientid-client-secret.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-444\" class=\"size-full wp-image-444\" src=\"\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/04\/api-client-generate-google-oauth-app-clientid-client-secret.png\" alt=\"Generate ClientID and Client Secret for Google OAuth Application (register Google OAuth Application)\" width=\"607\" height=\"402\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/04\/api-client-generate-google-oauth-app-clientid-client-secret.png 607w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/04\/api-client-generate-google-oauth-app-clientid-client-secret-300x199.png 300w\" sizes=\"(max-width: 607px) 100vw, 607px\" \/><\/a><p id=\"caption-attachment-444\" class=\"wp-caption-text\">Generate ClientID and Client Secret for Google OAuth Application<\/p><\/div><\/li>\n<\/ol>\n<h2>Publish App<\/h2>\n<p>The last step in App creation is to go to the OAuth Consent Screen tab. Under Publishing Status, click PUBLISH APP to ensure your refresh token doesn&#8217;t expire often. If you plan to use the App for Private use, you do not have to worry about the Verification Status after Publishing (Which is the case for most users who access their own data).<\/p>\n<div id=\"attachment_11084\" style=\"width: 606px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/04\/google-publish-oauth-app-refresh-token-expires-every-7-days.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-11084\" class=\"size-full wp-image-11084\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/04\/google-publish-oauth-app-refresh-token-expires-every-7-days.png\" alt=\"Publish Google App (This avoids Refresh Token Expiration every 7 days)\" width=\"596\" height=\"562\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/04\/google-publish-oauth-app-refresh-token-expires-every-7-days.png 596w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/04\/google-publish-oauth-app-refresh-token-expires-every-7-days-300x283.png 300w\" sizes=\"(max-width: 596px) 100vw, 596px\" \/><\/a><p id=\"caption-attachment-11084\" class=\"wp-caption-text\">Publish Google App (This avoids Refresh Token Expiration every 7 days)<\/p><\/div>\n<h2>Using Client ID and Client Secret in ZappySys OAuth Connection<\/h2>\n<p>You can use generated ClientID and ClientSecret to initiate OAuth Authorization process. We are not going to cover how that works, but below is a simple screenshot of how these two pieces of information are used to call the Consent screen with some desired permission requested by calling Application:<\/p>\n<p>ZappySys OAuth Connection can be used by many components suggested in the beginning of this article. So refer them for more information.<\/p>\n<div id=\"attachment_6855\" style=\"width: 930px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/04\/ssis-oauth-connection-manager-generate-access-token.png\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-6855\" class=\"wp-image-6855 size-full\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/04\/ssis-oauth-connection-manager-generate-access-token.png\" alt=\"\" width=\"920\" height=\"1032\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/04\/ssis-oauth-connection-manager-generate-access-token.png 920w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/04\/ssis-oauth-connection-manager-generate-access-token-267x300.png 267w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/04\/ssis-oauth-connection-manager-generate-access-token-768x861.png 768w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/04\/ssis-oauth-connection-manager-generate-access-token-913x1024.png 913w\" sizes=\"(max-width: 920px) 100vw, 920px\" \/><\/a><p id=\"caption-attachment-6855\" class=\"wp-caption-text\">Google OAuth Application: Generating Access and Refresh tokens using SSIS and OAuth Connection Manager.<\/p><\/div>\n<h2>Using System Default Browser to get the token<\/h2>\n<p>If embedded browser has some issue to extract your token then you can close the window by pressing <strong>[X]<\/strong> in the title bar. Once you do that you will be prompted to use System Default browser to finish the token extraction. If you click Yes then Full browser will be launched.<\/p>\n<p><strong>NOTE:<\/strong> Below feature is added in version published after Dec 31, 2019 (v3.0.0.11231 or later) so make sure you have latest version.<\/p>\n<div id=\"attachment_8782\" style=\"width: 570px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/04\/use-system-browser-flow.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-8782\" class=\"size-full wp-image-8782\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/04\/use-system-browser-flow.png\" alt=\"Using System Default Browser to extract OAuth Token\" width=\"560\" height=\"287\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/04\/use-system-browser-flow.png 560w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/04\/use-system-browser-flow-300x154.png 300w\" sizes=\"(max-width: 560px) 100vw, 560px\" \/><\/a><p id=\"caption-attachment-8782\" class=\"wp-caption-text\">Using System Default Browser to extract OAuth Token<\/p><\/div>\n<h3>Untrusted App Warning<\/h3>\n<p>Sometimes Google might show you below warning. In order to continue the flow you might have to Click on <strong>Advanced<\/strong> and then click\u00a0<strong>Go to YourAppName (unsafe)<\/strong> like below<\/p>\n<p>&nbsp;<\/p>\n<div id=\"attachment_8779\" style=\"width: 658px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/04\/google-oauth-app-not-trusted.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-8779\" class=\"size-full wp-image-8779\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/04\/google-oauth-app-not-trusted.png\" alt=\"How to ignore Google Unsafe App Warning (OAuth Flow)\" width=\"648\" height=\"455\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/04\/google-oauth-app-not-trusted.png 648w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/04\/google-oauth-app-not-trusted-300x211.png 300w\" sizes=\"(max-width: 648px) 100vw, 648px\" \/><\/a><p id=\"caption-attachment-8779\" class=\"wp-caption-text\">How to ignore Google Unsafe App Warning (OAuth Flow)<\/p><\/div>\n<p>&nbsp;<\/p>\n<p><strong>OR, in some cases, you may see modern UI like below. In either case, <span style=\"text-decoration: underline;\">choose continue<\/span>.<\/strong><\/p>\n<p>&nbsp;<\/p>\n<div id=\"attachment_11087\" style=\"width: 524px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/04\/google-app-not-verfied-new.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-11087\" class=\"size-full wp-image-11087\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/04\/google-app-not-verfied-new.png\" alt=\"Google App not Verified Warning (New UI)\" width=\"514\" height=\"397\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/04\/google-app-not-verfied-new.png 514w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/04\/google-app-not-verfied-new-300x232.png 300w\" sizes=\"(max-width: 514px) 100vw, 514px\" \/><\/a><p id=\"caption-attachment-11087\" class=\"wp-caption-text\">Google App not Verified Warning (New UI)<\/p><\/div>\n<p>&nbsp;<\/p>\n<h3>Select the account<\/h3>\n<div id=\"attachment_8780\" style=\"width: 939px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/04\/use-system-browser-for-oauth-token-extract.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-8780\" class=\"size-full wp-image-8780\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/04\/use-system-browser-for-oauth-token-extract.png\" alt=\"Using System Browser\" width=\"929\" height=\"699\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/04\/use-system-browser-for-oauth-token-extract.png 929w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/04\/use-system-browser-for-oauth-token-extract-300x226.png 300w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/04\/use-system-browser-for-oauth-token-extract-768x578.png 768w\" sizes=\"(max-width: 929px) 100vw, 929px\" \/><\/a><p id=\"caption-attachment-8780\" class=\"wp-caption-text\">Using System Browser<\/p><\/div>\n<h3>Copy code and finish the flow<\/h3>\n<div id=\"attachment_8786\" style=\"width: 1135px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/06\/manually-extract-oauth-token-use-full-browser.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-8786\" class=\"size-full wp-image-8786\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/06\/manually-extract-oauth-token-use-full-browser.png\" alt=\"Manually Copy Code and Get OAuth Refresh \/ Access Token\" width=\"1125\" height=\"672\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/06\/manually-extract-oauth-token-use-full-browser.png 1125w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/06\/manually-extract-oauth-token-use-full-browser-300x179.png 300w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/06\/manually-extract-oauth-token-use-full-browser-768x459.png 768w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/06\/manually-extract-oauth-token-use-full-browser-1024x612.png 1024w\" sizes=\"(max-width: 1125px) 100vw, 1125px\" \/><\/a><p id=\"caption-attachment-8786\" class=\"wp-caption-text\">Manually Copy Code and Get OAuth Refresh \/ Access Token<\/p><\/div>\n<p>&nbsp;<\/p>\n<h2>Why I didn&#8217;t get refresh token back?<\/h2>\n<p>For some reason if you just see Access token and not refresh token then try following<\/p>\n<ol>\n<li>Logout current session in browser and close all browser windows and try again<\/li>\n<li>If you use <strong>Custom<\/strong> Provider rather than Google on OAuth connection then change Auth URL to include prompt and access_type like below\n<pre class=\"lang:default highlight:0 decode:true\">https:\/\/accounts.google.com\/o\/oauth2\/auth?access_type=offline&amp;prompt=consent<\/pre>\n<\/li>\n<\/ol>\n<h2>What to do if Google Refresh Token expires every 7 days<\/h2>\n<p>Technically, once you have a refresh token, you should not worry about renewing as long as the API call is made atleast once every few months (max 6 months idle time). However, in some cases, your refresh token can expire sooner, and you have to click Generate Token manually<\/p>\n<p>One main reason that is not well documented is if the Google Oauth Private App you created to access your own data is still in &#8220;<strong>testing<\/strong>&#8221; mode and not &#8220;<strong>published<\/strong>,&#8221; then as per Google, <a href=\"https:\/\/developers.google.com\/google-ads\/api\/docs\/get-started\/common-errors\">you may get this error<\/a>. Perform these steps to publish your app, which is in testing mode, so you do not have to renew the refresh token every 7 days.<\/p>\n<ol>\n<li>Go to your Project in Google API console<br \/>\nGenerally here<\/li>\n<li>No API call has been made using the generated refresh_token for six months or longer<br \/>\n<strong>SOLUTION:\u00a0<\/strong> Make at least some API in six months to keep refresh_token active<\/li>\n<li>Your OAuth App is in &#8220;testing&#8221; status and not published yet<br \/>\n<strong>SOLUTION:<\/strong> Just click the <strong>Publish<\/strong> button on your App OAuth Consent screen. Do not worry about getting verified if you plan to use it for internal use; after this step, your refresh_token may not expire every 7 days <a href=\"https:\/\/stackoverflow.com\/questions\/8953983\/do-google-refresh-tokens-expire\" target=\"_blank\" rel=\"noopener\">See this thread<\/a>.<strong>DO NOT WORRY ABOUT GETTING VERIFIED<\/strong> &#8211; Just publish it to avoid refresh token expiration every 7 days.<\/p>\n<div id=\"attachment_11084\" style=\"width: 606px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/04\/google-publish-oauth-app-refresh-token-expires-every-7-days.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-11084\" class=\"size-full wp-image-11084\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/04\/google-publish-oauth-app-refresh-token-expires-every-7-days.png\" alt=\"Publish Google App (This avoids Refresh Token Expiration every 7 days) \" width=\"596\" height=\"562\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/04\/google-publish-oauth-app-refresh-token-expires-every-7-days.png 596w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/04\/google-publish-oauth-app-refresh-token-expires-every-7-days-300x283.png 300w\" sizes=\"(max-width: 596px) 100vw, 596px\" \/><\/a><p id=\"caption-attachment-11084\" class=\"wp-caption-text\">Publish Google App (This avoids Refresh Token Expiration every 7 days)<\/p><\/div><\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<h2>What is Google OAuth AccessToken<\/h2>\n<p><strong>AccessToken<\/strong> is short lived token which you can pass along with each API Service call. once this token is expired you can get new <strong>AccessToken<\/strong> as long as you have obtained and saved <strong>RefreshToken<\/strong> (Returned to caller after very first time user go through Approval process on Consent screen). If you are using <a href=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/ssis-oauth-connection-manager.htm\" target=\"_blank\" rel=\"noopener\">ZappySys OAuth connection manager<\/a><\/p>\n<h2>What is Google OAuth RefreshToken<\/h2>\n<p>May OAuth services support short lived token which expires after few minutes or hours. Google API by default expires token after 3600 seconds &#8230; So how to get new token ? Do you always go through that annoying Consent screen&#8230; what if your application is Automated Service? Well OAuth has solution for that too&#8230;\u00a0its called RefreshToken.<\/p>\n<p>First time to setup OAuth connection user have to go through Approval screen\u00a0\u00a0(i.e. Consent screen) once they click Approve button they may receive two types of token (AccessToken and RefreshToken).\u00a0\u00a0RefreshToken is used only when you need to get new AccessToken without going through Consent screen. So technically if OAuth supports RefreshToken (This is optional) then you can Save this piece of information in database somewhere and when you get token_expired error or you detect expiration time you can\u00a0get new AccessToken without involving user consent (because you already did once).<\/p>\n<h2>Conclusion<\/h2>\n<p>Hope this article helped you to understand how to <strong>register Google OAuth Application<\/strong>. Download <a href=\"\/\/zappysys.com\/products\/ssis-powerpack\/\">SSIS PowerPack<\/a> to try various <strong>OAuth data integration scenarios<\/strong> using drag and drop high performance connectors. With <a href=\"\/\/zappysys.com\/products\/ssis-powerpack\/ssis-json-file-source\/\">SSIS PowerPack OAuth support<\/a> you can virtually pull data from any API service (<a href=\"\/\/zappysys.com\/products\/ssis-powerpack\/ssis-xml-source\/\">XML REST API<\/a> or <a href=\"\/\/zappysys.com\/products\/ssis-powerpack\/ssis-json-file-source\/\">JSON REST API<\/a>). Such as Facbook, Twitter, SurveyMonkey, LinkedIn and many more.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Introduction In our previous article we understood little bit about OAuth 2.0 Protocol. We talked how to use Default App for ease of use. However In this post you will learn how to register Google OAuth Application so you can access various Google Services programmatically (e.g Youtube, Google Analytics, AdWords, DoubleClick etc.). Here is the [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":434,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[55],"tags":[56,13,60,25,101,3,4,100],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\r\n<title>How to register Google OAuth Application (Get ClientID and ClientSecret) | ZappySys Blog<\/title>\r\n<meta name=\"description\" content=\"In this post learn how to register Google OAuth Application (For Installed App \/ Desktop App Scenario). Learn how to get ClientId and ClientSecret for OAuth\" \/>\r\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\r\n<link rel=\"canonical\" href=\"https:\/\/zappysys.com\/blog\/register-google-oauth-application-get-clientid-clientsecret\/\" \/>\r\n<meta property=\"og:locale\" content=\"en_US\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"How to register Google OAuth Application (Get ClientID and ClientSecret) | ZappySys Blog\" \/>\r\n<meta property=\"og:description\" content=\"In this post learn how to register Google OAuth Application (For Installed App \/ Desktop App Scenario). Learn how to get ClientId and ClientSecret for OAuth\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/zappysys.com\/blog\/register-google-oauth-application-get-clientid-clientsecret\/\" \/>\r\n<meta property=\"og:site_name\" content=\"ZappySys Blog\" \/>\r\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/ZappySys\/\" \/>\r\n<meta property=\"article:published_time\" content=\"2016-04-09T21:25:18+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2024-06-05T21:35:54+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/04\/google-api-create-new-project-for-oauth-app.png\" \/>\r\n\t<meta property=\"og:image:width\" content=\"384\" \/>\r\n\t<meta property=\"og:image:height\" content=\"260\" \/>\r\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\r\n<meta name=\"author\" content=\"ZappySys\" \/>\r\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\r\n<meta name=\"twitter:creator\" content=\"@https:\/\/twitter.com\/zappysys\/\" \/>\r\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"ZappySys\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"14 minutes\" \/>\r\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/zappysys.com\/blog\/register-google-oauth-application-get-clientid-clientsecret\/\",\"url\":\"https:\/\/zappysys.com\/blog\/register-google-oauth-application-get-clientid-clientsecret\/\",\"name\":\"How to register Google OAuth Application (Get ClientID and ClientSecret) | ZappySys Blog\",\"isPartOf\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/zappysys.com\/blog\/register-google-oauth-application-get-clientid-clientsecret\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/zappysys.com\/blog\/register-google-oauth-application-get-clientid-clientsecret\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/04\/google-api-create-new-project-for-oauth-app.png\",\"datePublished\":\"2016-04-09T21:25:18+00:00\",\"dateModified\":\"2024-06-05T21:35:54+00:00\",\"author\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82\"},\"description\":\"In this post learn how to register Google OAuth Application (For Installed App \/ Desktop App Scenario). Learn how to get ClientId and ClientSecret for OAuth\",\"breadcrumb\":{\"@id\":\"https:\/\/zappysys.com\/blog\/register-google-oauth-application-get-clientid-clientsecret\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/zappysys.com\/blog\/register-google-oauth-application-get-clientid-clientsecret\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/register-google-oauth-application-get-clientid-clientsecret\/#primaryimage\",\"url\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/04\/google-api-create-new-project-for-oauth-app.png\",\"contentUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/04\/google-api-create-new-project-for-oauth-app.png\",\"width\":384,\"height\":260,\"caption\":\"Create New Google API Project (Google API - Register new OAuth App)\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/zappysys.com\/blog\/register-google-oauth-application-get-clientid-clientsecret\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/zappysys.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to register Google OAuth Application (Get ClientID and ClientSecret)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/zappysys.com\/blog\/#website\",\"url\":\"https:\/\/zappysys.com\/blog\/\",\"name\":\"ZappySys Blog\",\"description\":\"SSIS \/ ODBC Drivers \/ API Connectors for JSON, XML, Azure, Amazon AWS, Salesforce, MongoDB and more\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/zappysys.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82\",\"name\":\"ZappySys\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/5c9be148088ba9b8af8e955c5f7c22b5?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/5c9be148088ba9b8af8e955c5f7c22b5?s=96&d=mm&r=g\",\"caption\":\"ZappySys\"},\"sameAs\":[\"http:\/\/www.zappysys.com\/\",\"https:\/\/www.facebook.com\/ZappySys\/\",\"https:\/\/twitter.com\/https:\/\/twitter.com\/zappysys\/\"],\"url\":\"https:\/\/zappysys.com\/blog\/author\/admin\/\"}]}<\/script>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to register Google OAuth Application (Get ClientID and ClientSecret) | ZappySys Blog","description":"In this post learn how to register Google OAuth Application (For Installed App \/ Desktop App Scenario). Learn how to get ClientId and ClientSecret for OAuth","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/zappysys.com\/blog\/register-google-oauth-application-get-clientid-clientsecret\/","og_locale":"en_US","og_type":"article","og_title":"How to register Google OAuth Application (Get ClientID and ClientSecret) | ZappySys Blog","og_description":"In this post learn how to register Google OAuth Application (For Installed App \/ Desktop App Scenario). Learn how to get ClientId and ClientSecret for OAuth","og_url":"https:\/\/zappysys.com\/blog\/register-google-oauth-application-get-clientid-clientsecret\/","og_site_name":"ZappySys Blog","article_author":"https:\/\/www.facebook.com\/ZappySys\/","article_published_time":"2016-04-09T21:25:18+00:00","article_modified_time":"2024-06-05T21:35:54+00:00","og_image":[{"width":384,"height":260,"url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/04\/google-api-create-new-project-for-oauth-app.png","type":"image\/png"}],"author":"ZappySys","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/twitter.com\/zappysys\/","twitter_misc":{"Written by":"ZappySys","Est. reading time":"14 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/zappysys.com\/blog\/register-google-oauth-application-get-clientid-clientsecret\/","url":"https:\/\/zappysys.com\/blog\/register-google-oauth-application-get-clientid-clientsecret\/","name":"How to register Google OAuth Application (Get ClientID and ClientSecret) | ZappySys Blog","isPartOf":{"@id":"https:\/\/zappysys.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/zappysys.com\/blog\/register-google-oauth-application-get-clientid-clientsecret\/#primaryimage"},"image":{"@id":"https:\/\/zappysys.com\/blog\/register-google-oauth-application-get-clientid-clientsecret\/#primaryimage"},"thumbnailUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/04\/google-api-create-new-project-for-oauth-app.png","datePublished":"2016-04-09T21:25:18+00:00","dateModified":"2024-06-05T21:35:54+00:00","author":{"@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82"},"description":"In this post learn how to register Google OAuth Application (For Installed App \/ Desktop App Scenario). Learn how to get ClientId and ClientSecret for OAuth","breadcrumb":{"@id":"https:\/\/zappysys.com\/blog\/register-google-oauth-application-get-clientid-clientsecret\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/zappysys.com\/blog\/register-google-oauth-application-get-clientid-clientsecret\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/register-google-oauth-application-get-clientid-clientsecret\/#primaryimage","url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/04\/google-api-create-new-project-for-oauth-app.png","contentUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/04\/google-api-create-new-project-for-oauth-app.png","width":384,"height":260,"caption":"Create New Google API Project (Google API - Register new OAuth App)"},{"@type":"BreadcrumbList","@id":"https:\/\/zappysys.com\/blog\/register-google-oauth-application-get-clientid-clientsecret\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/zappysys.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to register Google OAuth Application (Get ClientID and ClientSecret)"}]},{"@type":"WebSite","@id":"https:\/\/zappysys.com\/blog\/#website","url":"https:\/\/zappysys.com\/blog\/","name":"ZappySys Blog","description":"SSIS \/ ODBC Drivers \/ API Connectors for JSON, XML, Azure, Amazon AWS, Salesforce, MongoDB and more","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/zappysys.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82","name":"ZappySys","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/5c9be148088ba9b8af8e955c5f7c22b5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/5c9be148088ba9b8af8e955c5f7c22b5?s=96&d=mm&r=g","caption":"ZappySys"},"sameAs":["http:\/\/www.zappysys.com\/","https:\/\/www.facebook.com\/ZappySys\/","https:\/\/twitter.com\/https:\/\/twitter.com\/zappysys\/"],"url":"https:\/\/zappysys.com\/blog\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/431"}],"collection":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/comments?post=431"}],"version-history":[{"count":39,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/431\/revisions"}],"predecessor-version":[{"id":11092,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/431\/revisions\/11092"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media\/434"}],"wp:attachment":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media?parent=431"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/categories?post=431"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/tags?post=431"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}