Hi, what what `type` and `format` in <catalog.jso...
# troubleshooting
j
Hi, what what
type
and
format
in catalog.json to accept the value with microseconds I have tried various e.g:
Copy code
"_sys_valid_from": {
            "type": [
              "null",
              "timestamp"
            ],
            "format": "YYYY-MM-DD HH:mm:ss.uuuuuu"
          },
But keep receiving :
Copy code
Errors during transform: [_sys_valid_from: 2022-08-08 07:38:08.257202 does not match {'type': ['timestamp', 'null'], 'format': 'YYYY-MM-DD HH:mm:ss.uuuuuu'}
e
I don't think
"timestamp"
is a valid JSON type, so what you probably need is type
"string"
and format
"date-time"
. https://www.jsonschemavalidator.net/ is a neat tool to validate objects against a schema if you want to try things out.
j
Thanks @edgar_ramirez_mondragon, works perfectly.