search

Azure / data-api-builder

Data API builder provides modern REST and GraphQL endpoints to your Azure Databases and on-prem stores.
https://aka.ms/dab/docs
MIT License
951 stars 197 forks source link

Incorrect syntax near 'INCLUDE_NULL_VALUES #2380

Open sreevelicheti opened 2 months ago

sreevelicheti commented 2 months ago

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 commented 2 months ago

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 commented 2 months ago

Hi, I am also facing same issue in get API and post API is working fine. 371611151-a34af382-d3e2-4027-9c00-f81dd401fdb8

Please help anyone.

Thanks

waqarkabir commented 2 weeks ago

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