Hi does the connector builder support an API that ...
# help-connector-development
a
Hi does the connector builder support an API that returns data in the following format (i.e. rows expressed as arrays and a column header section) :
Copy code
[
  {
    "reportData": {
      "columns": [
        "date",
        "my col 1",
        "my col 2"
      ],
      "rows": [
        [
          "2023-06-20T00:00:00",
          "value 1",
          "value 2"
        ]
      ]
    }
  }
]
k
A message from kapa.ai
Yes, the Connector Builder supports APIs that return data in JSON format, which includes the format you provided. The data returned by the API should be formatted as JSON for the Connector Builder to work with it ([source](https://docs.airbyte.com/connector-development/connector-builder-ui/connector-builder-compatibility#is-the-data-returned-as-json)). Keep in mind that the Connector Builder is suitable for JSON-based HTTP APIs as a source of records, and there are certain compatibility requirements that need to be met. You can review the [compatibility guide](https://docs.airbyte.com/connector-development/connector-builder-ui/connector-builder-compatibility) for more information. If you need more guidance on using the Connector Builder, you can follow the [tutorial](https://docs.airbyte.com/connector-development/connector-builder-ui/tutorial) and explore the concept pages for topics like [authentication](https://docs.airbyte.com/connector-development/connector-builder-ui/authentication/), [record processing](https://docs.airbyte.com/connector-development/connector-builder-ui/record-processing/), and [pagination](https://docs.airbyte.com/connector-development/connector-builder-ui/pagination/).
a
Yes it is JSON but it has rows expressed as arrays and a column header section, not quite clear how I would map this using the connector builder