---
title: "POST /api/database/data-sync/properties/"
method: POST
path: "/api/database/data-sync/properties/"
tags: ["Database tables"]
---

# POST /api/database/data-sync/properties/

`POST /api/database/data-sync/properties/`

Lists all the properties of the provided data sync type given the request data. This can be used to choose which properties should be included when creating the data sync.

## Request body

- union
  - ICalCalendarDataSyncListDataSyncPropertiesRequest
    - `type` 'ical_calendar' | 'local_baserow_table' | 'jira_issues' | 'github_issues' | 'gitlab_issues' | 'hubspot_contacts' | 'postgresql', required — * `ical_calendar` - ical_calendar * `local_baserow_table` - local_baserow_table * `jira_issues` - jira_issues * `github_issues` - github_issues * `gitlab_issues` - gitlab_issues * `hubspot_contacts` - hubspot_contacts * `postgresql` - postgresql
    - `ical_url` string, uri, required
  - LocalBaserowTableDataSyncListDataSyncPropertiesRequest
    - `type` 'ical_calendar' | 'local_baserow_table' | 'jira_issues' | 'github_issues' | 'gitlab_issues' | 'hubspot_contacts' | 'postgresql', required — * `ical_calendar` - ical_calendar * `local_baserow_table` - local_baserow_table * `jira_issues` - jira_issues * `github_issues` - github_issues * `gitlab_issues` - gitlab_issues * `hubspot_contacts` - hubspot_contacts * `postgresql` - postgresql
    - `source_table_id` integer, required — The ID of the source table that must be synced.
    - `source_table_view_id` integer, nullable — If provided, then only the visible fields and rows matching the filters will be synced.
  - JiraIssuesDataSyncListDataSyncPropertiesRequest
    - `type` 'ical_calendar' | 'local_baserow_table' | 'jira_issues' | 'github_issues' | 'gitlab_issues' | 'hubspot_contacts' | 'postgresql', required — * `ical_calendar` - ical_calendar * `local_baserow_table` - local_baserow_table * `jira_issues` - jira_issues * `github_issues` - github_issues * `gitlab_issues` - gitlab_issues * `hubspot_contacts` - hubspot_contacts * `postgresql` - postgresql
    - `jira_url` string, uri, required — The base URL of your Jira instance (e.g., https://your-domain.atlassian.net).
    - `jira_project_key` string — The project key of the Jira project (e.g., PROJ).
    - `jira_authentication` 'API_TOKEN' | 'PERSONAL_ACCESS_TOKEN' — * `API_TOKEN` - API_TOKEN * `PERSONAL_ACCESS_TOKEN` - PERSONAL_ACCESS_TOKEN
    - `jira_username` string — The username of the Jira account used to authenticate. Is only used if the `jira_authentication` is equal `API_TOKEN`
  - GitHubIssuesDataSyncListDataSyncPropertiesRequest
    - `type` 'ical_calendar' | 'local_baserow_table' | 'jira_issues' | 'github_issues' | 'gitlab_issues' | 'hubspot_contacts' | 'postgresql', required — * `ical_calendar` - ical_calendar * `local_baserow_table` - local_baserow_table * `jira_issues` - jira_issues * `github_issues` - github_issues * `gitlab_issues` - gitlab_issues * `hubspot_contacts` - hubspot_contacts * `postgresql` - postgresql
    - `github_issues_owner` string, required — The owner of the repository on GitHub.
    - `github_issues_repo` string, required — The name of the repository on GitHub.
  - GitLabIssuesDataSyncListDataSyncPropertiesRequest
    - `type` 'ical_calendar' | 'local_baserow_table' | 'jira_issues' | 'github_issues' | 'gitlab_issues' | 'hubspot_contacts' | 'postgresql', required — * `ical_calendar` - ical_calendar * `local_baserow_table` - local_baserow_table * `jira_issues` - jira_issues * `github_issues` - github_issues * `gitlab_issues` - gitlab_issues * `hubspot_contacts` - hubspot_contacts * `postgresql` - postgresql
    - `gitlab_url` string, uri — The base URL to your GitLab instance (e.g. https://gitlab.com)
    - `gitlab_project_id` string, required — The ID of the GitLab project where to sync the issues with.
  - HubSpotContactsDataSyncListDataSyncPropertiesRequest
    - `type` 'ical_calendar' | 'local_baserow_table' | 'jira_issues' | 'github_issues' | 'gitlab_issues' | 'hubspot_contacts' | 'postgresql', required — * `ical_calendar` - ical_calendar * `local_baserow_table` - local_baserow_table * `jira_issues` - jira_issues * `github_issues` - github_issues * `gitlab_issues` - gitlab_issues * `hubspot_contacts` - hubspot_contacts * `postgresql` - postgresql
  - PostgreSQLDataSyncListDataSyncPropertiesRequest
    - `type` 'ical_calendar' | 'local_baserow_table' | 'jira_issues' | 'github_issues' | 'gitlab_issues' | 'hubspot_contacts' | 'postgresql', required — * `ical_calendar` - ical_calendar * `local_baserow_table` - local_baserow_table * `jira_issues` - jira_issues * `github_issues` - github_issues * `gitlab_issues` - gitlab_issues * `hubspot_contacts` - hubspot_contacts * `postgresql` - postgresql
    - `postgresql_host` string, required
    - `postgresql_username` string, required
    - `postgresql_port` integer
    - `postgresql_database` string, required
    - `postgresql_schema` string
    - `postgresql_table` string, required
    - `postgresql_sslmode` 'disable' | 'allow' | 'prefer' | 'require' | 'verify-ca' | 'verify-full' — * `disable` - disable * `allow` - allow * `prefer` - prefer * `require` - require * `verify-ca` - verify-ca * `verify-full` - verify-full

## Response `200`

- ListDataSyncProperty[]
  - `unique_primary` boolean, required
  - `key` string, required
  - `name` string, required
  - `field_type` string, required
  - `initially_selected` boolean, required

## Other responses

- `400`

---

[API](https://skmtc.net/baserow/apis/baserow-api-spec.md) · [All operations](https://skmtc.net/baserow/apis/baserow-api-spec/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/baserow/baserow-api-spec/versions/0c490e5b0c7f/schema)