Class
/GOOG/CL_SHEETS_V4
- Inheriting from:
/GOOG/CL_HTTP_CLIENT
- Description:
Google Sheets API v4
Types
Type | Description | Visibility |
---|---|---|
TY_001 |
AddBandingRequest |
PUBLIC |
TY_002 |
AddBandingResponse |
PUBLIC |
TY_003 |
AddChartRequest |
PUBLIC |
TY_004 |
AddChartResponse |
PUBLIC |
TY_005 |
AddConditionalFormatRuleRequest |
PUBLIC |
TY_006 |
AddDataSourceRequest |
PUBLIC |
TY_007 |
AddDataSourceResponse |
PUBLIC |
TY_008 |
AddDimensionGroupRequest |
PUBLIC |
TY_009 |
AddDimensionGroupResponse |
PUBLIC |
TY_010 |
AddFilterViewRequest |
PUBLIC |
TY_011 |
AddFilterViewResponse |
PUBLIC |
TY_012 |
AddNamedRangeRequest |
PUBLIC |
TY_013 |
AddNamedRangeResponse |
PUBLIC |
TY_014 |
AddProtectedRangeRequest |
PUBLIC |
TY_015 |
AddProtectedRangeResponse |
PUBLIC |
TY_016 |
AddSheetRequest |
PUBLIC |
TY_017 |
AddSheetResponse |
PUBLIC |
TY_018 |
AddSlicerRequest |
PUBLIC |
TY_019 |
AddSlicerResponse |
PUBLIC |
TY_020 |
AppendCellsRequest |
PUBLIC |
TY_021 |
AppendDimensionRequest |
PUBLIC |
TY_022 |
AppendValuesResponse |
PUBLIC |
TY_023 |
AutoFillRequest |
PUBLIC |
TY_024 |
AutoResizeDimensionsRequest |
PUBLIC |
TY_025 |
BandedRange |
PUBLIC |
TY_026 |
BandingProperties |
PUBLIC |
TY_027 |
BaselineValueFormat |
PUBLIC |
TY_028 |
BasicChartAxis |
PUBLIC |
TY_029 |
BasicChartDomain |
PUBLIC |
TY_030 |
BasicChartSeries |
PUBLIC |
TY_031 |
BasicChartSpec |
PUBLIC |
TY_032 |
BasicFilter |
PUBLIC |
TY_033 |
BasicSeriesDataPointStyleOverride |
PUBLIC |
TY_034 |
BatchClearValuesByDataFilterRequest |
PUBLIC |
TY_035 |
BatchClearValuesByDataFilterResponse |
PUBLIC |
TY_036 |
BatchClearValuesRequest |
PUBLIC |
TY_037 |
BatchClearValuesResponse |
PUBLIC |
TY_038 |
BatchGetValuesByDataFilterRequest |
PUBLIC |
TY_039 |
BatchGetValuesByDataFilterResponse |
PUBLIC |
TY_040 |
BatchGetValuesResponse |
PUBLIC |
TY_041 |
BatchUpdateSpreadsheetRequest |
PUBLIC |
TY_042 |
BatchUpdateSpreadsheetResponse |
PUBLIC |
TY_043 |
BatchUpdateValuesByDataFilterRequest |
PUBLIC |
TY_044 |
BatchUpdateValuesByDataFilterResponse |
PUBLIC |
TY_045 |
BatchUpdateValuesRequest |
PUBLIC |
TY_046 |
BatchUpdateValuesResponse |
PUBLIC |
TY_047 |
BigQueryDataSourceSpec |
PUBLIC |
TY_048 |
BigQueryQuerySpec |
PUBLIC |
TY_049 |
BigQueryTableSpec |
PUBLIC |
TY_050 |
BooleanCondition |
PUBLIC |
TY_051 |
BooleanRule |
PUBLIC |
TY_052 |
Border |
PUBLIC |
TY_053 |
Borders |
PUBLIC |
TY_054 |
BubbleChartSpec |
PUBLIC |
TY_055 |
CandlestickChartSpec |
PUBLIC |
TY_056 |
CandlestickData |
PUBLIC |
TY_057 |
CandlestickDomain |
PUBLIC |
TY_058 |
CandlestickSeries |
PUBLIC |
TY_059 |
CellData |
PUBLIC |
TY_060 |
CellFormat |
PUBLIC |
TY_061 |
ChartAxisViewWindowOptions |
PUBLIC |
TY_062 |
ChartCustomNumberFormatOptions |
PUBLIC |
TY_063 |
ChartData |
PUBLIC |
TY_064 |
ChartDateTimeRule |
PUBLIC |
TY_065 |
ChartGroupRule |
PUBLIC |
TY_066 |
ChartHistogramRule |
PUBLIC |
TY_067 |
ChartSourceRange |
PUBLIC |
TY_068 |
ChartSpec |
PUBLIC |
TY_069 |
ClearBasicFilterRequest |
PUBLIC |
TY_071 |
ClearValuesResponse |
PUBLIC |
TY_072 |
Color |
PUBLIC |
TY_073 |
ColorStyle |
PUBLIC |
TY_074 |
ConditionValue |
PUBLIC |
TY_075 |
ConditionalFormatRule |
PUBLIC |
TY_076 |
CopyPasteRequest |
PUBLIC |
TY_077 |
CopySheetToAnotherSpreadsheetRequest |
PUBLIC |
TY_078 |
CreateDeveloperMetadataRequest |
PUBLIC |
TY_079 |
CreateDeveloperMetadataResponse |
PUBLIC |
TY_080 |
CutPasteRequest |
PUBLIC |
TY_081 |
DataExecutionStatus |
PUBLIC |
TY_082 |
DataFilter |
PUBLIC |
TY_083 |
DataFilterValueRange |
PUBLIC |
TY_084 |
DataLabel |
PUBLIC |
TY_085 |
DataSource |
PUBLIC |
TY_086 |
DataSourceChartProperties |
PUBLIC |
TY_087 |
DataSourceColumn |
PUBLIC |
TY_088 |
DataSourceColumnReference |
PUBLIC |
TY_089 |
DataSourceFormula |
PUBLIC |
TY_090 |
DataSourceObjectReference |
PUBLIC |
TY_091 |
DataSourceObjectReferences |
PUBLIC |
TY_092 |
DataSourceParameter |
PUBLIC |
TY_093 |
DataSourceRefreshDailySchedule |
PUBLIC |
TY_094 |
DataSourceRefreshMonthlySchedule |
PUBLIC |
TY_095 |
DataSourceRefreshSchedule |
PUBLIC |
TY_096 |
DataSourceRefreshWeeklySchedule |
PUBLIC |
TY_097 |
DataSourceSheetDimensionRange |
PUBLIC |
TY_098 |
DataSourceSheetProperties |
PUBLIC |
TY_099 |
DataSourceSpec |
PUBLIC |
TY_100 |
DataSourceTable |
PUBLIC |
TY_101 |
DataValidationRule |
PUBLIC |
TY_102 |
DateTimeRule |
PUBLIC |
TY_103 |
DeleteBandingRequest |
PUBLIC |
TY_104 |
DeleteConditionalFormatRuleRequest |
PUBLIC |
TY_105 |
DeleteConditionalFormatRuleResponse |
PUBLIC |
TY_106 |
DeleteDataSourceRequest |
PUBLIC |
TY_107 |
DeleteDeveloperMetadataRequest |
PUBLIC |
TY_108 |
DeleteDeveloperMetadataResponse |
PUBLIC |
TY_109 |
DeleteDimensionGroupRequest |
PUBLIC |
TY_110 |
DeleteDimensionGroupResponse |
PUBLIC |
TY_111 |
DeleteDimensionRequest |
PUBLIC |
TY_112 |
DeleteDuplicatesRequest |
PUBLIC |
TY_113 |
DeleteDuplicatesResponse |
PUBLIC |
TY_114 |
DeleteEmbeddedObjectRequest |
PUBLIC |
TY_115 |
DeleteFilterViewRequest |
PUBLIC |
TY_116 |
DeleteNamedRangeRequest |
PUBLIC |
TY_117 |
DeleteProtectedRangeRequest |
PUBLIC |
TY_118 |
DeleteRangeRequest |
PUBLIC |
TY_119 |
DeleteSheetRequest |
PUBLIC |
TY_120 |
DeveloperMetadata |
PUBLIC |
TY_121 |
DeveloperMetadataLocation |
PUBLIC |
TY_122 |
DeveloperMetadataLookup |
PUBLIC |
TY_123 |
DimensionGroup |
PUBLIC |
TY_124 |
DimensionProperties |
PUBLIC |
TY_125 |
DimensionRange |
PUBLIC |
TY_126 |
DuplicateFilterViewRequest |
PUBLIC |
TY_127 |
DuplicateFilterViewResponse |
PUBLIC |
TY_128 |
DuplicateSheetRequest |
PUBLIC |
TY_129 |
DuplicateSheetResponse |
PUBLIC |
TY_130 |
Editors |
PUBLIC |
TY_131 |
EmbeddedChart |
PUBLIC |
TY_132 |
EmbeddedObjectBorder |
PUBLIC |
TY_133 |
EmbeddedObjectPosition |
PUBLIC |
TY_134 |
ErrorValue |
PUBLIC |
TY_135 |
ExtendedValue |
PUBLIC |
TY_136 |
FilterCriteria |
PUBLIC |
TY_137 |
FilterSpec |
PUBLIC |
TY_138 |
FilterView |
PUBLIC |
TY_139 |
FindReplaceRequest |
PUBLIC |
TY_140 |
FindReplaceResponse |
PUBLIC |
TY_141 |
GetSpreadsheetByDataFilterRequest |
PUBLIC |
TY_142 |
GradientRule |
PUBLIC |
TY_143 |
GridCoordinate |
PUBLIC |
TY_144 |
GridData |
PUBLIC |
TY_145 |
GridProperties |
PUBLIC |
TY_146 |
GridRange |
PUBLIC |
TY_147 |
HistogramChartSpec |
PUBLIC |
TY_148 |
HistogramRule |
PUBLIC |
TY_149 |
HistogramSeries |
PUBLIC |
TY_150 |
InsertDimensionRequest |
PUBLIC |
TY_151 |
InsertRangeRequest |
PUBLIC |
TY_152 |
InterpolationPoint |
PUBLIC |
TY_153 |
Interval |
PUBLIC |
TY_154 |
IterativeCalculationSettings |
PUBLIC |
TY_155 |
KeyValueFormat |
PUBLIC |
TY_156 |
LineStyle |
PUBLIC |
TY_157 |
Link |
PUBLIC |
TY_158 |
ManualRule |
PUBLIC |
TY_159 |
ManualRuleGroup |
PUBLIC |
TY_160 |
MatchedDeveloperMetadata |
PUBLIC |
TY_161 |
MatchedValueRange |
PUBLIC |
TY_162 |
MergeCellsRequest |
PUBLIC |
TY_163 |
MoveDimensionRequest |
PUBLIC |
TY_164 |
NamedRange |
PUBLIC |
TY_165 |
NumberFormat |
PUBLIC |
TY_166 |
OrgChartSpec |
PUBLIC |
TY_167 |
OverlayPosition |
PUBLIC |
TY_168 |
Padding |
PUBLIC |
TY_169 |
PasteDataRequest |
PUBLIC |
TY_170 |
PieChartSpec |
PUBLIC |
TY_171 |
PivotFilterCriteria |
PUBLIC |
TY_172 |
PivotFilterSpec |
PUBLIC |
TY_173 |
PivotGroup |
PUBLIC |
TY_174 |
PivotGroupLimit |
PUBLIC |
TY_175 |
PivotGroupRule |
PUBLIC |
TY_176 |
PivotGroupSortValueBucket |
PUBLIC |
TY_177 |
PivotGroupValueMetadata |
PUBLIC |
TY_178 |
PivotTable |
PUBLIC |
TY_179 |
PivotValue |
PUBLIC |
TY_180 |
PointStyle |
PUBLIC |
TY_181 |
ProtectedRange |
PUBLIC |
TY_182 |
RandomizeRangeRequest |
PUBLIC |
TY_183 |
RefreshDataSourceObjectExecutionStatus |
PUBLIC |
TY_184 |
RefreshDataSourceRequest |
PUBLIC |
TY_185 |
RefreshDataSourceResponse |
PUBLIC |
TY_186 |
RepeatCellRequest |
PUBLIC |
TY_187 |
Request |
PUBLIC |
TY_188 |
Response |
PUBLIC |
TY_189 |
RowData |
PUBLIC |
TY_190 |
ScorecardChartSpec |
PUBLIC |
TY_191 |
SearchDeveloperMetadataRequest |
PUBLIC |
TY_192 |
SearchDeveloperMetadataResponse |
PUBLIC |
TY_193 |
SetBasicFilterRequest |
PUBLIC |
TY_194 |
SetDataValidationRequest |
PUBLIC |
TY_195 |
Sheet |
PUBLIC |
TY_196 |
SheetProperties |
PUBLIC |
TY_197 |
Slicer |
PUBLIC |
TY_198 |
SlicerSpec |
PUBLIC |
TY_199 |
SortRangeRequest |
PUBLIC |
TY_200 |
SortSpec |
PUBLIC |
TY_201 |
SourceAndDestination |
PUBLIC |
TY_202 |
Spreadsheet |
PUBLIC |
TY_203 |
SpreadsheetProperties |
PUBLIC |
TY_204 |
SpreadsheetTheme |
PUBLIC |
TY_205 |
TextFormat |
PUBLIC |
TY_206 |
TextFormatRun |
PUBLIC |
TY_207 |
TextPosition |
PUBLIC |
TY_208 |
TextRotation |
PUBLIC |
TY_209 |
TextToColumnsRequest |
PUBLIC |
TY_210 |
ThemeColorPair |
PUBLIC |
TY_211 |
TimeOfDay |
PUBLIC |
TY_212 |
TreemapChartColorScale |
PUBLIC |
TY_213 |
TreemapChartSpec |
PUBLIC |
TY_214 |
TrimWhitespaceRequest |
PUBLIC |
TY_215 |
TrimWhitespaceResponse |
PUBLIC |
TY_216 |
UnmergeCellsRequest |
PUBLIC |
TY_217 |
UpdateBandingRequest |
PUBLIC |
TY_218 |
UpdateBordersRequest |
PUBLIC |
TY_219 |
UpdateCellsRequest |
PUBLIC |
TY_220 |
UpdateChartSpecRequest |
PUBLIC |
TY_221 |
UpdateConditionalFormatRuleRequest |
PUBLIC |
TY_222 |
UpdateConditionalFormatRuleResponse |
PUBLIC |
TY_223 |
UpdateDataSourceRequest |
PUBLIC |
TY_224 |
UpdateDataSourceResponse |
PUBLIC |
TY_225 |
UpdateDeveloperMetadataRequest |
PUBLIC |
TY_226 |
UpdateDeveloperMetadataResponse |
PUBLIC |
TY_227 |
UpdateDimensionGroupRequest |
PUBLIC |
TY_228 |
UpdateDimensionPropertiesRequest |
PUBLIC |
TY_229 |
UpdateEmbeddedObjectBorderRequest |
PUBLIC |
TY_230 |
UpdateEmbeddedObjectPositionRequest |
PUBLIC |
TY_231 |
UpdateEmbeddedObjectPositionResponse |
PUBLIC |
TY_232 |
UpdateFilterViewRequest |
PUBLIC |
TY_233 |
UpdateNamedRangeRequest |
PUBLIC |
TY_234 |
UpdateProtectedRangeRequest |
PUBLIC |
TY_235 |
UpdateSheetPropertiesRequest |
PUBLIC |
TY_236 |
UpdateSlicerSpecRequest |
PUBLIC |
TY_237 |
UpdateSpreadsheetPropertiesRequest |
PUBLIC |
TY_238 |
UpdateValuesByDataFilterResponse |
PUBLIC |
TY_239 |
UpdateValuesResponse |
PUBLIC |
TY_240 |
ValueRange |
PUBLIC |
TY_241 |
WaterfallChartColumnStyle |
PUBLIC |
TY_242 |
WaterfallChartCustomSubtotal |
PUBLIC |
TY_243 |
WaterfallChartDomain |
PUBLIC |
TY_244 |
WaterfallChartSeries |
PUBLIC |
TY_245 |
WaterfallChartSpec |
PUBLIC |
TY_246 |
CancelDataSourceRefreshRequest |
PUBLIC |
TY_247 |
CancelDataSourceRefreshResponse |
PUBLIC |
TY_248 |
CancelDataSourceRefreshStatus |
PUBLIC |
TY_249 |
RefreshCancellationStatus |
PUBLIC |
TY_250 |
LookerDataSourceSpec |
PUBLIC |
TY_T_025 |
BandedRange |
PUBLIC |
TY_T_028 |
BasicChartAxis |
PUBLIC |
TY_T_029 |
BasicChartDomain |
PUBLIC |
TY_T_030 |
BasicChartSeries |
PUBLIC |
TY_T_033 |
BasicSeriesDataPointStyleOverride |
PUBLIC |
TY_T_056 |
CandlestickData |
PUBLIC |
TY_T_059 |
CellData |
PUBLIC |
TY_T_074 |
ConditionValue |
PUBLIC |
TY_T_075 |
ConditionalFormatRule |
PUBLIC |
TY_T_082 |
DataFilter |
PUBLIC |
TY_T_083 |
DataFilterValueRange |
PUBLIC |
TY_T_085 |
DataSource |
PUBLIC |
TY_T_087 |
DataSourceColumn |
PUBLIC |
TY_T_088 |
DataSourceColumnReference |
PUBLIC |
TY_T_090 |
DataSourceObjectReference |
PUBLIC |
TY_T_092 |
DataSourceParameter |
PUBLIC |
TY_T_095 |
DataSourceRefreshSchedule |
PUBLIC |
TY_T_120 |
DeveloperMetadata |
PUBLIC |
TY_T_123 |
DimensionGroup |
PUBLIC |
TY_T_124 |
DimensionProperties |
PUBLIC |
TY_T_125 |
DimensionRange |
PUBLIC |
TY_T_131 |
EmbeddedChart |
PUBLIC |
TY_T_135 |
ExtendedValue |
PUBLIC |
TY_T_137 |
FilterSpec |
PUBLIC |
TY_T_138 |
FilterView |
PUBLIC |
TY_T_144 |
GridData |
PUBLIC |
TY_T_146 |
GridRange |
PUBLIC |
TY_T_149 |
HistogramSeries |
PUBLIC |
TY_T_159 |
ManualRuleGroup |
PUBLIC |
TY_T_160 |
MatchedDeveloperMetadata |
PUBLIC |
TY_T_161 |
MatchedValueRange |
PUBLIC |
TY_T_164 |
NamedRange |
PUBLIC |
TY_T_172 |
PivotFilterSpec |
PUBLIC |
TY_T_173 |
PivotGroup |
PUBLIC |
TY_T_177 |
PivotGroupValueMetadata |
PUBLIC |
TY_T_179 |
PivotValue |
PUBLIC |
TY_T_181 |
ProtectedRange |
PUBLIC |
TY_T_183 |
RefreshDataSourceObjectExecutionStatus |
PUBLIC |
TY_T_187 |
Request |
PUBLIC |
TY_T_188 |
Response |
PUBLIC |
TY_T_189 |
RowData |
PUBLIC |
TY_T_195 |
Sheet |
PUBLIC |
TY_T_197 |
Slicer |
PUBLIC |
TY_T_200 |
SortSpec |
PUBLIC |
TY_T_206 |
TextFormatRun |
PUBLIC |
TY_T_210 |
ThemeColorPair |
PUBLIC |
TY_T_238 |
UpdateValuesByDataFilterResponse |
PUBLIC |
TY_T_239 |
UpdateValuesResponse |
PUBLIC |
TY_T_240 |
ValueRange |
PUBLIC |
TY_T_242 |
WaterfallChartCustomSubtotal |
PUBLIC |
TY_T_244 |
WaterfallChartSeries |
PUBLIC |
TY_T_248 |
CancelDataSourceRefreshStatus |
PUBLIC |
TY_T_INT4 |
Table of Integers |
PUBLIC |
TY_T_STRING |
Table of Strings |
PUBLIC |
Constants
Name | Type | Description | Value | Visibility |
---|---|---|---|---|
C_SUPPORTED_AUTH |
/GOOG/SUPP_AUTH |
Supported Auth Types | OOIJWW | PUBLIC |
C_ROOT_URL |
STRING |
API Root URL | https://sheets.googleapis.com | PUBLIC |
C_SERVICE_NAME |
/GOOG/SERVICE_NAME |
Google Service Name | sheets:v4 | PUBLIC |
C_REVISION_DATE |
DATUM |
Discovery Document revision Date | 20240826 | PUBLIC |
C_CLOUD_VERSION |
/GOOG/SDK_VERSION |
Lowest Cloud Version | 1.0 | PUBLIC |
C_ON_PREM_VERSION |
/GOOG/SDK_VERSION |
Lowest On-premises Version | 1.5 | PUBLIC |
C_PATH_PREFIX |
STRING |
API Path Prefix | PUBLIC |
Methods
For general information about a method in ABAP SDK for Google Cloud, see API method.CONSTRUCTOR
- Description: Constructor
- Visibility: PUBLIC
Parameters
Name | Category | Type | Description |
---|---|---|---|
IV_KEY_NAME |
IMPORTING | /GOOG/KEYNAME |
Google Cloud Key Name |
IV_LOG_OBJ |
IMPORTING | BALOBJ_D |
Application log: Object name (Application code) |
IV_LOG_SUBOBJ |
IMPORTING | BALSUBOBJ |
Application Log: Subobject |
Exception
Name | Description |
---|---|
/GOOG/CX_SDK |
ABAP SDK for Google Cloud: Exception Class |
APPEND_VALUES
- Description: sheets.spreadsheets.values.append
- Visibility: PUBLIC
Parameters
Name | Category | Type | Description |
---|---|---|---|
IV_Q_INCLUDEVALUESINRESPONSE |
IMPORTING | STRING |
includeValuesInResponse |
IV_Q_INSERTDATAOPTION |
IMPORTING | STRING |
insertDataOption |
IV_Q_RESPONSEDATETIMERENDEROPT |
IMPORTING | STRING |
responseDateTimeRenderOption |
IV_Q_RESPONSEVALUERENDEROPTION |
IMPORTING | STRING |
responseValueRenderOption |
IV_Q_VALUEINPUTOPTION |
IMPORTING | STRING |
valueInputOption |
IV_P_RANGE |
IMPORTING | STRING |
range |
IV_P_SPREADSHEET_ID |
IMPORTING | STRING |
spreadsheetId |
IS_INPUT |
IMPORTING | TY_240 |
ValueRange |
ES_RAW |
EXPORTING | DATA |
Raw Output Data |
ES_OUTPUT |
EXPORTING | TY_022 |
AppendValuesResponse |
EV_RET_CODE |
EXPORTING | I |
Return Code |
EV_ERR_TEXT |
EXPORTING | STRING |
Error Text |
ES_ERR_RESP |
EXPORTING | /GOOG/ERR_RESP |
Error Response |
Exception
Name | Description |
---|---|
/GOOG/CX_SDK |
ABAP SDK for Google Cloud: Exception Class |
BATCH_CLEAR_BY_DATA_FILTER
- Description: sheets.spreadsheets.values.batchClearByDataFilter
- Visibility: PUBLIC
Parameters
Name | Category | Type | Description |
---|---|---|---|
IV_P_SPREADSHEET_ID |
IMPORTING | STRING |
spreadsheetId |
IS_INPUT |
IMPORTING | TY_034 |
BatchClearValuesByDataFilterRequest |
ES_RAW |
EXPORTING | DATA |
Raw Output Data |
ES_OUTPUT |
EXPORTING | TY_035 |
BatchClearValuesByDataFilterResponse |
EV_RET_CODE |
EXPORTING | I |
Return Code |
EV_ERR_TEXT |
EXPORTING | STRING |
Error Text |
ES_ERR_RESP |
EXPORTING | /GOOG/ERR_RESP |
Error Response |
Exception
Name | Description |
---|---|
/GOOG/CX_SDK |
ABAP SDK for Google Cloud: Exception Class |
BATCH_CLEAR_VALUES
- Description: sheets.spreadsheets.values.batchClear
- Visibility: PUBLIC
Parameters
Name | Category | Type | Description |
---|---|---|---|
IV_P_SPREADSHEET_ID |
IMPORTING | STRING |
spreadsheetId |
IS_INPUT |
IMPORTING | TY_036 |
BatchClearValuesRequest |
ES_RAW |
EXPORTING | DATA |
Raw Output Data |
ES_OUTPUT |
EXPORTING | TY_037 |
BatchClearValuesResponse |
EV_RET_CODE |
EXPORTING | I |
Return Code |
EV_ERR_TEXT |
EXPORTING | STRING |
Error Text |
ES_ERR_RESP |
EXPORTING | /GOOG/ERR_RESP |
Error Response |
Exception
Name | Description |
---|---|
/GOOG/CX_SDK |
ABAP SDK for Google Cloud: Exception Class |
BATCH_GET_BY_DATA_FILTER_VA
- Description: sheets.spreadsheets.values.batchGetByDataFilter
- Visibility: PUBLIC
Parameters
Name | Category | Type | Description |
---|---|---|---|
IV_P_SPREADSHEET_ID |
IMPORTING | STRING |
spreadsheetId |
IS_INPUT |
IMPORTING | TY_038 |
BatchGetValuesByDataFilterRequest |
ES_RAW |
EXPORTING | DATA |
Raw Output Data |
ES_OUTPUT |
EXPORTING | TY_039 |
BatchGetValuesByDataFilterResponse |
EV_RET_CODE |
EXPORTING | I |
Return Code |
EV_ERR_TEXT |
EXPORTING | STRING |
Error Text |
ES_ERR_RESP |
EXPORTING | /GOOG/ERR_RESP |
Error Response |
Exception
Name | Description |
---|---|
/GOOG/CX_SDK |
ABAP SDK for Google Cloud: Exception Class |
BATCH_GET_VALUES
- Description: sheets.spreadsheets.values.batchGet
- Visibility: PUBLIC
Parameters
Name | Category | Type | Description |
---|---|---|---|
IV_Q_DATETIMERENDEROPTION |
IMPORTING | STRING |
dateTimeRenderOption |
IV_Q_MAJORDIMENSION |
IMPORTING | STRING |
majorDimension |
IV_Q_RANGES |
IMPORTING | STRING |
ranges |
IV_Q_VALUERENDEROPTION |
IMPORTING | STRING |
valueRenderOption |
IV_P_SPREADSHEET_ID |
IMPORTING | STRING |
spreadsheetId |
ES_RAW |
EXPORTING | DATA |
Raw Output Data |
ES_OUTPUT |
EXPORTING | TY_040 |
BatchGetValuesResponse |
EV_RET_CODE |
EXPORTING | I |
Return Code |
EV_ERR_TEXT |
EXPORTING | STRING |
Error Text |
ES_ERR_RESP |
EXPORTING | /GOOG/ERR_RESP |
Error Response |
Exception
Name | Description |
---|---|
/GOOG/CX_SDK |
ABAP SDK for Google Cloud: Exception Class |
BATCH_UPDATE_BY_DATA_FILTER
- Description: sheets.spreadsheets.values.batchUpdateByDataFilter
- Visibility: PUBLIC
Parameters
Name | Category | Type | Description |
---|---|---|---|
IV_P_SPREADSHEET_ID |
IMPORTING | STRING |
spreadsheetId |
IS_INPUT |
IMPORTING | TY_043 |
BatchUpdateValuesByDataFilterRequest |
ES_RAW |
EXPORTING | DATA |
Raw Output Data |
ES_OUTPUT |
EXPORTING | TY_044 |
BatchUpdateValuesByDataFilterResponse |
EV_RET_CODE |
EXPORTING | I |
Return Code |
EV_ERR_TEXT |
EXPORTING | STRING |
Error Text |
ES_ERR_RESP |
EXPORTING | /GOOG/ERR_RESP |
Error Response |
Exception
Name | Description |
---|---|
/GOOG/CX_SDK |
ABAP SDK for Google Cloud: Exception Class |
BATCH_UPDATE_SPREADSHEETS
- Description: sheets.spreadsheets.batchUpdate
- Visibility: PUBLIC
Parameters
Name | Category | Type | Description |
---|---|---|---|
IV_P_SPREADSHEET_ID |
IMPORTING | STRING |
spreadsheetId |
IS_INPUT |
IMPORTING | TY_041 |
BatchUpdateSpreadsheetRequest |
ES_RAW |
EXPORTING | DATA |
Raw Output Data |
ES_OUTPUT |
EXPORTING | TY_042 |
BatchUpdateSpreadsheetResponse |
EV_RET_CODE |
EXPORTING | I |
Return Code |
EV_ERR_TEXT |
EXPORTING | STRING |
Error Text |
ES_ERR_RESP |
EXPORTING | /GOOG/ERR_RESP |
Error Response |
Exception
Name | Description |
---|---|
/GOOG/CX_SDK |
ABAP SDK for Google Cloud: Exception Class |
BATCH_UPDATE_VALUES
- Description: sheets.spreadsheets.values.batchUpdate
- Visibility: PUBLIC
Parameters
Name | Category | Type | Description |
---|---|---|---|
IV_P_SPREADSHEET_ID |
IMPORTING | STRING |
spreadsheetId |
IS_INPUT |
IMPORTING | TY_045 |
BatchUpdateValuesRequest |
ES_RAW |
EXPORTING | DATA |
Raw Output Data |
ES_OUTPUT |
EXPORTING | TY_046 |
BatchUpdateValuesResponse |
EV_RET_CODE |
EXPORTING | I |
Return Code |
EV_ERR_TEXT |
EXPORTING | STRING |
Error Text |
ES_ERR_RESP |
EXPORTING | /GOOG/ERR_RESP |
Error Response |
Exception
Name | Description |
---|---|
/GOOG/CX_SDK |
ABAP SDK for Google Cloud: Exception Class |
CLEAR_VALUES
- Description: sheets.spreadsheets.values.clear
- Visibility: PUBLIC
Parameters
Name | Category | Type | Description |
---|---|---|---|
IV_P_RANGE |
IMPORTING | STRING |
range |
IV_P_SPREADSHEET_ID |
IMPORTING | STRING |
spreadsheetId |
IS_INPUT |
IMPORTING | REF TO DATA |
Input Data |
ES_RAW |
EXPORTING | DATA |
Raw Output Data |
ES_OUTPUT |
EXPORTING | TY_071 |
ClearValuesResponse |
EV_RET_CODE |
EXPORTING | I |
Return Code |
EV_ERR_TEXT |
EXPORTING | STRING |
Error Text |
ES_ERR_RESP |
EXPORTING | /GOOG/ERR_RESP |
Error Response |
Exception
Name | Description |
---|---|
/GOOG/CX_SDK |
ABAP SDK for Google Cloud: Exception Class |
COPY_TO_SHEETS
- Description: sheets.spreadsheets.sheets.copyTo
- Visibility: PUBLIC
Parameters
Name | Category | Type | Description |
---|---|---|---|
IV_P_SHEET_ID |
IMPORTING | STRING |
sheetId |
IV_P_SPREADSHEET_ID |
IMPORTING | STRING |
spreadsheetId |
IS_INPUT |
IMPORTING | TY_077 |
CopySheetToAnotherSpreadsheetRequest |
ES_RAW |
EXPORTING | DATA |
Raw Output Data |
ES_OUTPUT |
EXPORTING | TY_196 |
SheetProperties |
EV_RET_CODE |
EXPORTING | I |
Return Code |
EV_ERR_TEXT |
EXPORTING | STRING |
Error Text |
ES_ERR_RESP |
EXPORTING | /GOOG/ERR_RESP |
Error Response |
Exception
Name | Description |
---|---|
/GOOG/CX_SDK |
ABAP SDK for Google Cloud: Exception Class |
CREATE_SPREADSHEETS
- Description: sheets.spreadsheets.create
- Visibility: PUBLIC
Parameters
Name | Category | Type | Description |
---|---|---|---|
IS_INPUT |
IMPORTING | TY_202 |
Spreadsheet |
ES_RAW |
EXPORTING | DATA |
Raw Output Data |
ES_OUTPUT |
EXPORTING | TY_202 |
Spreadsheet |
EV_RET_CODE |
EXPORTING | I |
Return Code |
EV_ERR_TEXT |
EXPORTING | STRING |
Error Text |
ES_ERR_RESP |
EXPORTING | /GOOG/ERR_RESP |
Error Response |
Exception
Name | Description |
---|---|
/GOOG/CX_SDK |
ABAP SDK for Google Cloud: Exception Class |
GET_BY_DATA_FILTER_SPREADSH
- Description: sheets.spreadsheets.getByDataFilter
- Visibility: PUBLIC
Parameters
Name | Category | Type | Description |
---|---|---|---|
IV_P_SPREADSHEET_ID |
IMPORTING | STRING |
spreadsheetId |
IS_INPUT |
IMPORTING | TY_141 |
GetSpreadsheetByDataFilterRequest |
ES_RAW |
EXPORTING | DATA |
Raw Output Data |
ES_OUTPUT |
EXPORTING | TY_202 |
Spreadsheet |
EV_RET_CODE |
EXPORTING | I |
Return Code |
EV_ERR_TEXT |
EXPORTING | STRING |
Error Text |
ES_ERR_RESP |
EXPORTING | /GOOG/ERR_RESP |
Error Response |
Exception
Name | Description |
---|---|
/GOOG/CX_SDK |
ABAP SDK for Google Cloud: Exception Class |
GET_DEVELOPER_METADATA
- Description: sheets.spreadsheets.developerMetadata.get
- Visibility: PUBLIC
Parameters
Name | Category | Type | Description |
---|---|---|---|
IV_P_METADATA_ID |
IMPORTING | STRING |
metadataId |
IV_P_SPREADSHEET_ID |
IMPORTING | STRING |
spreadsheetId |
ES_RAW |
EXPORTING | DATA |
Raw Output Data |
ES_OUTPUT |
EXPORTING | TY_120 |
DeveloperMetadata |
EV_RET_CODE |
EXPORTING | I |
Return Code |
EV_ERR_TEXT |
EXPORTING | STRING |
Error Text |
ES_ERR_RESP |
EXPORTING | /GOOG/ERR_RESP |
Error Response |
Exception
Name | Description |
---|---|
/GOOG/CX_SDK |
ABAP SDK for Google Cloud: Exception Class |
GET_SPREADSHEETS
- Description: sheets.spreadsheets.get
- Visibility: PUBLIC
Parameters
Name | Category | Type | Description |
---|---|---|---|
IV_Q_INCLUDEGRIDDATA |
IMPORTING | STRING |
includeGridData |
IV_Q_RANGES |
IMPORTING | STRING |
ranges |
IV_P_SPREADSHEET_ID |
IMPORTING | STRING |
spreadsheetId |
ES_RAW |
EXPORTING | DATA |
Raw Output Data |
ES_OUTPUT |
EXPORTING | TY_202 |
Spreadsheet |
EV_RET_CODE |
EXPORTING | I |
Return Code |
EV_ERR_TEXT |
EXPORTING | STRING |
Error Text |
ES_ERR_RESP |
EXPORTING | /GOOG/ERR_RESP |
Error Response |
Exception
Name | Description |
---|---|
/GOOG/CX_SDK |
ABAP SDK for Google Cloud: Exception Class |
GET_VALUES
- Description: sheets.spreadsheets.values.get
- Visibility: PUBLIC
Parameters
Name | Category | Type | Description |
---|---|---|---|
IV_Q_DATETIMERENDEROPTION |
IMPORTING | STRING |
dateTimeRenderOption |
IV_Q_MAJORDIMENSION |
IMPORTING | STRING |
majorDimension |
IV_Q_VALUERENDEROPTION |
IMPORTING | STRING |
valueRenderOption |
IV_P_RANGE |
IMPORTING | STRING |
range |
IV_P_SPREADSHEET_ID |
IMPORTING | STRING |
spreadsheetId |
ES_RAW |
EXPORTING | DATA |
Raw Output Data |
ES_OUTPUT |
EXPORTING | TY_240 |
ValueRange |
EV_RET_CODE |
EXPORTING | I |
Return Code |
EV_ERR_TEXT |
EXPORTING | STRING |
Error Text |
ES_ERR_RESP |
EXPORTING | /GOOG/ERR_RESP |
Error Response |
Exception
Name | Description |
---|---|
/GOOG/CX_SDK |
ABAP SDK for Google Cloud: Exception Class |
SEARCH_DEVELOPER_METADATA
- Description: sheets.spreadsheets.developerMetadata.search
- Visibility: PUBLIC
Parameters
Name | Category | Type | Description |
---|---|---|---|
IV_P_SPREADSHEET_ID |
IMPORTING | STRING |
spreadsheetId |
IS_INPUT |
IMPORTING | TY_191 |
SearchDeveloperMetadataRequest |
ES_RAW |
EXPORTING | DATA |
Raw Output Data |
ES_OUTPUT |
EXPORTING | TY_192 |
SearchDeveloperMetadataResponse |
EV_RET_CODE |
EXPORTING | I |
Return Code |
EV_ERR_TEXT |
EXPORTING | STRING |
Error Text |
ES_ERR_RESP |
EXPORTING | /GOOG/ERR_RESP |
Error Response |
Exception
Name | Description |
---|---|
/GOOG/CX_SDK |
ABAP SDK for Google Cloud: Exception Class |
UPDATE_VALUES
- Description: sheets.spreadsheets.values.update
- Visibility: PUBLIC
Parameters
Name | Category | Type | Description |
---|---|---|---|
IV_Q_INCLUDEVALUESINRESPONSE |
IMPORTING | STRING |
includeValuesInResponse |
IV_Q_RESPONSEDATETIMERENDEROPT |
IMPORTING | STRING |
responseDateTimeRenderOption |
IV_Q_RESPONSEVALUERENDEROPTION |
IMPORTING | STRING |
responseValueRenderOption |
IV_Q_VALUEINPUTOPTION |
IMPORTING | STRING |
valueInputOption |
IV_P_RANGE |
IMPORTING | STRING |
range |
IV_P_SPREADSHEET_ID |
IMPORTING | STRING |
spreadsheetId |
IS_INPUT |
IMPORTING | TY_240 |
ValueRange |
ES_RAW |
EXPORTING | DATA |
Raw Output Data |
ES_OUTPUT |
EXPORTING | TY_239 |
UpdateValuesResponse |
EV_RET_CODE |
EXPORTING | I |
Return Code |
EV_ERR_TEXT |
EXPORTING | STRING |
Error Text |
ES_ERR_RESP |
EXPORTING | /GOOG/ERR_RESP |
Error Response |
Exception
Name | Description |
---|---|
/GOOG/CX_SDK |
ABAP SDK for Google Cloud: Exception Class |
CLOSE
- Description: Close Connection
- Visibility: PUBLIC