Say goodbye to building boring APIs with Data API builder
summary
Data API Builder claims to replace hand‑built CRUD layers by generating REST, OData and GraphQL endpoints from a JSON config that starts in milliseconds. It maps tables/views/stored procedures, enforces item and field security via roles and JWTs, and runs in Docker across clouds with demonstrated Postgres/SQL Server/MySQL/Cosmos DB support (supports SQL Server Postgres MySQL Cosmos DB). It cannot host custom business code, so the shown architecture routes special writes through API Management to functions; the live demo’s CRUD and auth flows work as advertised.
AI-written summary · about
chapters (13)
- 0:00Introduction
- 1:47What makes an API boring
- 4:13Data API Builder
- 8:45Config file
- 10:55REST and OData queries
- 11:35GraphQL queries
- 13:00How Data API Builder works at runtime
- 14:05Live demo
- 18:40Custom logic
- 20:02Security
- 22:27Cloud hosting
- 24:55Azure Static Web Apps
- 25:59Conclusion
related talks
43mIncrease developer velocity with Azure SQL Database from data to API
15mEffortless GraphQL: Data API Builder with Azure Cosmos DB Emulator for Cost-Free Cloud Simulation
38mGraphQL: New services and tools for building API-driven apps
39mEmbedded Analytics through Data API
01h 00mBuilding an API with Apigility
26mServing Data as API
19mUnlock API and Data – The Power of Data Model and Governance
14mAPI in a box