DataFlex

Get Google Cloud SQL Access Token using Service Account JSON Private Key

See more Google Cloud SQL Examples

Demonstrates how to get a Google Cloud SQL access token using a JSON service account private key. Obtaining an access token for a service account requires no user interaction (it does not require a browser, nor callback URI's, etc.).

When an access token expires, an application can be (and should be) designed to automatically fetch a new access token.

DataFlex

Use ChilkatAx-win32.pkg

Procedure Test
    Boolean iSuccess
    Handle hoFac
    String sJsonKey
    Handle hoGAuth
    Variant vTlsSock
    Handle hoTlsSock
    Handle hoSbToken
    String sTemp1
    Boolean bTemp1

    Move False To iSuccess

    // This example requires the Chilkat API to have been previously unlocked.
    // See Global Unlock Sample for sample code.

    // First load the JSON key into a string.
    Get Create (RefClass(cComCkFileAccess)) To hoFac
    If (Not(IsComObjectCreated(hoFac))) Begin
        Send CreateComObject of hoFac
    End
    Get ComReadEntireTextFile Of hoFac "qa_data/googleApi/ChilkatCloud-13a07a2e8b3f.json" "utf-8" To sJsonKey
    Get ComLastMethodSuccess Of hoFac To bTemp1
    If (bTemp1 <> True) Begin
        Get ComLastErrorText Of hoFac To sTemp1
        Showln sTemp1
        Procedure_Return
    End

    // A JSON private key should look something like this:

    // 	{
    // 	  "type": "service_account",
    // 	  "project_id": "chilkattest-1350",
    // 	  "private_key_id": "fa2e36ee26986eab628b59868af8bec1d1c64c38",
    // 	  "private_key": "-----BEGIN PRIVATE KEY-----\nMIIEvgIjFa...28N64N2n1E4FYzBZjSdy\n-----END PRIVATE KEY-----\n",
    // 	  "client_email": "598922945226-00rb0ppfg0sndajo6bhvd4v17jtj2d3a@developer.gserviceaccount.com",
    // 	  "client_id": "598922945226-00rb0ppfg0snd9jo7bhvd4v17jtj2d3a.apps.googleusercontent.com",
    // 	  "auth_uri": "https://accounts.google.com/o/oauth2/auth",
    // 	  "token_uri": "https://accounts.google.com/o/oauth2/token",
    // 	  "auth_provider_x509_cert_url": "https://www.googleapis.com/oauth2/v1/certs",
    // 	  "client_x509_cert_url": "https://www.googleapis.com/robot/v1/metadata/x509/598922945226-00rb0ppfg0sndajo6bhvd4v17jtj2d3a%40developer.gserviceaccount.com"
    // 	}

    Get Create (RefClass(cComChilkatAuthGoogle)) To hoGAuth
    If (Not(IsComObjectCreated(hoGAuth))) Begin
        Send CreateComObject of hoGAuth
    End
    Set ComJsonKey Of hoGAuth To sJsonKey

    // Choose a scope.
    // Here's the OAuth 2.0 scope information for the Cloud SQL Admin API:
    // https://www.googleapis.com/auth/sqlservice.admin 	(Read/write access to Cloud SQL.)
    // https://www.googleapis.com/auth/cloud-platform 	(Instances.import and Instances.export need this additional scope.)
    Set ComScope Of hoGAuth To "https://www.googleapis.com/auth/sqlservice.admin"

    // Request an access token that is valid for this many seconds.
    Set ComExpireNumSeconds Of hoGAuth To 3600

    // If the application is requesting delegated access:
    // The email address of the user for which the application is requesting delegated access,
    // then set the email address here. (Otherwise leave it empty.)
    Set ComSubEmailAddress Of hoGAuth To ""

    // Connect to www.googleapis.com using TLS (TLS 1.2 is the default.)
    // The Chilkat socket object is used so that the connection can be established
    // through proxies or an SSH tunnel if desired.
    Get Create (RefClass(cComChilkatSocket)) To hoTlsSock
    If (Not(IsComObjectCreated(hoTlsSock))) Begin
        Send CreateComObject of hoTlsSock
    End
    Get ComConnect Of hoTlsSock "www.googleapis.com" 443 True 5000 To iSuccess
    If (iSuccess <> True) Begin
        Get ComLastErrorText Of hoTlsSock To sTemp1
        Showln sTemp1
        Procedure_Return
    End

    // Send the request to obtain the access token.
    Get pvComObject of hoTlsSock to vTlsSock
    Get ComObtainAccessToken Of hoGAuth vTlsSock To iSuccess
    If (iSuccess <> True) Begin
        Get ComLastErrorText Of hoGAuth To sTemp1
        Showln sTemp1
        Procedure_Return
    End

    // Examine the access token:
    Get ComAccessToken Of hoGAuth To sTemp1
    Showln "Access Token: " sTemp1

    // Access token looks like this:  ya29.c.Ko4Bwwe3nG5rUvoBmJwadi ... Br4Ogz0B6qLAjg

    // We're going to save this access token to a file to be used
    // by other examples.
    Get Create (RefClass(cComChilkatStringBuilder)) To hoSbToken
    If (Not(IsComObjectCreated(hoSbToken))) Begin
        Send CreateComObject of hoSbToken
    End
    Get ComAccessToken Of hoGAuth To sTemp1
    Get ComAppend Of hoSbToken sTemp1 To iSuccess
    Get ComWriteFile Of hoSbToken "qa_data/tokens/google_cloud_sql_access_token.txt" "utf-8" False To iSuccess


End_Procedure