Deploying an Apps Script to Looker Studio doesn't show the fields screen

Looker Q&A Looker Studio
1

Hi, when trying to deploy a new Apps Script communty connector that does an HTTP POST to run a query against a database API, I click the ‘Connect’ button, I see the getSchema() function execute in the log but the getData() function never executes. Any ideas on how I can debug this? I’ve trimmed the request down to get just a single column. Thanks! \Hank

2

I’m not sure, so I asked Gemini. It might be worth checking the following:

The issue is almost certainly a mismatch or an error in the getSchema() response that prevents Looker Studio from proceeding to the getData() call.

The single most common culprit is a problem in the id and name properties of the fields returned by getSchema().

  • IDs and Names Must Match: Ensure the id of the field in the getSchema() response is exactly the same as the name that your getData() function expects in the request object’s fields array.

    • Example: If getSchema() returns a field with 'id': 'customer_name', then when Looker Studio calls getData(), it will look for a column named 'customer_name' in the data.