Questions tagged [data-api-builder]

The Data API Builder lets you quickly create REST or GraphQL endpoints from database objects. This means your data is accessible from any device, in any language. Its features include an adaptable policy engine and support for essentials like pagination, filtering, and sorting, making CRUD backend service creation a breeze and supercharging developer efficiency.

More information

Data API builder is Open Source and works on any platform. It can be executed on-premises, in container or as a Managed Service in Azure, via the new Database Connection feature available in Azure Static Web Apps.

enter image description here

Features

  • Allow collections, tables, views and stored procedures to be accessed via REST and GraphQL
  • Support authentication via OAuth2/JWT
  • Support for EasyAuth when running in Azure
  • Role-based authorization using received claims
  • Item-level security via policy expressions
  • REST
    • CRUD operations via POST, GET, PUT, PATCH, DELETE
    • filtering, sorting and pagination
  • GraphQL
    • queries and mutations
    • filtering, sorting and pagination
    • relationship navigation
  • Easy development via dedicated CLI
  • Full integration with Static Web Apps via Database Connection feature when running in Azure
  • Open Source
7 questions
2
votes
2 answers

SWA-CLI Data API Builder issue with Node v18.16.0 and unzipper

I am attempting to use SWA-CLI to run/debug a react web app in a PowerShell terminal in Visual Studio Code on my Windows PC. My setup is: OS: Windows 10 Pro (10.0.19044 Build 19044) VS Code: 1.78.2 PowerShell: 5.1.19041.2673 SWA-CLI: 1.1.2 Node.js:…
James98
  • 38
  • 5
1
vote
2 answers

How to fix issue in running an API with forward slashes ("/") in its id path parameter using ApiBuilder Java

I am using ApiBuilder in Java where my id path param has forward slashes ("/") because of encryption. However, the endpoint is not being found when run because the slashes are read as part of the URL, not as the id. Here is how I call the API…
patani20
  • 11
  • 2
1
vote
1 answer

Blazor WASM Static Web App communicate directly with CosmosDB without azure functions

I've been getting a little lost down the rabbit hole of all things azure and blazor and I could use a little direction. I'd like to create a blazor web assembly application that can deploy to an azure static web app where the application can…
0
votes
1 answer

Primary key not configured on the given database object

While calling the REST API created by Data API Builder for my stored procedure: https://localhost:5001/API/pagecustomers/pagesize/10/index/2 I received the error Primary key not configured on the given database object. This is confusing because the…
Jerry Nixon
  • 31,313
  • 14
  • 117
  • 233
0
votes
1 answer

Where can I report an issue or feature idea for the Data API Builder?

I have been using the Data API Builder for some time and like it. However, from time to time I find things that seem like a bug or have ideas I would like to share with the team to make the builder better. Where is the right place to submit bugs for…
Jerry Nixon
  • 31,313
  • 14
  • 117
  • 233
0
votes
0 answers

Is Dependency Injection in a Hot Chocolate Web Application static, or per-instance?

I have a general architectural enquiry about Hot Chocolate. I'm hoping the answer may tell me whether I've made incorrect assumptions or have taken a wrong turn somewhere else. I am building a simulation system providing stateful generated data for…
0
votes
2 answers

How to get proper JWT token using IdentityModel and Azure AD to authenticate with my API?

I have Blazor Server App which is getting data from Microsoft's Data Api Builder (DAB). According to the docs, if I want to secure my API, I have to use Azure AD. I have set up two apps in Azure AD, one for my client and one for my API based on…