Custom Connector Schema for BambooHR with JSON Array Storage Issue

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

Summary

The user is facing an issue with storing category information as a JSON array in the database. They want to store category.id and category.name in either a separate table or new columns named category_id and category_name.


Question

I am using the UI to build a custom connector for BambooHR. Here is my custom schema: The problem I am having is that the category is stored as an JSON array in database. What I need is to have the category.id and cateogry.name stored in either separate table category or new column named category_id and category_name.

  "$schema": "<http://json-schema.org/schema#>",
  "additionalProperties": true,
  "properties": {
    "id": {
      "type": [
        "string",
        "null"
      ]
    },
    "category": {
      "properties": {
        "id": {
          "type": [
            "string",
            "null"
          ]
        },
        "name": {
          "type": [
            "string",
            "null"
          ]
        }
      },
      "type": [
        "object",
        "null"
      ]
    },
    "description": {
      "type": [
        "string",
        "null"
      ]
    },```

<br>

---

This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. [Click here](https://airbytehq.slack.com/archives/C027KKE4BCZ/p1717091611015609) if you want 
to access the original thread.

[Join the conversation on Slack](https://slack.airbyte.com)

<sub>
["custom-connector", "bamboohr", "json-array", "database-storage", "category-information"]
</sub>