Google Apps Script API
    Preparing search index...

    Interface DataSourceSpecBuilder

    The builder for DataSourceSpec. To create a specification for certain type, use as...() method. To create a new builder, use SpreadsheetApp.newDataSourceSpec(). To use the specification, see DataSourceTable.

    This examples show how to build a BigQuery data source specification.

    var spec = SpreadsheetApp.newDataSourceSpec()
           .asBigQuery()
           .setProjectId('big_query_project')
           .setRawQuery('select

    from table limit @LIMIT') .setParameterFromCell('FIELD', 'Sheet1!A1') .setParameterFromCell('LIMIT', 'namedRangeCell') .build();

    interface DataSourceSpecBuilder {
        asBigQuery(): BigQueryDataSourceSpecBuilder;
        build(): DataSourceSpec;
        copy(): DataSourceSpecBuilder;
        getParameters(): DataSourceParameter[];
        getType(): DataSourceType;
        removeAllParameters(): DataSourceSpecBuilder;
        removeParameter(parameterName: string): DataSourceSpecBuilder;
        setParameterFromCell(
            parameterName: string,
            sourceCell: string,
        ): DataSourceSpecBuilder;
    }
    Index

    Methods

    asBigQuery build copy getParameters getType removeAllParameters removeParameter setParameterFromCell

    Methods

    Settings
    Member Visibility

    On This Page
    Methods