Guest User

Untitled

a guest
Jan 20th, 2019
140
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.90 KB | None | 0 0
  1. file = service.get_file(file_id,fields: 'parents')
  2. service.update_file(
  3. file_id,
  4. file
  5. remove_parents: file.parents,
  6. add_parents: new_folder_id,
  7. fields: 'id,parents'
  8. )
  9.  
  10. fileId = '1sTWaJ_j7PkjzaBWtNc3IzovK5hQf21FbOw9yLeeLPNQ'
  11. folderId = '0BwwA4oUTeiV1TGRPeTVjaWRDY1E'
  12. // Retrieve the existing parents to remove
  13. drive.files.get({
  14. fileId: fileId,
  15. fields: 'parents'
  16. }, function(err, file) {
  17. if (err) {
  18. // Handle error
  19. console.log(err);
  20. } else {
  21. // Move the file to the new folder
  22. var previousParents = file.parents.join(',');
  23. drive.files.update({
  24. fileId: fileId,
  25. addParents: folderId,
  26. removeParents: previousParents,
  27. fields: 'id, parents'
  28. }, function(err, file) {
  29. if(err) {
  30. // Handle error
  31. } else {
  32. // File moved.
  33. }
  34. });
  35. }
  36. });
  37.  
  38. function create_ss_in_folder(folder, name) {
  39. var ss = SpreadsheetApp.create(name);
  40. var id = ss.getId();
  41. var file = DriveApp.getFileById(id);
  42. var folder = get_folder_by_name(folder);
  43. folder.addFile(file);
  44. DriveApp.getRootFolder().removeFile(file);
  45. return id;
  46. }
  47.  
  48. //Move it to desired folder
  49. var fileID = 'Your file ID'
  50. var folderID = 'Folder ID'
  51. var file = DriveApp.getFileById(fileID).getName()
  52. var folder = DriveApp.getFolderById(folderID)
  53. var newFile = file.makeCopy(file, folder)
  54.  
  55. // This will remove it from root.
  56. DriveApp.getFileById(fileID).setTrashed(true)
  57.  
  58. function createInCurrentFolder() {
  59. // Create a new form in drive root
  60. var form = FormApp.create("New_Form");
  61. var formFile = DriveApp.getFileById(form.getId())
  62.  
  63. // Get the parent folders of the open document
  64. var ss = SpreadsheetApp.getActiveSpreadsheet();
  65. var ssFile = DriveApp.getFileById(ss.getId());
  66. var ssParents = ssFile.getParents();
  67.  
  68. // Check if we have a parent and
  69. // assume the first parent to be the current folder
  70. if (ssParents.hasNext()){
  71. var parentFolder = ssParents.next();
  72.  
  73. // Check for root folder
  74. if (parentFolder.getId() == DriveApp.getRootFolder().getId()) return;
  75.  
  76. // Add the created form to current folder
  77. // and remove it from root folder
  78. parentFolder.addFile(formFile);
  79. DriveApp.removeFile(formFile);
  80. }
  81. }
  82.  
  83. function getClient()
  84. {
  85. $client = new Google_Client();
  86.  
  87. putenv(
  88. 'GOOGLE_APPLICATION_CREDENTIALS='.__DIR__."/config/google-creds.json"
  89. );
  90. $client = new Google_Client();
  91. $client->setScopes(
  92. [
  93. Google_Service_Drive::DRIVE,
  94. Google_Service_Storage::CLOUD_PLATFORM,
  95. 'https://www.googleapis.com/auth/spreadsheets',
  96. ]
  97. );
  98. $client->useApplicationDefaultCredentials();
  99.  
  100. return $client;
  101. }
  102.  
  103. // Get the API client and construct the service object.
  104. $client = getClient();
  105. $service = new Google_Service_Drive($client);
  106.  
  107. $ROOT_FOLDER_ID='you-must-set-this-to-your-folder-id';
  108. // create the empty sheet:
  109.  
  110. $googleServiceDriveDriveFile = new Google_Service_Drive_DriveFile();
  111. $googleServiceDriveDriveFile->setMimeType(
  112. 'application/vnd.google-apps.spreadsheet')
  113. ;
  114. $googleServiceDriveDriveFile->setName('Test');
  115. $googleServiceDriveDriveFile->setParents([$ROOT_FOLDER_ID]);
  116. $res = $service->files->create($googleServiceDriveDriveFile);
  117.  
  118. // list the files in the folder:
  119. print 'Created file with id : ' . $res->getId() . "n";
  120.  
  121. // Print the names and IDs for up to 10 files.
  122. $optParams = array(
  123. 'pageSize' => 10,
  124. 'fields' => 'nextPageToken, files(id, name)',
  125. 'q' => "'$ROOT_FOLDER_ID' in parents"
  126. );
  127.  
  128. $results = $service->files->listFiles($optParams);
  129.  
  130. if (count($results->getFiles()) == 0) {
  131. print "No files found.n";
  132. } else {
  133. print "Files:n";
  134. foreach ($results->getFiles() as $file) {
  135. printf("%s (%s)n", $file->getName(), $file->getId());
  136. }
  137. }
  138. // fetch the sheet you created and edit it.
  139. $service = new Google_Service_Sheets($client);
  140. $sheet = $service->spreadsheets->get($res->getId());
  141.  
  142. print "Fetched sheet with name: " . $sheet->getSpreadsheetUrl() . "n";
Add Comment
Please, Sign In to add comment