Data Studio Service Stay organized with collections Save and categorize content based on your preferences.
Page Summary
The Data Studio service allows scripts to access and modify Data Studio Community Connectors.
It provides classes and methods for interacting with various aspects of Data Studio connectors, including configuration, fields, authentication, and data retrieval.
Enums are defined for aggregation types, authentication types, BigQuery parameter types, and field types.
Builders are available for creating responses for authentication type, data, schema, and set credentials requests.
Error handling can be implemented using DebugError for admin-only errors and UserError for errors visible to users.
This service allows scripts to access and modify Data StudioCommunity Connectors.
Classes
| Name | Brief description |
|---|---|
Aggregation | An enum that defines the aggregation types that can be set for aField. |
Auth | An enum that defines the authentication types that can be set for a connector. |
Big | A configuration object for a native BigQuery connector. |
Big | An enum that defines the BigQuery parameter types that you can set. |
Checkbox | Contains checkbox information for the config. |
Community | Community |
Config | Contains the configuration entries for a connector. |
Data | Data |
Debug | An error that is only visible to admins of the connector. |
Field | Contains field-related data. |
Field | An enum that defines the types that can be set for aField. |
Fields | Contains a set ofFields for a community connector. |
Get | Builder to create aget response for your script project. |
Get | Builder to create aget response for your script project. |
Get | Builder to create aget response for your script project. |
Info | Contains info data for the config. |
Option | A builder for creating options forSelects andSelects. |
Select | Contains select multiple information for the config. |
Select | Contains select single information for the config. |
Set | Builder to create aset response for your script project. |
Text | Contains text area information for the config. |
Text | Contains text input information for the config. |
User | An error that is shown to users of the connector. |
AggregationType
Properties
| Property | Type | Description |
|---|---|---|
AVG | Enum | Average. |
COUNT | Enum | Count. |
COUNT_DISTINCT | Enum | Count Distinct. |
MAX | Enum | Max. |
MIN | Enum | Min. |
SUM | Enum | Sum. |
AUTO | Enum | Auto. |
AuthType
Properties
| Property | Type | Description |
|---|---|---|
NONE | Enum | No authorization needed. |
OAUTH2 | Enum | OAuth2 authorization needed. |
USER_PASS | Enum | Username and password credentials needed. |
PATH_USER_PASS | Enum | Username, path, and password needed. |
PATH_KEY | Enum | Path and key needed. |
KEY | Enum | API Key or Token needed. |
USER_TOKEN | Enum | Username and token needed. |
BigQueryConfig
Methods
| Method | Return type | Brief description |
|---|---|---|
add | Big | Adds a query parameter to thisBig. |
build() | Object | Validates this object and returns it in the format needed by Data Studio. |
print | String | Prints the JSON representation of this object. |
set | Big | Sets the access token of thisBig. |
set | Big | Sets the billing project ID of thisBig. |
set | Big | Sets the SQL query of thisBig. |
set | Big | Determines if the query is interpreted as standard or legacy SQL. |
BigQueryParameterType
Properties
| Property | Type | Description |
|---|---|---|
STRING | Enum | String. |
INT64 | Enum | 64-bit integer. |
BOOL | Enum | Boolean. |
FLOAT64 | Enum | 64-bit floating point number. |
Checkbox
Methods
| Method | Return type | Brief description |
|---|---|---|
set | Checkbox | Enables overriding for this config entry. |
set | Checkbox | Sets the help text for this configuration entry. |
set | Checkbox | Sets the unique ID for this configuration entry. |
set | Checkbox | Sets the dynamic status for this configuration entry. |
set | Checkbox | Sets the display name for this configuration entry. |
CommunityConnector
Properties
| Property | Type | Description |
|---|---|---|
Aggregation | Aggregation | TheAggregation enumeration. |
Auth | Auth | TheAuth enumeration. |
Big | Big | TheBig enumeration. |
Field | Field | TheField enumeration. |
Methods
| Method | Return type | Brief description |
|---|---|---|
get | Config | Returns aConfig object. |
get | Fields | Returns aFields object. |
new | Get | Returns a newGet object. |
new | Big | Returns a newBig object. |
new | Debug | Returns a newDebug object. |
new | Get | Returns a newGet object. |
new | Get | Returns a newGet object. |
new | Set | Returns a newSet object. |
new | User | Returns a newUser object. |
Config
Methods
| Method | Return type | Brief description |
|---|---|---|
build() | Object | Validates this object and returns it in the format needed by Data Studio. |
new | Checkbox | Returns a new checkbox configuration entry. |
new | Info | Returns a new info configuration entry. |
new | Option | Returns a new options builder. |
new | Select | Returns a new select multiple configuration entry. |
new | Select | Returns a new select single configuration entry. |
new | Text | Returns a new text area configuration entry. |
new | Text | Returns a new text input configuration entry. |
print | String | Prints the JSON representation of this object. |
set | Config | Iftrue, a date range is provided for getData() requests. |
set | Config | Iftrue,get is called again with the current user configuration. |
DataStudioApp
Methods
| Method | Return type | Brief description |
|---|---|---|
create | Community | Creates a new Community Connector. |
DebugError
Methods
| Method | Return type | Brief description |
|---|---|---|
print | String | Prints the JSON representation of this object. |
set | Debug | Sets the text of the debug error, which is only shown to admins. |
throw | void | Triggers this exception to be thrown. |
Field
Methods
| Method | Return type | Brief description |
|---|---|---|
get | Aggregation | Returns theAggregation of thisField. |
get | String | Returns the description of thisField. |
get | String | Returns the formula of thisField. |
get | String | Returns the group of thisField. |
get | String | Returns the ID of thisField. |
get | Boolean | Returnstrue if this field can be reaggregated,false otherwise. |
get | String | Returns the name of thisField. |
get | Field | Returns theField of thisField. |
is | Boolean | Returnstrue if thisField is the default metric or dimension. |
is | Boolean | Returnstrue if this field is a dimension. |
is | Boolean | Returnstrue if thisField is hidden. |
is | Boolean | Returnstrue if this field is a metric. |
set | Field | Sets the aggregation type of thisField. |
set | Field | Sets the description of thisField. |
set | Field | Sets the formula of thisField. |
set | Field | Sets the group of thisField. |
set | Field | Sets the ID of thisField. |
set | Field | Sets the hidden status of thisField. |
set | Field | Sets the reaggregation-permitted status for aField. |
set | Field | Sets the name of thisField. |
set | Field | Sets theField of thisField. |
FieldType
Properties
| Property | Type | Description |
|---|---|---|
YEAR | Enum | Year in the format of YYYY such as 2017. |
YEAR_QUARTER | Enum | Year and quarter in the format of YYYYQ such as 20171. |
YEAR_MONTH | Enum | Year and month in the format of YYYYMM such as 201703. |
YEAR_WEEK | Enum | Year and week in the format of YYYYww such as 201707. |
YEAR_MONTH_DAY | Enum | Year, month, and day in the format of YYYYMMDD such as 20170317. |
YEAR_MONTH_DAY_HOUR | Enum | Year, month, day, and hour in the format of YYYYMMDDHH such as 2017031703. |
YEAR_MONTH_DAY_MINUTE | Enum | Year, month, day, hour, and minute in the format of YYYYMMDDHHmm such as 201703170230. |
YEAR_MONTH_DAY_SECOND | Enum | Year, month, day, hour, minute, and second in the format of YYYYMMDDHHmmss such as20170317023017. |
QUARTER | Enum | Quarter in the format of 1, 2, 3, or 4). |
MONTH | Enum | Month in the format of MM such as 03. |
WEEK | Enum | Week in the format of ww such as 07. |
MONTH_DAY | Enum | Month and day in the format of MMDD such as 0317. |
DAY_OF_WEEK | Enum | A number in the range of [0,6] with 0 representing Sunday. |
DAY | Enum | Day in the format of DD such as 17. |
HOUR | Enum | Hour in the format of HH such as 13. |
MINUTE | Enum | Minute in the format of mm such as 12. |
DURATION | Enum | A duration of time in seconds. |
COUNTRY | Enum | A country such as United States. |
COUNTRY_CODE | Enum | A country code such as US. |
CONTINENT | Enum | A continent such as Americas. |
CONTINENT_CODE | Enum | A continent code such as 019. |
SUB_CONTINENT | Enum | A sub-continent such as North America. |
SUB_CONTINENT_CODE | Enum | A sub-continent code such as 003. |
REGION | Enum | A region such as California. |
REGION_CODE | Enum | A region code such as CA. |
CITY | Enum | A city such as Mountain View. |
CITY_CODE | Enum | A city code such as 1014044. |
METRO | Enum | A metro such as San Francisco-Oakland-San Jose CA. |
METRO_CODE | Enum | A metro code such as 200807. |
LATITUDE_LONGITUDE | Enum | A latitude longitude pair such as 51.5074, -0.1278. |
NUMBER | Enum | A decimal number. |
PERCENT | Enum | Decimal percentage (can be over 1.0). |
TEXT | Enum | Free-form text. |
BOOLEAN | Enum | Atrue orfalse boolean value. |
URL | Enum | A URL as text such as https://google.com. |
HYPERLINK | Enum | A hyperlink. |
IMAGE | Enum | An image. |
IMAGE_LINK | Enum | An image link. |
CURRENCY_AED | Enum | Currency from AED. |
CURRENCY_ALL | Enum | Currency from ALL. |
CURRENCY_ARS | Enum | Currency from ARS. |
CURRENCY_AUD | Enum | Currency from AUD. |
CURRENCY_BDT | Enum | Currency from BDT. |
CURRENCY_BGN | Enum | Currency from BGN. |
CURRENCY_BOB | Enum | Currency from BOB. |
CURRENCY_BRL | Enum | Currency from BRL. |
CURRENCY_CAD | Enum | Currency from CAD. |
CURRENCY_CDF | Enum | Currency from CDF. |
CURRENCY_CHF | Enum | Currency from CHF. |
CURRENCY_CLP | Enum | Currency from CLP. |
CURRENCY_CNY | Enum | Currency from CNY. |
CURRENCY_COP | Enum | Currency from COP. |
CURRENCY_CRC | Enum | Currency from CRC. |
CURRENCY_CZK | Enum | Currency from CZK. |
CURRENCY_DKK | Enum | Currency from DKK. |
CURRENCY_DOP | Enum | Currency from DOP. |
CURRENCY_EGP | Enum | Currency from EGP. |
CURRENCY_ETB | Enum | Currency from ETB. |
CURRENCY_EUR | Enum | Currency from EUR. |
CURRENCY_GBP | Enum | Currency from GBP. |
CURRENCY_HKD | Enum | Currency from HKD. |
CURRENCY_HRK | Enum | Currency from HRK. |
CURRENCY_HUF | Enum | Currency from HUF. |
CURRENCY_IDR | Enum | Currency from IDR. |
CURRENCY_ILS | Enum | Currency from ILS. |
CURRENCY_INR | Enum | Currency from INR. |
CURRENCY_IRR | Enum | Currency from IRR. |
CURRENCY_ISK | Enum | Currency from ISK. |
CURRENCY_JMD | Enum | Currency from JMD. |
CURRENCY_JPY | Enum | Currency from JPY. |
CURRENCY_KRW | Enum | Currency from KRW. |
CURRENCY_LKR | Enum | Currency from LKR. |
CURRENCY_LTL | Enum | Currency from LTL. |
CURRENCY_MNT | Enum | Currency from MNT. |
CURRENCY_MVR | Enum | Currency from MVR. |
CURRENCY_MXN | Enum | Currency from MXN. |
CURRENCY_MYR | Enum | Currency from MYR. |
CURRENCY_NGN | Enum | Currency from NGN. |
CURRENCY_NOK | Enum | Currency from NOK. |
CURRENCY_NZD | Enum | Currency from NZD. |
CURRENCY_PAB | Enum | Currency from PAB. |
CURRENCY_PEN | Enum | Currency from PEN. |
CURRENCY_PHP | Enum | Currency from PHP. |
CURRENCY_PKR | Enum | Currency from PKR. |
CURRENCY_PLN | Enum | Currency from PLN. |
CURRENCY_RON | Enum | Currency from RON. |
CURRENCY_RSD | Enum | Currency from RSD. |
CURRENCY_RUB | Enum | Currency from RUB. |
CURRENCY_SAR | Enum | Currency from SAR. |
CURRENCY_SEK | Enum | Currency from SEK. |
CURRENCY_SGD | Enum | Currency from SGD. |
CURRENCY_THB | Enum | Currency from THB. |
CURRENCY_TRY | Enum | Currency from TRY. |
CURRENCY_TWD | Enum | Currency from TWD. |
CURRENCY_TZS | Enum | Currency from TZS. |
CURRENCY_UAH | Enum | Currency from UAH. |
CURRENCY_USD | Enum | Currency from USD. |
CURRENCY_UYU | Enum | Currency from UYU. |
CURRENCY_VEF | Enum | Currency from VEF. |
CURRENCY_VND | Enum | Currency from VND. |
CURRENCY_YER | Enum | Currency from YER. |
CURRENCY_ZAR | Enum | Currency from ZAR. |
Fields
Methods
| Method | Return type | Brief description |
|---|---|---|
as | Field[] | Returns a view of this object as an array. |
build() | Object[] | Validates this object and returns it in the format needed by Data Studio. |
for | Fields | Returns a newFields object filtered toFields with an ID inids. |
get | Field | Returns the default dimension to be used for the set of fields. |
get | Field | Returns the default metric to be used for the set of fields. |
get | Field | Returns a field with a given ID, ornull if no field with that ID is in thisFields object. |
new | Field | Returns a new dimensionField. |
new | Field | Returns a new metricField. |
set | void | Sets the default dimension to be used for the set of fields. |
set | void | Sets the default metric to be used for the set of fields. |
GetAuthTypeResponse
Methods
| Method | Return type | Brief description |
|---|---|---|
build() | Object | Validates this object and returns it in the format needed by Data Studio. |
print | String | Prints the JSON representation of this object. |
set | Get | Sets theAuth of the builder. |
set | Get | Sets the help URL of the builder. |
GetDataResponse
Methods
| Method | Return type | Brief description |
|---|---|---|
add | Get | Adds multiple rows of data to thisGet. |
add | Get | Adds a row of data to thisGet. |
build() | Object | Validates this object and returns it in the format needed by Data Studio. |
set | Get | Sets theFields of the builder. |
set | Get | Sets the filters applied status for this builder. |
GetSchemaResponse
Methods
| Method | Return type | Brief description |
|---|---|---|
build() | Object | Validates this object and returns it in the format needed by Data Studio. |
print | String | Prints the JSON representation of this object. |
set | Get | Sets theFields of the builder. |
Info
Methods
| Method | Return type | Brief description |
|---|---|---|
set | Info | Sets the unique ID for this configuration entry. |
set | Info | Sets the text for this configuration entry. |
OptionBuilder
Methods
| Method | Return type | Brief description |
|---|---|---|
set | Option | Sets the label of this option builder. |
set | Option | Sets the value of this option builder. |
SelectMultiple
Methods
| Method | Return type | Brief description |
|---|---|---|
add | Select | Adds a new select option. |
set | Select | Enables overriding for this config entry. |
set | Select | Sets the help text for this configuration entry. |
set | Select | Sets the unique ID for this configuration entry. |
set | Select | Sets the dynamic status for this configuration entry. |
set | Select | Sets the display name for this configuration entry. |
SelectSingle
Methods
| Method | Return type | Brief description |
|---|---|---|
add | Select | Adds a new select option. |
set | Select | Enables overriding for this config entry. |
set | Select | Sets the help text for this configuration entry. |
set | Select | Sets the unique ID for this configuration entry. |
set | Select | Sets the dynamic status for this configuration entry. |
set | Select | Sets the display name for this configuration entry. |
SetCredentialsResponse
Methods
| Method | Return type | Brief description |
|---|---|---|
build() | Object | Validates this object and returns it in the format needed by Data Studio. |
print | String | Prints the JSON representation of this object. |
set | Set | Sets the valid status of thisSet. |
TextArea
Methods
| Method | Return type | Brief description |
|---|---|---|
set | Text | Enables overriding for this config entry. |
set | Text | Sets the help text for this configuration entry. |
set | Text | Sets the unique ID for this configuration entry. |
set | Text | Sets the dynamic status for this configuration entry. |
set | Text | Sets the display name for this configuration entry. |
set | Text | Sets the placeholder text for this configuration entry. |
TextInput
Methods
| Method | Return type | Brief description |
|---|---|---|
set | Text | Enables overriding for this config entry. |
set | Text | Sets the help text for this configuration entry. |
set | Text | Sets the unique ID for this configuration entry. |
set | Text | Sets the dynamic status for this configuration entry. |
set | Text | Sets the display name for this configuration entry. |
set | Text | Sets the placeholder text for this configuration entry. |
UserError
Methods
| Method | Return type | Brief description |
|---|---|---|
print | String | Prints the JSON representation of this object. |
set | User | Sets the text of the debug error, which is only shown to admins. |
set | User | Sets the text of the user error. |
throw | void | Triggers this exception to be thrown. |
Except as otherwise noted, the content of this page is licensed under theCreative Commons Attribution 4.0 License, and code samples are licensed under theApache 2.0 License. For details, see theGoogle Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2025-12-11 UTC.