Better error response for wrong datetime format in REST filter

[timvisee]

Is your feature request related to a problem? Please describe.
We recently merged #3395 which adds a datetime payload index.

Currently, the datetime parser is very strict, only allowing RFC 3339 formats in our REST API. A common format such as YYYY-MM-DD HH:MM:SS is currently not accepted.

If you'd send the following request:

POST collections/test_collection/points/scroll
{
  "limit": 10,
  "filter": {
    "must": [
      {
        "key": "updated",
        "datetime_range": {
          "gt": "2014-01-01T00:00:00"
        }
      }
    ]
  }
}

You'd receive the following error:

Format error in JSON body: data did not match any variant of untagged enum Condition at line 1 column 96

This error is very confusing.

Describe the solution you'd like
We'd strongly prefer a more descriptive error message instead.

Something like this would be a lot better:

Format error in JSON body: '2014-01-01T00:00:00' does not match any accepted datetime format

Describe alternatives you've considered
None

Additional context
Related issue: #3529

[kartikchoubisa]

Much needed. I'd rather have it parse multiple formats, but for now I don't mind having at least a better error message.
I could take up this issue

[generall]

@kartikchoubisa it is already merged

[generall]

/bounty $100

[algora-pbc]

💎 $100 bounty • Qdrant

Steps to solve:

1. Start working: Comment /attempt #3531 with your implementation plan
2. Submit work: Create a pull request including /claim #3531 in the PR body to claim the bounty
3. Receive payment: 100% of the bounty is received 2-5 days post-reward. Make sure you are eligible for payouts

Thank you for contributing to qdrant/qdrant!

Add a bounty • Share on socials

Attempt	Started (GMT+0)	Solution
🔴 @syedbarimanjan	Apr 23, 2024, 11:58:24 PM	WIP
🟢 @gsaivinay	Apr 24, 2024, 7:12:42 PM	#4111

[gsaivinay]

/attempt #3531

Algora profile	Completed bounties	Tech	Active attempts	Options
@gsaivinay	1 Qdrant bounty	Python		Cancel attempt

[algora-pbc]

💡 @gsaivinay submitted a pull request that claims the bounty. You can visit your bounty board to reward.