Incorrect syntax near 'INCLUDE_NULL_VALUES

[sreevelicheti]

I get the below error when I execute a REST API method from swagger.

{ "error": { "code": "DatabaseOperationFailed", "message": "Incorrect syntax near 'INCLUDE_NULL_VALUES'.", "status": 500 } }

[seantleonard]

Can you help us create a repro by supplying samples of:

1. database schema
2. Dab-config.json
3. what you are filling in within the Swagger UI?
4. Console output of DAB which shows the generated SQL query and relevant errors?

[rawatrinku1412]

Hi, I am also facing same issue in get API and post API is working fine.

Please help anyone.

Thanks

[waqarkabir]

This error does not appear when using the latest version of SQL Server. I have also tested this in mssqllocaldb.

[OlaideNi]

Use store procedure instead of table "entities": { "GetUser": { "source": { "object": "dbo.GetUser", "type": "stored-procedure", "key-fields": ["id"]

[waqarkabir]

This error does not appear when using the latest version of SQL Server. I have also tested this in mssqllocaldb.