Troubleshooting addQueryParameter Error in Looker Studio Community Connector

Looker Q&A Looker
1

Hello everyone,
I’ve developed a community connector using Google Apps Script to enable filtering BigQuery data based on a parameter specific to each report viewer. This setup has previously worked without issues. However, recently when I attempt to add it as a data source in Looker Studio, I encounter the following error:

“Unexpected error while getting the method or property addQueryParameter on object DataStudioApp.BigQueryConfig.” Error ID: 2f02214c

The script runs without errors in the Apps Script environment, but the issue arises when integrating with Looker Studio. I haven’t got any clue about what could explain this error.

Here is the relevant part of my code:

function getQueryConfig(request) {
  const sqlQuery = "SELECT email, organization, random, group_name FROM thematic.Metataito.visualisaatio_tulokset WHERE coach_email = @report_viewer_email";
  const authToken = ScriptApp.getOAuthToken();
  const bqTypes = DataStudioApp.createCommunityConnector().BigQueryParameterType;
  const sahkoposti = request.configParams ? request.configParams.report_viewer_email : null;

  try {
    var configuration = DataStudioApp.createCommunityConnector().newBigQueryConfig()
      .setBillingProjectId(config().bigQueryProjectId)
      .setQuery(sqlQuery)
      .setUseStandardSql(true)
      .setAccessToken(authToken)
      .addQueryParameter('report_viewer_email', bqTypes.STRING, sahkoposti)
      .build();
    return configuration;
  } catch (error) {
    console.error('Error building BigQuery config:', error);
    throw error;
  }
}