Having issue fetching data from azure sql databse to satatic web app (error 400)

Mattias Clouse 0

I am trying to create an application that displays my database that I have made in azure sql server. I have a swa-db-connections folder with my db entity along with my connection string and everythign else. in my workflow, I have api and data-api set to the swa-db-connections. When I use the fetch request I use fetch('data-api/api/Product') but I keep getting the 400 error code. What am I doing wrong??

Oury Ba-MSFT 18,021 Reputation points Microsoft Employee

2024-06-04T23:26:44.3233333+00:00

@Mattias Clouse Thank you for reaching out.

Please do refer to the following post for the same and let us know by commenting below if the solution help resolved your issue. https://learn.microsoft.com/en-us/answers/questions/1198719/response-status-code-does-not-indicate-success-400

Regards,

Oury
Mattias Clouse 0 Reputation points

2024-06-06T15:45:31.63+00:00

I was unable to resolve the issue the the provided documentation
Mattias Clouse 0 Reputation points

2024-06-06T18:39:57.5366667+00:00

I just managed to fix it, but although it runs great locally, I still get that 400 error from the static web app. I have made sure the connection is set properly and the database is set to accept azure services.
Oury Ba-MSFT 18,021 Reputation points Microsoft Employee

2024-06-25T19:41:45.19+00:00

Mattias Clouse

I would suggest creating a support case so an engineer can look into your environment and troubleshoot this issue. Please let me know if you don't have a support plan.

Regards,

Oury

Share via

Having issue fetching data from azure sql databse to satatic web app (error 400)