API Catalog (Portelcore)
Live documentation of the OData V4 analytical endpoints deployed in production and their data schemas.
As part of our Business Intelligence and data governance strategy, we have deployed a suite of optimized native APIs. This document serves as a single source of truth for any engineer, data analyst, or process (Power BI, Python, Power Automate) that needs to connect to the ERP.
🔗 Ecosystem Base URL
Sección titulada «🔗 URL Base del Ecosistema»All OData calls must point to this routing base:
https://api.businesscentral.dynamics.com/v2.0/{Tenant_ID}/{Entorno}/api/portelcore/api_portelcore_1/v1.0/companies('{Company_ID}')/
1. Product Movements (movimientos)
Sección titulada «1. Movimientos de Producto (movimientos)»This endpoint is the heart of logistics. It extracts consolidated information from the Item Ledger Entry (Product Movements) table, providing the complete history of inflows and outflows.
- OData Endpoint:
/movimientos - Source Table:
Item Ledger Entry - Source Filters (Pushdown):
- Records with
Global Dimension 1 Code= ‘20’ are omitted. - Restricted to types: Purchases, Sales, and Positive/Negative Adjustments.
- The dummy provider ‘PROVEEDOR_DEMO’ is omitted.
- Records with
- Column Schema (Clean Mapping):
Tipo_MovimientoNum_DocumentoDescripcionCod_Dimension_1Fecha_RegistroCantidadNombre_ProveedorNombre_cliente
2. Purchase Lines (lineasCompra)
Sección titulada «2. Líneas de Compra (lineasCompra)»- OData Endpoint:
/lineasCompra - Source Table:
Purchase Line - Source Filters (Pushdown):
- Only Order type documents (
Order). - Only pending quantities different from 0 (
Outstanding Quantity <> 0). - Only suppliers whose code starts with P40 (
Buy-from Vendor No.= 'P40*').
- Only Order type documents (
- Column Schema:
Tipo_DocumentoNum_DocumentoNum_ProveedorandNombre_ProveedorDescripcionCantidadandCantidad_PendienteCod_Dimension_1Fecha_ConfirmadaandFecha_Estimada
3. Sales Lines (lineasVenta)
Sección titulada «3. Líneas de Venta (lineasVenta)»- Source Filters (Pushdown):
- Only Order type documents (
Order). - Only pending quantities different from 0.
- Only Open or Released statuses (
Statusin Open or Released).
- Only Order type documents (
- Column Schema:
- Status
Num_DocumentoNombre_ClienteDescripcionCantidadandCantidad_PendienteCod_Dimension_1Fecha_Envio
4. Catalog Integrity Checklist
Sección titulada «4. Checklist de Integridad de Catálogo»- ✓ Base URL: Standardized routing pointing to the corporate publisher
portelcorein its API versionv1.0. - ✓ Schemas: Standardized field mapping without special characters or spaces to streamline data ingestion.
- ✓ Key Filters: Source-side filters (pushdown) fully documented and applied directly to the ERP physical tables.

