Connect Brazil CVM Filings to Looker Studio
Building Looker Studio CVM filings reports? Stage document metadata from apicvm into Google Sheets or BigQuery, then connect Looker Studio to that table. There is no first-party CVM PDF connector inside Looker Studio.
The problem
Marketing and IR ops teams live in Looker Studio. They need coverage heatmaps for Brazilian issuers, not another portal login. Scraped HTML tables drift; an API-backed sheet stays reproducible.
Recommended path
- Apps Script / Python job calls
GET /v1/documents - Write rows to a Sheet or BigQuery table
- Looker Studio uses that dataset
curl -H "Authorization: Bearer $APICVM_KEY" \
"$APICVM_URL/v1/documents?ticker=MGLU3&type=ITR&year=2024&perPage=50"Sheet-friendly workflows: Google Sheets guide.
Sample columns
| column | meaning |
|---|---|
| document_id | UUID for audit |
| ticker | query ticker |
| type | DFP / ITR / FRE |
| year | filter year |
| name | section/document name |
Auth note
Do not paste API keys into Looker Studio community connectors you do not control. Keep the key in your staging job; Looker Studio reads only the warehouse.
Current limitations
- apicvm is not a native Looker Studio partner connector
- PDF bytes are not chartable — metadata only
- Rate limits apply on refresh jobs
Next steps
Ready to integrate?
Get an API key and start querying Brazilian CVM filings programmatically.