[Bug]: SWA : Response status code does not indicate success: 400 about data-api-builder HOT 2 OPEN

update : after more digging noticed that the table required Primary key.
however after introducing PK now I'm getting

{"error":{"code":"BadRequest","message":"Invalid request body. Missing field in body: IDs.","status":400}}

I profiled and noticed that SWA is running the following

exec sp_executesql N'SELECT ifsc.column_name from sys.columns as sc INNER JOIN information_schema.columns as ifsc ON (sc.is_computed = 1 or ifsc.data_type = ''timestamp'') AND sc.object_id = object_id(@param0+''.''+@param1) and ifsc.table_name = @param1 AND ifsc.table_schema = @param0 and ifsc.column_name = sc.name;',N'@param0 nvarchar(3),@param1 nvarchar(4)',@param0=N'dbo',@param1=N'test'

from data-api-builder.

To help with repro, can you provide example table schema and contents of your POST request body?

Request should be:

POST  https://white-plant-xxxxxx.5.azurestaticapps.net/data-api/graphql/Mytable

with JSON request body:

{
 "primaryKeyName": "Value",
 "requiredField": "RequiredFieldValue"
}

from data-api-builder.