Googleデータポータル コミュニティコネクタ作成中にOAuth2認証箇所でエラーが出ます。
Chrome V8の無効化など試しましたが駄目でした
【エラー】 Property store is required.
GAS
1var SERVICE_ACCOUNT_CREDS = 'SERVICE_ACCOUNT_CREDS'; 2var SERVICE_ACCOUNT_KEY = 'private_key'; 3var SERVICE_ACCOUNT_EMAIL = 'client_email'; 4var BILLING_PROJECT_ID = 'project_id'; 5var CLIENT_ID = 'client_id'; 6 7 8 9/** 10 * Copy the entire credentials JSON file from creating a service account in GCP. 11 */ 12 13 14function getServiceAccountCreds() { 15 return JSON.parse(scriptProperties.getProperty(SERVICE_ACCOUNT_CREDS)); 16} 17 18 19function getOauthService() { 20 var serviceAccountCreds = getServiceAccountCreds(); 21 var serviceAccountKey = PropertiesService.getScriptProperties().getProperty(SERVICE_ACCOUNT_KEY); 22 var serviceAccountEmail = PropertiesService.getScriptProperties().getProperty(SERVICE_ACCOUNT_EMAIL); 23 var serviceAccountClient_id = PropertiesService.getScriptProperties().getProperty(CLIENT_ID); 24 25 var scriptProperties = PropertiesService.getScriptProperties(); 26 27 return OAuth2.createService('RowLevelSecurity') 28 .setAuthorizationBaseUrl('https://accounts.google.com/o/oauth2/auth') 29 .setTokenUrl('https://accounts.google.com/o/oauth2/token') 30 .setPrivateKey(serviceAccountKey) 31 .setIssuer(serviceAccountEmail) 32 .setPropertyStore(scriptProperties) 33 .setCache(CacheService.getScriptCache()) 34 35 .setClientId(serviceAccountClient_id) 36 37 .setScope(['https://www.googleapis.com/auth/bigquery.readonly']); 38 39} 40 41
あなたの回答
tips
プレビュー