soundTricker

# Fill in your AWS Access Key ID and Secret Access Key
# http://aws.amazon.com/security-credentials
accessKey= Your AWS Access Key ID
secretKey= Your Secret Access Key

soundTricker

var SCOPE_PLUS_ME = "https://www.googleapis.com/auth/plus.me";
var SCOPE_PLUS_PROFILES_READ = "https://www.googleapis.com/auth/plus.profiles.read";
var SCOPE_PLUS_CIRCLES_READ = "https://www.googleapis.com/auth/plus.circles.read";
var SCOPE_PLUS_CIRCLES_WRITE = "https://www.googleapis.com/auth/plus.circles.write";
var SCOPE_PLUS_STREAM_READ = "https://www.googleapis.com/auth/plus.stream.read";
var SCOPE_PLUS_STREAM_WRITE = "https://www.googleapis.com/auth/plus.stream.write";
var SCOPE_PLUS_MEDIA_UPLOAD = "https://www.googleapis.com/auth/plus.media.upload";

var SCOPES = [SCOPE_PLUS_ME,SCOPE_PLUS_STREAM_WRITE].join("+");
var USER_ID = "me";

soundTricker

```
.
├── credentials/
│   ├── cacert.pem
│   ├── pkey.pem
│   ├── secrets.py*
│   └── secrets.pyc
├── inventory/
│   ├── gce.ini
│   ├── gce.py*

soundTricker

//This is a google apps script project json.
//The Import/Export API, that is on the Google Drive API, use this.
//If u have existing project, u can do update, delete, add and rename project's code and file by changing this json structure.
{
  //files property is Google Apps Script Project Files.
  //It has some hash objects.
  "files": [
    //Hash object is Google Apps Script File.
    //It contain id, name, type, source.  
        

soundTricker

package stk;

import java.util.List;

import com.amazonaws.auth.ClasspathPropertiesFileCredentialsProvider;
import com.amazonaws.regions.Region;
import com.amazonaws.regions.Regions;
import com.amazonaws.services.ec2.AmazonEC2;
import com.amazonaws.services.ec2.AmazonEC2Client;
import com.amazonaws.services.ec2.model.AllocateAddressRequest;

soundTricker

function downloadGASFiles(downloadUrl) {

    //Google OAuth用の設定
    var oauthConfig = UrlFetchApp.addOAuthService('drive');

    var scope = 'https://www.googleapis.com/auth/drive+https://www.googleapis.com/auth/drive.file+https://www.googleapis.com/auth/drive.scripts';
    oauthConfig.setConsumerKey('anonymous');
    oauthConfig.setConsumerSecret('anonymous');
    oauthConfig.setRequestTokenUrl('https://www.google.com/accounts/OAuthGetRequestToken?scope='+scope);

soundTricker

function createNewForm() {
  var form = FormApp.create('フォームのタイトル');
}

soundTricker

function writeSpreadsheetDataAsCsv() {
  
  //Spreadsheetからデータ取得
  var data = SpreadsheetApp.openById('id').getSheetByName('sheetName').getDataRange().getValues();
  
  //二次配列→カンマ区切り文字列の一次配列
  var writeDataArray = [];
  
  for(var r = 0; r < data.length; r++) {
    var row = data[r];

soundTricker

function BigQueryLiveDemo() {
  //6219749
  
  var list = BigQuery.Projects.list();
  
  Logger.log(list);
  
  //プロジェクトIDの取得
  var projectId = list.getProjects()[0].getId();
  

soundTricker

function グループ() {
  // {ユーザ名}@{ドメイン名}のユーザ名の部分を指定
  var user = UserManager.getUser("k-ohashi"); 
  
  //全グループの取得
  var groups = GroupsManager.getAllGroups(); 
  
  for(var i = 0; i < groups.length; i++) {
    Logger.log(groups[i].getName());
  }