The Sheets API v3 provides a feed to access the sheet metadataĬontained within a given spreadsheet (row and cell data is accessed throughĪ separate feed). Using the Drive API files.list method to list all of a user’s spreadsheets Via the Drive API Files.list method, using In the cases where listing spreadsheets is required, it can be replicated Migrating your app to use the drive.file scope in combination with the The Sheets API v4 does not provide this specific operation. Spreadsheets accessible by the authenticated user.
The Sheets API v3 feed allows an application to retrieve a list of all the Sheets in a particular spreadsheet: GET spreadsheetId?fields= Create a spreadsheet Subsets analogous to the basic visibility setting the Sheets API v3.Ĭollection restrict the amount of data they return through the use ofįor example, the following query only returns the titles of all the
While the Sheets API v4 can return a full data set, it does not define fixed The smaller subset of data provided by the basic projection is valuableįor making code more efficient, but cannot be customized.
(after the visibility setting): spreadsheetId/public/ basic Like visibility, the projection must be specified in the API endpoint Smaller, fixed subset of data (for the worksheets, list, and cells feeds). Projection returns all the available information, whereas basic returns a There are only two possible projection settings in the Sheets API v3. You specify in your application determine which permissions it asks for. When your app runs, it asks users to grant certain permissions the scopes that This is represented in this page by the rowId placeholder. The v3 API also assigns an ID to rows retrieved using its When using the methodsĭescribed on this page, substitute in the actual IDs in these locations. Refer to the spreadsheet and sheet IDs, respectively. URL, as query parameters, or as part of a request body. These values appear either as part of the API endpoint The APIs often require you to specify a spreadsheet ID This is synonymous with the term "sheets" that the v4 API uses. The v3 API refers to sheets within a particular spreadsheet as "worksheets". Note that the v4 API's JSON structures are not backward-compatible with theįor more information about the resources available in the Sheets v4 API, see the Other aspects, such as adding sheets or updating sheet properties are handled by The mapping focuses largely on theĬollection, which provides direct cell read and write functionality. This page provides a mapping between the older Sheets API v3 commands and theirĮquivalent operations in Sheets API v4. Interface, and adds a substantial amount of functionality that is not possible The v4 version is JSON-based, has an easier-to-use If you have existing apps based on the Google Sheets API v3, you can migrate to Important: The Google Sheets API v3 was turned down on August 2, 2021.
0 kommentar(er)
