Hi all, I'm currently working on a custom extract...
# singer-tap-development
m
Hi all, I'm currently working on a custom extractor. To support schema discovery I'm adding different Property as ArrayType(StringType()) to PropertiesList. This results for a column _array_column_ in a schema like this:
Copy code
"schema": {
  "properties": {
    "array_column": {
      "items": {
        "type": [
          "string"
        ]
      },
      "type": [
        "array",
        "null"
      ]
    },
    ...
The incoming data can also contain null values like this:
Copy code
{
...
"array_column": [null, null],
...
}
Is there a way to add "null" to the allowed types of the array_column while using ArrayType(StringType()) without creating any custom types?
Copy code
"schema": {
  "properties": {
    "array_column": {
      "items": {
        "type": [
          "string",
          "null"
        ]
      },
      "type": [
        "array",
        "null"
      ]
    },
    ...
Thank you for your help!
1
e
Not supported at the moment unfortunately. The best workaround I can think of is to use `CustomType`:
ArrayType(CustomType({"type": ["string", "null"]}))
m
That's what I thought. Thank you very much for your answer, Edgar 🙂