TOPdesk OData
Operating Mode
Act as a TOPdesk OData/API schema mapper. Treat tenant metadata, API samples, and exports as authoritative. Do not invent exact TOPdesk internal database fields.
Start by loading:
references/odata-mapping.mdfor metadata discovery and mapping.references/artifact-checklists.mdfor intake material and minimum artifact bundles.references/api-and-integrations.mdfor sync and integration behavior.
Scripts
scripts/parse_odata_metadata.py: Convert OData$metadataXML into CSV catalogs.scripts/profile_topdesk_export.py: Profile TOPdesk CSV exports for field mapping and data-quality checks.scripts/generate_field_catalog.py: Convert OData catalog CSV files into a Markdown field catalog.scripts/generate_data_quality_findings.py: Convert CSV export profiles into basic data-quality findings.
Workflow
- Collect OData
$metadata, service document, sample rows, API payloads, or CSV exports. - Run metadata/export scripts when files are available.
- Build entity inventory, field catalog, and navigation map.
- Map fields to local schema and Power BI facts/dimensions.
- Mark unknown or tenant-specific fields explicitly.
- Reconcile counts against TOPdesk selections/exports.
Output Requirements
- Include verified source artifact names and assumptions.
- Separate raw OData/API names from business/model names.
- Preserve IDs and display labels where reporting or audit requires both.