JSON Schema - allow null with regex pattern

Question

Would like to allow null on an optional date property where the date format is validated with a regex expression. Is this even possible?

"dateOfRetirement": {
  "description": "Optional. Format: yyyy-MM-dd.",
  "type": ["string", "null"],
  "pattern": "^\\d{4}-\\d{2}-\\d{2}$"
}

cramopy · Accepted Answer · 2017-08-15 16:32:43Z

3

To get the regular syntax for that you have to add a condition to your regex.

Your regex will get (assuming your regex syntax has no error!):

^(\\d{4}-\\d{2}-\\d{2}|null)$

Steps done:

In the end the regex will allow a-valid-date-format or null as text.

answered Aug 15, 2017 at 16:15

cramopy

3,5056 gold badges30 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Perfect, thanks! I updated the JSON as well to change: "dateOfRetirement" : "" to: "dateOfRetirement" : null,

that is wrong. The schema in the question is ok, if the value is null the pattern keyword will be ignored.

Mich Talebzadeh · Accepted Answer · 2021-09-20 11:27:32Z

0

I don't think that will work when "column": null.

It will only account for "column": "null" in regex

answered Sep 20, 2021 at 11:27

Mich Talebzadeh

1253 silver badges14 bronze badges