Hi GoodData team, Is there a way to easily export ...
# gooddata-cloud
r
Hi GoodData team, Is there a way to easily export into CSV file the filtered Catalog view for a workspace? Thanks in advance
k
The knowledge sources do not explicitly mention a feature to export a filtered Catalog view for a workspace directly to CSV. What GoodData does support for CSV exports is: • Exporting visualizations (from Analytical Designer or dashboards) to CSV/XLSX via the UI, API, or Python SDK. [Export Visualizations] • Exporting tabular data from a custom report (AFM execution result) or an existing visualization object via the API. [Tabular Export API] • Exporting catalog metadata (LDM objects like attributes, facts, measures) into TypeScript/JavaScript code using the
@gooddata/catalog-export
tool — but this is code generation for development purposes, not a CSV data export. [Export Catalog] If you are looking to export the data behind a filtered visualization or report to CSV, the recommended approach is: 1. Use the API to run an AFM execution with your desired filters. 2. Then call the tabular export endpoint to download the result as CSV.
Copy code
# Step 1: Create the export
curl $HOST_URL/api/v1/actions/workspaces/<workspace_id>/export/tabular \
  -H 'Authorization: Bearer $API_TOKEN' \
  -H 'Content-Type: application/json' \
  -X POST \
  -d '{
      "format": "CSV",
      "fileName": "my_export",
      "executionResult": "<execution_result_id>"
  }'

# Step 2: Download the export
curl $HOST_URL/api/v1/actions/workspaces/<workspace_id>/export/tabular/<export_result_id> \
  -H 'Authorization: Bearer $API_TOKEN' \
  -X GET
[Tabular Export API] Could you clarify what you mean by "filtered Catalog view"? If you mean the list of catalog items (metrics, attributes, etc.) visible in the workspace UI, that specific export to CSV is not covered in the available knowledge sources, and I'd recommend reaching out to GoodData support for confirmation. šŸ‘ 0 button šŸ‘Ž 0 button ā„¹ļø Tip: Mention @kapa.ai in the thread for follow-ups. šŸ‘€ Our Support team monitors all messages and will jump in if needed.
r
This is the view I am referring to
s
Hi Raffaella, I can confirm our bot's answer. There's currently no built-in functionality in the Catalog UI to export workspaces to CSV directly. We can mark this as product feedback on your behalf.
r
Thanks @Shamil Akhmadyshev. Can we pull this info via API? Any recommendations on how to do it?
s
Hi Raffaella, Yes, here's how to pull each object type via the API: • Metrics —
GET /api/v1/entities/workspaces/{workspaceId}/metrics
Documentation on how to Create and manage metrics via API • Attributes —
GET /api/v1/entities/workspaces/{workspaceId}/attributes
• Visualizations —
GET /api/v1/entities/workspaces/{workspaceId}/visualizationObjects
• Dashboards —
GET /api/v1/entities/workspaces/{workspaceId}/analyticalDashboards
For attributes, visualizations and dashboards the endpoints are documented in the API reference — search for the entity name on that page. All endpoints support a
filter
RSQL parameter (e.g.
?filter=title=like=*revenue*
) and pagination via
page
/
size
. Here is the list of all API references Hope that helps!
m
Hi Raffaella, please let us know if you need further assistance with this.