Add API service (Azure Data API Builder)

[ArcadyRob]

https://learn.microsoft.com/en-us/azure/data-api-builder/overview-to-data-api-builder?tabs=azure-sql

[vincentBeekhuis]

/assign

[ArcadyRob]

good luck amigo! 🐻‍❄️

[zeewar]

/assign

[sander1095]

/assign

[ArcadyRob]

ee'm doorwerken jongens

[sander1095]

We had some issues with setting this up.

I think we need a staticwebapp.config.json file but this seems to be unsupported right now for hybrid next-js apps.

@ArcadyRob What type of next-js app is this repo?

Also, when we create a static web app using vscode, there are multiple next-js options. Which one is correct?

[ArcadyRob]

Installation of the application has been done following the manual: https://nextjs.org/docs/getting-started/installation

Settings were:

What is your project named? polar-dash
Would you like to use TypeScript? No / Yes
Would you like to use ESLint? No / Yes
Would you like to use Tailwind CSS? No / Yes
Would you like to use src/ directory? No / Yes
Would you like to use App Router? (recommended) No / Yes
Would you like to customize the default import alias (@/*)? No / Yes

From the first screenshot you supplied I would say that "Next.js" is the right option.

Feel free to change the config file to your requirements!

[sander1095]

I had a conversation with a PM from Azure SQL about using Azure Data Api Builder without using Static Web App. He said this might work, so it is definitely worth investigating!

https://x.com/sandertenbrinke/status/1711808138100310110?s=20

[sander1095]

Good news everyone!

I've gotten this to work on my own project using Azure Static Web Apps + Azure SQL Data Api Builder: https://github.com/sander1095/swa-dab-test

I created a project using your instructions (with npx create-next-app) and then followed this tutorial:

• https://learn.microsoft.com/en-us/azure/static-web-apps/deploy-nextjs-hybrid#create-a-static-web-app
  • to create a static web app
• https://learn.microsoft.com/en-us/azure/static-web-apps/deploy-nextjs-hybrid#enable-standalone-feature
  • to make the project "standalone" so it is deployable to Azure
  • polar-dash must also get this configured as well!
• https://learn.microsoft.com/en-us/azure/azure-sql/database/single-database-create-quickstart?view=azuresql&tabs=azure-portal
  • to create an Azure SQL Database
• https://learn.microsoft.com/en-us/azure/static-web-apps/database-azure-sql
  • to connect a database

You can see it all working on my domain: https://calm-hill-09bbb1f03.3.azurestaticapps.net/