Azure / Azure/data-api-builder

[Bug]: OpenAPI and $filter for dates

Open
#2,783 5 comments 6 reactions 3 assignees Claimed by @JerryNixon View on GitHub
2.2 bug cri open-api triage
Dominant language
C#
Stars
1.5k
Forks
370
Avg merge
3d 17h
Merged PRs (30d)
8

Description

### What happened?

Hi Team,

We've developed a custom frontend and backend solution to manage API creation on our API Management platform, utilizing Data API Builder (DAB) to select fields and apply dynamic and fixed filters to APIs.

The issue arises with certain MSSQL tables using the datetime(2) data type. In the OpenAPI specification generated by DAB, these columns are represented as string types without a specified format.

**OpenAPI exposed by DAB**
Image

For exposure through REST we don't have issues, but there's now a requirement to add filters based on those dates.
The data within the database looks like a normal date (not ISO8601 compliant) and is exposed through DAB rest endpoint as follows:

Image

According to the documentation, date values should not be enclosed in quotes. However, when dynamically constructing the $filter parameter for DAB, we currently lack a method to distinguish whether a field is a true string or a date field.

Image

One proposed solution was to omit quotes for non-eq comparisons, but this approach fails when an exact date match is required.

Any insights or suggestions to address this issue would be appreciated.

Best Regards,
Siebe

### Version

1.3.19

### What database are you using?

Azure SQL

### What hosting model are you using?

Container Apps

### Which API approach are you accessing DAB through?

REST

### Relevant log output

```Text

```

### Code of Conduct

- [x] I agree to follow this project's Code of Conduct

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.