Gitiles
Code Review Sign In
gerrit-public.fairphone.software / platform / external / python / google-api-python-client / e4e4b403f89a92d0f2d0661bf47d5ccd490d7bbd / . / docs / dyn / sheets_v4.spreadsheets.developerMetadata.html
blob: 085005bb43b28cc567f10c13a66e2e36db49695c [file] [log] [blame]
Bu Sun Kim715bd7f2019-06-14 16:50:42 -0700[diff] [blame]1<html><body>
2<style>
3
4body, h1, h2, h3, div, span, p, pre, a {
5 margin: 0;
6 padding: 0;
7 border: 0;
8 font-weight: inherit;
9 font-style: inherit;
10 font-size: 100%;
11 font-family: inherit;
12 vertical-align: baseline;
13}
14
15body {
16 font-size: 13px;
17 padding: 1em;
18}
19
20h1 {
21 font-size: 26px;
22 margin-bottom: 1em;
23}
24
25h2 {
26 font-size: 24px;
27 margin-bottom: 1em;
28}
29
30h3 {
31 font-size: 20px;
32 margin-bottom: 1em;
33 margin-top: 1em;
34}
35
36pre, code {
37 line-height: 1.5;
38 font-family: Monaco, 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Lucida Console', monospace;
39}
40
41pre {
42 margin-top: 0.5em;
43}
44
45h1, h2, h3, p {
46 font-family: Arial, sans serif;
47}
48
49h1, h2, h3 {
50 border-bottom: solid #CCC 1px;
51}
52
53.toc_element {
54 margin-top: 0.5em;
55}
56
57.firstline {
58 margin-left: 2 em;
59}
60
61.method {
62 margin-top: 1em;
63 border: solid 1px #CCC;
64 padding: 1em;
65 background: #EEE;
66}
67
68.details {
69 font-weight: bold;
70 font-size: 14px;
71}
72
73</style>
74
75<h1><a href="sheets_v4.html">Google Sheets API</a> . <a href="sheets_v4.spreadsheets.html">spreadsheets</a> . <a href="sheets_v4.spreadsheets.developerMetadata.html">developerMetadata</a></h1>
76<h2>Instance Methods</h2>
77<p class="toc_element">
Dmitry Frenkel3e17f892020-10-06 16:46:05 -0700[diff] [blame]78 <code><a href="#close">close()</a></code></p>
79<p class="firstline">Close httplib2 connections.</p>
80<p class="toc_element">
Bu Sun Kim715bd7f2019-06-14 16:50:42 -0700[diff] [blame]81 <code><a href="#get">get(spreadsheetId, metadataId, x__xgafv=None)</a></code></p>
Dmitry Frenkel3e17f892020-10-06 16:46:05 -0700[diff] [blame]82<p class="firstline">Returns the developer metadata with the specified ID. The caller must specify the spreadsheet ID and the developer metadata's unique metadataId.</p>
Bu Sun Kim715bd7f2019-06-14 16:50:42 -0700[diff] [blame]83<p class="toc_element">
Dan O'Mearadd494642020-05-01 07:42:23 -0700[diff] [blame]84 <code><a href="#search">search(spreadsheetId, body=None, x__xgafv=None)</a></code></p>
Dmitry Frenkel3e17f892020-10-06 16:46:05 -0700[diff] [blame]85<p class="firstline">Returns all developer metadata matching the specified DataFilter. If the provided DataFilter represents a DeveloperMetadataLookup object, this will return all DeveloperMetadata entries selected by it. If the DataFilter represents a location in a spreadsheet, this will return all developer metadata associated with locations intersecting that region.</p>
Bu Sun Kim715bd7f2019-06-14 16:50:42 -0700[diff] [blame]86<h3>Method Details</h3>
87<div class="method">
Dmitry Frenkel3e17f892020-10-06 16:46:05 -0700[diff] [blame]88 <code class="details" id="close">close()</code>
89 <pre>Close httplib2 connections.</pre>
90</div>
91
92<div class="method">
Bu Sun Kim715bd7f2019-06-14 16:50:42 -0700[diff] [blame]93 <code class="details" id="get">get(spreadsheetId, metadataId, x__xgafv=None)</code>
Dmitry Frenkel3e17f892020-10-06 16:46:05 -0700[diff] [blame]94 <pre>Returns the developer metadata with the specified ID. The caller must specify the spreadsheet ID and the developer metadata&#x27;s unique metadataId.
Bu Sun Kim715bd7f2019-06-14 16:50:42 -0700[diff] [blame]95
96Args:
97 spreadsheetId: string, The ID of the spreadsheet to retrieve metadata from. (required)
98 metadataId: integer, The ID of the developer metadata to retrieve. (required)
99 x__xgafv: string, V1 error format.
100 Allowed values
101 1 - v1 error format
102 2 - v2 error format
103
104Returns:
105 An object of the form:
106
Dmitry Frenkel3e17f892020-10-06 16:46:05 -0700[diff] [blame]107 { # Developer metadata associated with a location or object in a spreadsheet. Developer metadata may be used to associate arbitrary data with various parts of a spreadsheet and will remain associated at those locations as they move around and the spreadsheet is edited. For example, if developer metadata is associated with row 5 and another row is then subsequently inserted above row 5, that original metadata will still be associated with the row it was first associated with (what is now row 6). If the associated object is deleted its metadata is deleted too.
Bu Sun Kim65020912020-05-20 12:08:20 -0700[diff] [blame]108 &quot;location&quot;: { # A location where metadata may be associated in a spreadsheet. # The location where the metadata is associated.
Yoshi Automation Botb6971b02020-11-26 17:16:03 -0800[diff] [blame]109 &quot;spreadsheet&quot;: True or False, # True when metadata is associated with an entire spreadsheet.
110 &quot;locationType&quot;: &quot;A String&quot;, # The type of location this object represents. This field is read-only.
Dmitry Frenkel3e17f892020-10-06 16:46:05 -0700[diff] [blame]111 &quot;dimensionRange&quot;: { # A range along a single dimension on a sheet. All indexes are zero-based. Indexes are half open: the start index is inclusive and the end index is exclusive. Missing indexes indicate the range is unbounded on that side. # Represents the row or column when metadata is associated with a dimension. The specified DimensionRange must represent a single row or column; it cannot be unbounded or span multiple rows or columns.
Bu Sun Kimd059ad82020-07-22 17:02:09 -0700[diff] [blame]112 &quot;endIndex&quot;: 42, # The end (exclusive) of the span, or not set if unbounded.
Yoshi Automation Botb6971b02020-11-26 17:16:03 -0800[diff] [blame]113 &quot;startIndex&quot;: 42, # The start (inclusive) of the span, or not set if unbounded.
Yoshi Automation Bot0d561ef2020-11-25 07:50:41 -0800[diff] [blame]114 &quot;sheetId&quot;: 42, # The sheet this span is on.
Yoshi Automation Botb6971b02020-11-26 17:16:03 -0800[diff] [blame]115 &quot;dimension&quot;: &quot;A String&quot;, # The dimension of the span.
Bu Sun Kim715bd7f2019-06-14 16:50:42 -0700[diff] [blame]116 },
Yoshi Automation Bot0d561ef2020-11-25 07:50:41 -0800[diff] [blame]117 &quot;sheetId&quot;: 42, # The ID of the sheet when metadata is associated with an entire sheet.
Bu Sun Kim715bd7f2019-06-14 16:50:42 -0700[diff] [blame]118 },
Yoshi Automation Botb6971b02020-11-26 17:16:03 -0800[diff] [blame]119 &quot;visibility&quot;: &quot;A String&quot;, # The metadata visibility. Developer metadata must always have a visibility specified.
Bu Sun Kim673ec5c2020-11-16 11:05:03 -0700[diff] [blame]120 &quot;metadataValue&quot;: &quot;A String&quot;, # Data associated with the metadata&#x27;s key.
Yoshi Automation Botb6971b02020-11-26 17:16:03 -0800[diff] [blame]121 &quot;metadataKey&quot;: &quot;A String&quot;, # The metadata key. There may be multiple metadata in a spreadsheet with the same key. Developer metadata must always have a key specified.
122 &quot;metadataId&quot;: 42, # The spreadsheet-scoped unique ID that identifies the metadata. IDs may be specified when metadata is created, otherwise one will be randomly generated and assigned. Must be positive.
Bu Sun Kim715bd7f2019-06-14 16:50:42 -0700[diff] [blame]123 }</pre>
124</div>
125
126<div class="method">
Dan O'Mearadd494642020-05-01 07:42:23 -0700[diff] [blame]127 <code class="details" id="search">search(spreadsheetId, body=None, x__xgafv=None)</code>
Dmitry Frenkel3e17f892020-10-06 16:46:05 -0700[diff] [blame]128 <pre>Returns all developer metadata matching the specified DataFilter. If the provided DataFilter represents a DeveloperMetadataLookup object, this will return all DeveloperMetadata entries selected by it. If the DataFilter represents a location in a spreadsheet, this will return all developer metadata associated with locations intersecting that region.
Bu Sun Kim715bd7f2019-06-14 16:50:42 -0700[diff] [blame]129
130Args:
131 spreadsheetId: string, The ID of the spreadsheet to retrieve metadata from. (required)
Dan O'Mearadd494642020-05-01 07:42:23 -0700[diff] [blame]132 body: object, The request body.
Bu Sun Kim715bd7f2019-06-14 16:50:42 -0700[diff] [blame]133 The object takes the form of:
134
Dmitry Frenkel3e17f892020-10-06 16:46:05 -0700[diff] [blame]135{ # A request to retrieve all developer metadata matching the set of specified criteria.
136 &quot;dataFilters&quot;: [ # The data filters describing the criteria used to determine which DeveloperMetadata entries to return. DeveloperMetadata matching any of the specified filters are included in the response.
137 { # Filter that describes what data should be selected or returned from a request.
Yoshi Automation Botb6971b02020-11-26 17:16:03 -0800[diff] [blame]138 &quot;a1Range&quot;: &quot;A String&quot;, # Selects data that matches the specified A1 range.
Dmitry Frenkel3e17f892020-10-06 16:46:05 -0700[diff] [blame]139 &quot;developerMetadataLookup&quot;: { # Selects DeveloperMetadata that matches all of the specified fields. For example, if only a metadata ID is specified this considers the DeveloperMetadata with that particular unique ID. If a metadata key is specified, this considers all developer metadata with that key. If a key, visibility, and location type are all specified, this considers all developer metadata with that key and visibility that are associated with a location of that type. In general, this selects all DeveloperMetadata that matches the intersection of all the specified fields; any field or combination of fields may be specified. # Selects data associated with the developer metadata matching the criteria described by this DeveloperMetadataLookup.
Yoshi Automation Botc2228be2020-11-24 15:48:03 -0800[diff] [blame]140 &quot;metadataKey&quot;: &quot;A String&quot;, # Limits the selected developer metadata to that which has a matching DeveloperMetadata.metadata_key.
Dmitry Frenkel3e17f892020-10-06 16:46:05 -0700[diff] [blame]141 &quot;metadataLocation&quot;: { # A location where metadata may be associated in a spreadsheet. # Limits the selected developer metadata to those entries associated with the specified location. This field either matches exact locations or all intersecting locations according the specified locationMatchingStrategy.
Yoshi Automation Botb6971b02020-11-26 17:16:03 -0800[diff] [blame]142 &quot;spreadsheet&quot;: True or False, # True when metadata is associated with an entire spreadsheet.
143 &quot;locationType&quot;: &quot;A String&quot;, # The type of location this object represents. This field is read-only.
Dmitry Frenkel3e17f892020-10-06 16:46:05 -0700[diff] [blame]144 &quot;dimensionRange&quot;: { # A range along a single dimension on a sheet. All indexes are zero-based. Indexes are half open: the start index is inclusive and the end index is exclusive. Missing indexes indicate the range is unbounded on that side. # Represents the row or column when metadata is associated with a dimension. The specified DimensionRange must represent a single row or column; it cannot be unbounded or span multiple rows or columns.
Bu Sun Kimd059ad82020-07-22 17:02:09 -0700[diff] [blame]145 &quot;endIndex&quot;: 42, # The end (exclusive) of the span, or not set if unbounded.
Yoshi Automation Botb6971b02020-11-26 17:16:03 -0800[diff] [blame]146 &quot;startIndex&quot;: 42, # The start (inclusive) of the span, or not set if unbounded.
Yoshi Automation Bot0d561ef2020-11-25 07:50:41 -0800[diff] [blame]147 &quot;sheetId&quot;: 42, # The sheet this span is on.
Yoshi Automation Botb6971b02020-11-26 17:16:03 -0800[diff] [blame]148 &quot;dimension&quot;: &quot;A String&quot;, # The dimension of the span.
Bu Sun Kim4ed7d3f2020-05-27 12:20:54 -0700[diff] [blame]149 },
Yoshi Automation Bot0d561ef2020-11-25 07:50:41 -0800[diff] [blame]150 &quot;sheetId&quot;: 42, # The ID of the sheet when metadata is associated with an entire sheet.
Bu Sun Kim4ed7d3f2020-05-27 12:20:54 -0700[diff] [blame]151 },
Yoshi Automation Bot0d561ef2020-11-25 07:50:41 -0800[diff] [blame]152 &quot;locationType&quot;: &quot;A String&quot;, # Limits the selected developer metadata to those entries which are associated with locations of the specified type. For example, when this field is specified as ROW this lookup only considers developer metadata associated on rows. If the field is left unspecified, all location types are considered. This field cannot be specified as SPREADSHEET when the locationMatchingStrategy is specified as INTERSECTING or when the metadataLocation is specified as a non-spreadsheet location: spreadsheet metadata cannot intersect any other developer metadata location. This field also must be left unspecified when the locationMatchingStrategy is specified as EXACT.
Yoshi Automation Botb6971b02020-11-26 17:16:03 -0800[diff] [blame]153 &quot;visibility&quot;: &quot;A String&quot;, # Limits the selected developer metadata to that which has a matching DeveloperMetadata.visibility. If left unspecified, all developer metadata visibile to the requesting project is considered.
Yoshi Automation Bot0d561ef2020-11-25 07:50:41 -0800[diff] [blame]154 &quot;locationMatchingStrategy&quot;: &quot;A String&quot;, # Determines how this lookup matches the location. If this field is specified as EXACT, only developer metadata associated on the exact location specified is matched. If this field is specified to INTERSECTING, developer metadata associated on intersecting locations is also matched. If left unspecified, this field assumes a default value of INTERSECTING. If this field is specified, a metadataLocation must also be specified.
Yoshi Automation Botb6971b02020-11-26 17:16:03 -0800[diff] [blame]155 &quot;metadataValue&quot;: &quot;A String&quot;, # Limits the selected developer metadata to that which has a matching DeveloperMetadata.metadata_value.
156 &quot;metadataId&quot;: 42, # Limits the selected developer metadata to that which has a matching DeveloperMetadata.metadata_id.
Bu Sun Kim4ed7d3f2020-05-27 12:20:54 -0700[diff] [blame]157 },
Yoshi Automation Bot0d561ef2020-11-25 07:50:41 -0800[diff] [blame]158 &quot;gridRange&quot;: { # A range on a sheet. All indexes are zero-based. Indexes are half open, i.e. the start index is inclusive and the end index is exclusive -- [start_index, end_index). Missing indexes indicate the range is unbounded on that side. For example, if `&quot;Sheet1&quot;` is sheet ID 0, then: `Sheet1!A1:A1 == sheet_id: 0, start_row_index: 0, end_row_index: 1, start_column_index: 0, end_column_index: 1` `Sheet1!A3:B4 == sheet_id: 0, start_row_index: 2, end_row_index: 4, start_column_index: 0, end_column_index: 2` `Sheet1!A:B == sheet_id: 0, start_column_index: 0, end_column_index: 2` `Sheet1!A5:B == sheet_id: 0, start_row_index: 4, start_column_index: 0, end_column_index: 2` `Sheet1 == sheet_id:0` The start index must always be less than or equal to the end index. If the start index equals the end index, then the range is empty. Empty ranges are typically not meaningful and are usually rendered in the UI as `#REF!`. # Selects data that matches the range described by the GridRange.
Yoshi Automation Bot0d561ef2020-11-25 07:50:41 -0800[diff] [blame]159 &quot;startRowIndex&quot;: 42, # The start row (inclusive) of the range, or not set if unbounded.
160 &quot;sheetId&quot;: 42, # The sheet this range is on.
Yoshi Automation Bot0d561ef2020-11-25 07:50:41 -0800[diff] [blame]161 &quot;endColumnIndex&quot;: 42, # The end column (exclusive) of the range, or not set if unbounded.
Yoshi Automation Botb6971b02020-11-26 17:16:03 -0800[diff] [blame]162 &quot;startColumnIndex&quot;: 42, # The start column (inclusive) of the range, or not set if unbounded.
163 &quot;endRowIndex&quot;: 42, # The end row (exclusive) of the range, or not set if unbounded.
Yoshi Automation Bot0d561ef2020-11-25 07:50:41 -0800[diff] [blame]164 },
Bu Sun Kim715bd7f2019-06-14 16:50:42 -0700[diff] [blame]165 },
166 ],
167 }
168
169 x__xgafv: string, V1 error format.
170 Allowed values
171 1 - v1 error format
172 2 - v2 error format
173
174Returns:
175 An object of the form:
176
177 { # A reply to a developer metadata search request.
Bu Sun Kim65020912020-05-20 12:08:20 -0700[diff] [blame]178 &quot;matchedDeveloperMetadata&quot;: [ # The metadata matching the criteria of the search request.
Dmitry Frenkel3e17f892020-10-06 16:46:05 -0700[diff] [blame]179 { # A developer metadata entry and the data filters specified in the original request that matched it.
Yoshi Automation Bot0d561ef2020-11-25 07:50:41 -0800[diff] [blame]180 &quot;developerMetadata&quot;: { # Developer metadata associated with a location or object in a spreadsheet. Developer metadata may be used to associate arbitrary data with various parts of a spreadsheet and will remain associated at those locations as they move around and the spreadsheet is edited. For example, if developer metadata is associated with row 5 and another row is then subsequently inserted above row 5, that original metadata will still be associated with the row it was first associated with (what is now row 6). If the associated object is deleted its metadata is deleted too. # The developer metadata matching the specified filters.
Yoshi Automation Bot0d561ef2020-11-25 07:50:41 -0800[diff] [blame]181 &quot;location&quot;: { # A location where metadata may be associated in a spreadsheet. # The location where the metadata is associated.
Yoshi Automation Botb6971b02020-11-26 17:16:03 -0800[diff] [blame]182 &quot;spreadsheet&quot;: True or False, # True when metadata is associated with an entire spreadsheet.
183 &quot;locationType&quot;: &quot;A String&quot;, # The type of location this object represents. This field is read-only.
Yoshi Automation Bot0d561ef2020-11-25 07:50:41 -0800[diff] [blame]184 &quot;dimensionRange&quot;: { # A range along a single dimension on a sheet. All indexes are zero-based. Indexes are half open: the start index is inclusive and the end index is exclusive. Missing indexes indicate the range is unbounded on that side. # Represents the row or column when metadata is associated with a dimension. The specified DimensionRange must represent a single row or column; it cannot be unbounded or span multiple rows or columns.
Yoshi Automation Bot0d561ef2020-11-25 07:50:41 -0800[diff] [blame]185 &quot;endIndex&quot;: 42, # The end (exclusive) of the span, or not set if unbounded.
Yoshi Automation Botb6971b02020-11-26 17:16:03 -0800[diff] [blame]186 &quot;startIndex&quot;: 42, # The start (inclusive) of the span, or not set if unbounded.
Yoshi Automation Bot0d561ef2020-11-25 07:50:41 -0800[diff] [blame]187 &quot;sheetId&quot;: 42, # The sheet this span is on.
Yoshi Automation Botb6971b02020-11-26 17:16:03 -0800[diff] [blame]188 &quot;dimension&quot;: &quot;A String&quot;, # The dimension of the span.
Yoshi Automation Bot0d561ef2020-11-25 07:50:41 -0800[diff] [blame]189 },
190 &quot;sheetId&quot;: 42, # The ID of the sheet when metadata is associated with an entire sheet.
Yoshi Automation Bot0d561ef2020-11-25 07:50:41 -0800[diff] [blame]191 },
Yoshi Automation Botb6971b02020-11-26 17:16:03 -0800[diff] [blame]192 &quot;visibility&quot;: &quot;A String&quot;, # The metadata visibility. Developer metadata must always have a visibility specified.
Yoshi Automation Bot0d561ef2020-11-25 07:50:41 -0800[diff] [blame]193 &quot;metadataValue&quot;: &quot;A String&quot;, # Data associated with the metadata&#x27;s key.
Yoshi Automation Botb6971b02020-11-26 17:16:03 -0800[diff] [blame]194 &quot;metadataKey&quot;: &quot;A String&quot;, # The metadata key. There may be multiple metadata in a spreadsheet with the same key. Developer metadata must always have a key specified.
195 &quot;metadataId&quot;: 42, # The spreadsheet-scoped unique ID that identifies the metadata. IDs may be specified when metadata is created, otherwise one will be randomly generated and assigned. Must be positive.
Yoshi Automation Bot0d561ef2020-11-25 07:50:41 -0800[diff] [blame]196 },
Yoshi Automation Botb6971b02020-11-26 17:16:03 -0800[diff] [blame]197 &quot;dataFilters&quot;: [ # All filters matching the returned developer metadata.
198 { # Filter that describes what data should be selected or returned from a request.
199 &quot;a1Range&quot;: &quot;A String&quot;, # Selects data that matches the specified A1 range.
200 &quot;developerMetadataLookup&quot;: { # Selects DeveloperMetadata that matches all of the specified fields. For example, if only a metadata ID is specified this considers the DeveloperMetadata with that particular unique ID. If a metadata key is specified, this considers all developer metadata with that key. If a key, visibility, and location type are all specified, this considers all developer metadata with that key and visibility that are associated with a location of that type. In general, this selects all DeveloperMetadata that matches the intersection of all the specified fields; any field or combination of fields may be specified. # Selects data associated with the developer metadata matching the criteria described by this DeveloperMetadataLookup.
201 &quot;metadataKey&quot;: &quot;A String&quot;, # Limits the selected developer metadata to that which has a matching DeveloperMetadata.metadata_key.
202 &quot;metadataLocation&quot;: { # A location where metadata may be associated in a spreadsheet. # Limits the selected developer metadata to those entries associated with the specified location. This field either matches exact locations or all intersecting locations according the specified locationMatchingStrategy.
203 &quot;spreadsheet&quot;: True or False, # True when metadata is associated with an entire spreadsheet.
204 &quot;locationType&quot;: &quot;A String&quot;, # The type of location this object represents. This field is read-only.
205 &quot;dimensionRange&quot;: { # A range along a single dimension on a sheet. All indexes are zero-based. Indexes are half open: the start index is inclusive and the end index is exclusive. Missing indexes indicate the range is unbounded on that side. # Represents the row or column when metadata is associated with a dimension. The specified DimensionRange must represent a single row or column; it cannot be unbounded or span multiple rows or columns.
206 &quot;endIndex&quot;: 42, # The end (exclusive) of the span, or not set if unbounded.
207 &quot;startIndex&quot;: 42, # The start (inclusive) of the span, or not set if unbounded.
208 &quot;sheetId&quot;: 42, # The sheet this span is on.
209 &quot;dimension&quot;: &quot;A String&quot;, # The dimension of the span.
210 },
211 &quot;sheetId&quot;: 42, # The ID of the sheet when metadata is associated with an entire sheet.
212 },
213 &quot;locationType&quot;: &quot;A String&quot;, # Limits the selected developer metadata to those entries which are associated with locations of the specified type. For example, when this field is specified as ROW this lookup only considers developer metadata associated on rows. If the field is left unspecified, all location types are considered. This field cannot be specified as SPREADSHEET when the locationMatchingStrategy is specified as INTERSECTING or when the metadataLocation is specified as a non-spreadsheet location: spreadsheet metadata cannot intersect any other developer metadata location. This field also must be left unspecified when the locationMatchingStrategy is specified as EXACT.
214 &quot;visibility&quot;: &quot;A String&quot;, # Limits the selected developer metadata to that which has a matching DeveloperMetadata.visibility. If left unspecified, all developer metadata visibile to the requesting project is considered.
215 &quot;locationMatchingStrategy&quot;: &quot;A String&quot;, # Determines how this lookup matches the location. If this field is specified as EXACT, only developer metadata associated on the exact location specified is matched. If this field is specified to INTERSECTING, developer metadata associated on intersecting locations is also matched. If left unspecified, this field assumes a default value of INTERSECTING. If this field is specified, a metadataLocation must also be specified.
216 &quot;metadataValue&quot;: &quot;A String&quot;, # Limits the selected developer metadata to that which has a matching DeveloperMetadata.metadata_value.
217 &quot;metadataId&quot;: 42, # Limits the selected developer metadata to that which has a matching DeveloperMetadata.metadata_id.
218 },
219 &quot;gridRange&quot;: { # A range on a sheet. All indexes are zero-based. Indexes are half open, i.e. the start index is inclusive and the end index is exclusive -- [start_index, end_index). Missing indexes indicate the range is unbounded on that side. For example, if `&quot;Sheet1&quot;` is sheet ID 0, then: `Sheet1!A1:A1 == sheet_id: 0, start_row_index: 0, end_row_index: 1, start_column_index: 0, end_column_index: 1` `Sheet1!A3:B4 == sheet_id: 0, start_row_index: 2, end_row_index: 4, start_column_index: 0, end_column_index: 2` `Sheet1!A:B == sheet_id: 0, start_column_index: 0, end_column_index: 2` `Sheet1!A5:B == sheet_id: 0, start_row_index: 4, start_column_index: 0, end_column_index: 2` `Sheet1 == sheet_id:0` The start index must always be less than or equal to the end index. If the start index equals the end index, then the range is empty. Empty ranges are typically not meaningful and are usually rendered in the UI as `#REF!`. # Selects data that matches the range described by the GridRange.
220 &quot;startRowIndex&quot;: 42, # The start row (inclusive) of the range, or not set if unbounded.
221 &quot;sheetId&quot;: 42, # The sheet this range is on.
222 &quot;endColumnIndex&quot;: 42, # The end column (exclusive) of the range, or not set if unbounded.
223 &quot;startColumnIndex&quot;: 42, # The start column (inclusive) of the range, or not set if unbounded.
224 &quot;endRowIndex&quot;: 42, # The end row (exclusive) of the range, or not set if unbounded.
225 },
226 },
227 ],
Bu Sun Kim715bd7f2019-06-14 16:50:42 -0700[diff] [blame]228 },
229 ],
230 }</pre>
231</div>
232
233</body></html>