google apps script - Get the spreadsheet key that is in the URL. Not ss.getId() -


How to get a spreadsheet ID in the URL I'm aware of using SpreadsheetApp.getActiveSpreadsheet (). GetId () and SpreadsheetApp.getActiveSpreadsheet (). GetURL ()

but getId () / getURL () / getKey () now fails with Google Drive-SDK. I am not able to use this ID to open a file with drive-SDK. It was working about 1 week ago, but the drive-SDK now fails to open the file.

Using an ID that is present in the URL is an alternative solution. After the key ID =

But I want automatic ways to get it, not a manual process. Using a template as a spreadsheet, I have no way of knowing ID, so is there a way to get it?

Note 1: stackoverflow.com/questions/18583885/ Google Drive SDK issues should be posted on the Stackoverflow flow

Note 2: ID in getUrl () and getKey () As the IID () is not the same key. So it seems that the key has been removed from access, so I do not have much hope.

Edit

Drive code is Java instead of Google Apps-script version 1.15.0-RC Drive drive service = new drive. Builder (Transport, JSN-Factory, Credential) .setApplicationName ("CellMaster.Com.au"). Build (); File file = driveService.files (). Get (this.spreadsheetKey) .execute ();

I think it broke in the last week or so at some time. It fails with executed (), it generates a 404 error returns this error when I use it with a small spreadsheet that is created by Google Apps Script but whenever I use the browser URL key value I'm still working fine.

You do not show codes which is not working for you, but for me the following works are okay 

  function myFunction () {// A new spreadsheet workbook var ss = SpreadsheetApp.create ("Test"); Var id = ss.getId (); Get SS file via drive using Logger.log (id) // Spreadsheet ID var file = DriveApp.getFileById (id); Var driveid = file.getId (); Open the spreadsheet using the logger.log (driveid) // file ID ssfromdrive = SpreadsheetApp.openById (driveid); Logger.log (ssfromdrive.getName ())}

Comments

Post a Comment

Popular posts from this blog

ios - How do I use CFArrayRef in Swift? -

I am using Objective-class in my Swift Project through a bridging header. The method signature looks like this: - Some cement (some type) some parameters; I started by getting an example of class, calling method, and storing the value: var myInstance = MyClassWithThatMethod (); Var cfArr = myInstance.someMethod (some value); Then try to get the value in the array: var valueInArrayThatIWant = CFArrayGetValueAtIndex (cfArr, 0); However, I get the error unmanaged & lt; Cfarray & gt; Not like 'CFArray' . Unmanaged & lt; Cfarray & gt; also means? I looked, but I do not need to change the array in a fast array (though it would be good). I need to be able to get value from the array. I also tried CFArray method to pass in a function: func doSomeStuffOnArray (myArray: NSArray) {} Although I get the same error when using: doSomeStuffOnArray (cfArr); // unmanaged & lt; CFArray & gt; I am using CFArray because I want to sto...
Read more

eclipse plugin - Run java code error: Workspace is closed -

To create an automated project, I created a plug-in project with the following dependencies: Org.eclipse.core.resources org.eclipse.equinox.registry org.eclipse.core.runtime and the following The Java class is located in the src folder: Package Examiner; Import org.eclipse.core.resources.IProject; Import org.eclipse.core.resources.IWorkspaceRoot; Import org.eclipse.core.resources.ResourcesPlugin; Import org.eclipse.core.runtime.CoreException; Import org.eclipse.core.runtime.IProgressMonitor; Import org.eclipse.core.runtime.NullProgressMonitor; Public class tes {public static zero main (string [] args) {// TODO auto generated method stub IProgressMonitor progress monitor = new NullProgressMonitor (); IWorkspaceRoot root = ResourcesPlugin.getWorkspace (). GetRoot (); Ipoject project = root.jetproject ("desired projectname"); Try {Project.create (progress monitor); Project.open (progressMonitor); } Grip (CoreException E) {// TODO Auto generated blocking block e....
Read more

c - Error on building source code in VC 6 -

When I create my project in VC6, the BScMKE reports the following error Linking .. Creating Library ... .. / ... / PB / Bean / Debub / ICEERP.Lib and Object ........ P.B. / Bean / DBube / ICREPlay.APP Browse information file ... BSMMK: ​​error can not be read from BK 1505: file '../../PB/bin/TmpOut/ICReplay/Debug/ICReplay_PB.bsc' Error executing bscmake.exe Can someone help me? 2 Reason for reference from: "ICReplay_PB .bsc "file will be corrupted The trunk of the file will be happening with the compiler running out of disk space or is being interrupted when creating .sbr file I think this answer will help you!
Read more