google-sheetsodbc

How do I generate OAuth ODBC keys?

I want to develop a Google Sheets ODBC driver like CData ODBC driver in a C# Windows application. CData OBDC driver accessing my Gmail account provides following connection details:

DRIVER= {CData ODBC Driver for GoogleSheets};
_persist_oauthaccesstoken=XXXXXXXXXXXXXXXXXXXXXXXXXXX; 
_persist_oauthexpiresin=3600;
_persist_oauthrefreshtoken=XXXXXXXXXXXXXXXXXXXXXXXXXXXXXX;
_persist_token_timestamp=1503999951866

I want to generate oauthaccesstoken, oauthexpiresin, oauthrefreshtoken, and token_timestamp. I have a Client ID and Client secret. How do I generate these keys?

Solution

  • I use this connection string:

    DRIVER={CData ODBC Driver for GoogleSheets};Other='InitiateOAuth=GETANDREFRESH;CheckPromptMode=false;OAuth SettingsLocation=C:\Users\Test\New Text Document.txt';

    OAuth SettingsLocation is a text file that contains the access token of the Gmail account.