Balance Sheet format

[mattarderne]

We’ve used Stitch to load data into Snowflake using the Stitch CODAT tap.

The resulting JSON loaded into Snowflake seems squashed,with the structure below. The accountID being NULL and the VALUE giving what looks like an “accounting account” and not a GBP value. I'm guessing the schema is just flattening the JSON response and then inserting it?

Anyone else struggling with this or have a better way of dealing with this?

tap-codat output:

"assets": [
      {
        "accountId": null,
        "name": "Assets",
        "name_0": "Assets",
        "value": 212201
      },
      {
        "accountId": null,
        "name": "Fixed Assets",
        "name_0": "Assets",
        "name_1": "Fixed Assets",
        "value": 212201
      },

From CODAT, the api response should be formatted as follows:

{
  "currency": "GBP",
  "reports": [
    {
      "date": "2020-01-31T00:00:00Z",
      "assets": {
        "name": "Assets",
        "value": 212201.00,
        "items": [
          {
            "name": "Fixed Assets",
            "value": 212201.0,
            "items": [
              {
                "name": "Property",
                "value": 212201.0,
                "items": [
                  {
                    "accountId": "0010",
                    "name": "Investment",
                    "value": 212201.0,
                    "items": []
                  }
                ]
              }
            ]
          },