Required JSON schema format for CSV files

Slack Knowledge Base Q&A Connector Development
, , , ,
1

Summary

The user is encountering an error when trying to use a JSON schema for a CSV file in Airbyte. The error message indicates that the provided schema could not be transformed into valid JSON Schema.


Question

Hi, could someone point me to the required json schema format for csv files?
I’m trying to use:

  "$schema": "<http://json-schema.org/draft-07/schema#>",
  "type": "object",
  "properties": {
    "mailingGroupId": {
      "type": ["string", "null"]
    },
    "mailingId": {
      "type": ["string", "null"]
    },
    "userId": {
      "type": ["string", "null"]
    },
    "created": {
      "type": ["string", "null"],
      "format": "date-time"
    },
    "response.category": {
      "type": ["string", "null"]
    },
    "mandatorid": {
      "type": ["integer", "null"]
    },
    "clientid": {
      "type": ["integer", "null"]
    },
    "number": {
      "type": ["integer", "null"]
    },
    "actionsid": {
      "type": ["integer", "null"]
    },
    "targetgroupid": {
      "type": ["integer", "null"]
    },
    "scheduledfinishedid": {
      "type": ["integer", "null"]
    },
    "webtrackingparameter": {
      "type": ["string", "null"]
    },
    "referrertag": {
      "type": ["string", "null"]
    },
    "nlkey": {
      "type": ["string", "null"]
    }
  },
  "required": [
    "mailingGroupId",
    "mailingId",
    "userId",
    "created",
    "mandatorid",
    "clientid",
    "number",
    "actionsid",
    "targetgroupid",
    "scheduledfinishedid"
  ]
}```
but I get
`airbyte_cdk.sources.file_based.exceptions.ConfigValidationError: The provided schema could not be transformed into valid JSON Schema. Contact Support if you need assistance.`

<br>

---

This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here.
[Join the conversation on Slack](https://slack.airbyte.com)

[Click here](https://airbytehq.slack.com/archives/C027KKE4BCZ/p1715674462808399) if you want to access the original thread.

<sub>
`["json-schema", "csv-files", "connector", "config-validation-error", "airbyte-cdk"]`
</sub>