Feel like I am monopolising the channel here! Really appreciate the responses. I have a field with the spec:

"timestamp_signup": {
        "type": [
          "null",
          "string"
        ],
        "format": "date-time"
      },

But the API returns empty string for this field when null

"timestamp_signup": "",

Which results in:

ValueError: Could not parse value '' for field 'timestamp_signup'

2023-04-19T12:13:36.921311Z [info     ]     raise ParserError("String does not contain a date: %s", timestr) cmd_type=elb consumer=True name=target-mssql producer=False stdio=stderr string_id=target-mssql
2023-04-19T12:13:36.922028Z [info     ] dateutil.parser._parser.ParserError: String does not contain a date: cmd_type=elb consumer=True name=target-mssql producer=False stdio=stderr string_id=target-mssql

This is only an issue when the object has the

format=date-time

designation. Do I have to special-case this myself? Implement

post_process()

and then coerce empty string to a proper python

None

? Or can meltano handle 'false-y' values like this, and I'm just missing the magic command?