I have created a community connector for Looker Studio. In my report that uses the connector, I can see that the date range dimension is properly populated:
However when I retrieve data with a date range, I get no data being displayed. In the app script log I can see the incoming request that was sent from Studio to the script (getData() method) but it appears to be incorrect.
getDataQueryRquest: {"scriptParams":{"lastRefresh":"1743550449806"},"fields":[{"name":"reporter_name"}] The fields object is incorrect. It should be
"fields":[{"forFilterOnly":true,"name":"incident_date"},{"name":"reporter_name"}] with an additional object specifying a date range:
"dimensionsFilters":[[{"type":"INCLUDE","fieldName":"incident_date","operator":"NUMERIC_GREATER_THAN_OR_EQUAL","values":["20241202"]}],[{"fieldName":"incident_date","values":["20250401"],"operator":"NUMERIC_LESS_THAN_OR_EQUAL","type":"INCLUDE"}]] As I have no control over how the request is generated by Studio, I am struggling to make this connector work, which is preventing our adoption of Studio. Has anyone else come across this and/or know how to fix it?
TIA