Ir al contenido

API Catalog (Portelcore)

Live documentation of the OData V4 analytical endpoints deployed in production and their data schemas.

0views

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.

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}')/

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.
  • Column Schema (Clean Mapping):
    • Tipo_Movimiento
    • Num_Documento
    • Descripcion
    • Cod_Dimension_1
    • Fecha_Registro
    • Cantidad
    • Nombre_Proveedor
    • Nombre_cliente
  • 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*').
  • Column Schema:
    • Tipo_Documento
    • Num_Documento
    • Num_Proveedor and Nombre_Proveedor
    • Descripcion
    • Cantidad and Cantidad_Pendiente
    • Cod_Dimension_1
    • Fecha_Confirmada and Fecha_Estimada
  • Source Filters (Pushdown):
    • Only Order type documents (Order).
    • Only pending quantities different from 0.
    • Only Open or Released statuses (Status in Open or Released).
  • Column Schema:
    • Status
    • Num_Documento
    • Nombre_Cliente
    • Descripcion
    • Cantidad and Cantidad_Pendiente
    • Cod_Dimension_1
    • Fecha_Envio
  • ✓ Base URL: Standardized routing pointing to the corporate publisher portelcore in its API version v1.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.