# Schema Information

## Tables/APIs 

The following is the list of tables or APIs associated with the Survicate connector:

* [All\_Surveys](#all_surveys)
* [Retrieve\_Survey](#retrieve_survey)
* [All\_Responses](#all_responses)
* [List\_Questions](#list_questions)
* [Respondents\_Attributes](#respondents_attributes)
* [Respondents\_Responses](#respondents_responses)

#### All\_Surveys

Fetch a list of all surveys within your workspace, including their associated metadata and configuration parameters. For more information, see [Survey](https://developers.survicate.com/data-export/survey/).

{% hint style="info" %}
**Primary Key:** `id` - This is the unique identifier.
{% endhint %}

**Fields**

<table><thead><tr><th width="121">Field Name</th><th width="83">Data Type</th></tr></thead><tbody><tr><td>id</td><td>STRING</td></tr><tr><td>type</td><td>STRING</td></tr><tr><td>name</td><td>STRING</td></tr><tr><td>created_at</td><td>TIMESTAMP</td></tr><tr><td>enabled</td><td>BOOLEAN</td></tr><tr><td>responses</td><td>NUMERIC</td></tr></tbody></table>

#### Retrieve\_Survey&#x20;

Get the details and parameters of a specific survey using its unique survey ID. For more information, see [Retrieve survey information](https://developers.survicate.com/data-export/survey/#retrieve-survey-information).

{% hint style="info" %}
**Primary Key:** `id` - This is the unique identifier.
{% endhint %}

**Fields**

<table><thead><tr><th width="121">Field Name</th><th width="83">Data Type</th></tr></thead><tbody><tr><td>id</td><td>STRING</td></tr><tr><td>type</td><td>STRING</td></tr><tr><td>name</td><td>STRING</td></tr><tr><td>created_at</td><td>TIMESTAMP</td></tr><tr><td>enabled</td><td>BOOLEAN</td></tr><tr><td>responses</td><td>NUMERIC</td></tr><tr><td>author</td><td>RECORD</td></tr><tr><td>first_response_at</td><td>TIMESTAMP</td></tr><tr><td>last_response_at</td><td>TIMESTAMP</td></tr><tr><td>attributes</td><td>STRING</td></tr></tbody></table>

#### All\_Responses&#x20;

Get the list of responses for a specific survey identified by its unique ID. For more information, see [Response](https://developers.survicate.com/data-export/response/).

{% hint style="info" %}
**Primary Key:** `uuid` and `uuid` (respondent) - These two fields together form the unique identifier.
{% endhint %}

**Fields**

<table><thead><tr><th width="121">Field Name</th><th width="83">Data Type</th></tr></thead><tbody><tr><td>uuid</td><td>STRING</td></tr><tr><td>url</td><td>STRING</td></tr><tr><td>device_type</td><td>STRING</td></tr><tr><td>operating_system</td><td>STRING</td></tr><tr><td>language</td><td>STRING</td></tr><tr><td>answers</td><td>RECORD</td></tr><tr><td>collected_at</td><td>TIMESTAMP</td></tr><tr><td>respondent</td><td>RECORD</td></tr></tbody></table>

#### List\_Questions&#x20;

Fetch all the questions in a specific survey, making it simple to study or analyze the survey structure. For more information, see [List questions](https://developers.survicate.com/data-export/survey/#list-questions).

{% hint style="info" %}
**Primary Key:** `id` - This is the unique identifier.
{% endhint %}

**Fields**

<table><thead><tr><th width="121">Field Name</th><th width="83">Data Type</th></tr></thead><tbody><tr><td>id</td><td>NUMERIC</td></tr><tr><td>type</td><td>STRING</td></tr><tr><td>question</td><td>STRING</td></tr><tr><td>introduction</td><td>STRING</td></tr></tbody></table>

#### Respondents\_Attributes&#x20;

The names and values of custom attributes associated with a given respondent and passed to Survicate via the JavaScript API, integrations, or embedded inside the survey link are returned. For more information, see [List respondent's attributes](https://developers.survicate.com/data-export/respondent/#list-respondents-attributes).

{% hint style="info" %}
**Primary Key:** `id` - This is the unique identifier.
{% endhint %}

**Fields**

<table><thead><tr><th width="121">Field Name</th><th width="83">Data Type</th></tr></thead><tbody><tr><td>id</td><td>NUMERIC</td></tr><tr><td>name</td><td>STRING</td></tr><tr><td>value</td><td>STRING</td></tr></tbody></table>

#### Respondents\_Responses&#x20;

Retrieves a list of survey responses provided by the respondents. For more information, see [List respondent's responses](https://developers.survicate.com/data-export/respondent/#list-respondents-responses).

{% hint style="info" %}
**Primary Key:** `id` (survey) - This is the unique identifier.
{% endhint %}

**Fields**

<table><thead><tr><th width="121">Field Name</th><th width="83">Data Type</th></tr></thead><tbody><tr><td>survey</td><td>RECORD</td></tr><tr><td>response</td><td>RECORD</td></tr></tbody></table>