# SailPoint Baserow Connector Documentation

> Baserow Connector Documentation

# Documentation

# Connecting SailPoint and Baserow

To connect SailPoint to the source, perform the following tasks:

## Adding and Configuring the Source in SailPoint

To connect to SailPoint, perform the following steps. Once the connection is made, you can configure it to meet your company's needs.

1. Go to **Admin \> Connections \> Sources**.
2. Select **Create New**.
3. Search for a source type and select **Actions**.
4. In the **Actions** dropdown, select the setup method:

   - **Express Setup** - Quickly create a read-only connection to your target system by providing minimal configurations and authentication. On completion, aggregation is automatically started.

     > **Note**
     >
     > Express Setup supports Credential Providers. For information on supported credential providers and configuration, refer to [Credential Providers](<https://documentation.sailpoint.com/connectors/help/credential_providers.html>). For more information, contact your SailPoint Customer Service Manager.
   - **Standard Setup** - Provide detailed basic configuration to create the source. Once the source is created, continue with source setup.

### Express Setup

1. Review the directions and select **Start Express Setup**.
2. Review the pre-populated source name, source owner, and description. To update, select **Edit**.

   > **Note**
   >
   > Source name must be unique.
3. (Optional) If enabled for your organization, select the **Use a Credential Provider** checkbox to manage the source's authentication using a credential provider.

   > **Note**
   >
   > To add a Credential Provider in SailPoint, go to **Admin \> Connections \> Credential Providers**. For more information about credential providers, refer to [Credential Providers](<https://documentation.sailpoint.com/connectors/help/credential_providers.html>).
4. Configure the authentication to allow SailPoint to connect to the source. For more information, refer to the **Connection Settings** page.
5. Select **Finish**. After a successful test connection, the system creates your source and prompts you to run an aggregation.

   - If you want to aggregate now, select **Aggregate**.

     - To see the latest account aggregation history, go to **Account Management \> Account Aggregation**.
     - To see the list of aggregated source accounts, go to **Account Management \> Accounts**.
   - If you want to aggregate later, select **Exit**. This returns you to the **Sources** page. Your new source is listed, but contains no accounts or aggregation history yet.

### Standard Setup

Configure more detailed settings relative to Express Setup.

1. In the **Source Name** field, enter a unique and descriptive name for your source. Source names cannot exceed 128 characters.
2. In the **Description** field, provide additional details about the source to help distinguish it from similar sources. This field allows a maximum of 2,000 characters.
3. In the **Source Owner** field, begin typing the name of an owner. Matches appear after you type two or more letters. For more information, refer to [Assigning a Source Owner](<https://documentation.sailpoint.com/saas/help/sources/index.html#assigning-a-source-owner>).
4. (Optional) Select a governance group to grant its members [source](<https://documentation.sailpoint.com/saas/help/common/users/user_levels.html#source-sub-admin-user-level>) or [role](<https://documentation.sailpoint.com/saas/help/common/users/user_levels.html#role-sub-admin-user-level>) sub-admin level oversight of the source and its access. For more information, refer to [Creating and Managing Governance Groups](<https://documentation.sailpoint.com/saas/help/common/users/governance_groups.html>).
5. If this source represents a primary system containing your organization's personnel records, select the **Authoritative Source** checkbox. For more information, refer to [Creating Identity Profiles](<https://documentation.sailpoint.com/saas/help/setup/identity_profiles.html>).
6. Select **Continue**. The source is created, and you are navigated to the **Source Setup \> Base Configuration** page. Here, continue to configure your connected source.

## Base Configuration

Provide the base configuration parameters. Information you entered in the Create New Source dialog is automatically entered into the fields in the Base Configuration page. You can edit this information if necessary.

1. Enter a descriptive **Source Name** for the connection.
2. Enter the **Source Description** that provides details necessary to distinguish it from similar connection sources.
3. In **Source Owner**, begin typing the name of the source owner.
4. (Optional) Select the appropriate **Governance Group for Source Management** from the dropdown list. For more information about governance groups, refer to [Associating Governance Groups with a Source](<https://documentation.sailpoint.com/saas/help/common/users/governance_groups.html#associating-a-governance-group-with-a-source>).
5. Select **Create Manual Work Items** to enable the source to support additional source management features such as creating accounts and access profile management.

   > **Important**
   >
   > Once you enable this feature, it can't be disabled.

   For more information on manual work items, refer to [Work Items](<https://developer.sailpoint.com/docs/api/work-items>). For more information on SailPoint features, refer to [SailPoint Identity Services](<https://documentation.sailpoint.com/saas/help/index.html>).
6. Select **Save**.

## Connection Settings

Configure a secured, direct connection to the source.

1. Enter the Baserow host URL as **Base URL**. For example, `https://api.baserow.io/api`.
2. Enter **Username**.
3. Enter **Password**.
4. Enter **Workspace ID**.
5. Enter **Scope ID**.
6. Enter **Scope Type**.
7. Select **Save**.

## Review and Test

Perform a test to confirm the connection to SailPoint.

1. Go to **Review and Test**.
2. Confirm that the entries in each field are correct.

   If you note any mistakes, return to the section and make corrections.
3. Select **Test Connection**.

## SailPoint Application Onboarding

SailPoint application onboarding enables you to easily onboard new applications and create sources following the successful onboarding of a discovery source. To use this feature, continue to **Discovered Applications** in the SailPoint user interface.

For more information, refer to [Application Onboarding](<https://documentation.sailpoint.com/saas/help/ai/app_onboarding/index.html>) in the SailPoint SaaS documentation.

# Integrating SailPoint with Baserow

Baserow is an open-source no-code database tool and Airtable alternative. It helps teams manage data by providing a collaborative platform that combines the ease of a spreadsheet with the power of a relational database, allowing users to build custom applications and automate workflows without writing code. This document provides instructions to configure a new direct connection to a Baserow source. For a reference to the terminology specific to SailPoint products, refer to [Source and Connector Definitions](<https://documentation.sailpoint.com/saas/help/sources/index.html#source-and-connector-definitions>).

> [!NOTE]
>
> To view the latest features, enhancements, and fixes for all SaaS connectors, refer to the [SaaS Release Notes](<https://community.sailpoint.com/release-notes/saas>) page.

## Supported Features

The Baserow connector supports the following:

### Account Management

- Aggregate Accounts

### Entitlement Management

- Aggregate Roles

> [!IMPORTANT]
>
> Quick Compliance connectors have the following manual aggregation limits within a 24-hour period:
>
> - **Organization Admins**: Limited to 3 manual account or entitlement aggregations per day per source. This limit is cumulative across all admins in the organization.
> - **Regular Users**: Limited to 1 manual account or entitlement aggregation per day per source.
>
> These limits ensure that individual compliance statuses are kept up to date while maintaining continuous compliance monitoring. If you need to run additional aggregations beyond these limits, contact SailPoint Support.

## Supported Managed Systems

- Baserow: SaaS (api.baserow.io) and self-hosted versions

## Prerequisites

Ensure the following prerequisites are met before proceeding with the configuration:

- Access to a Baserow account (SaaS or self-hosted) with administrative or member permissions for the specific workspace containing the databases you intend to manage.
- For more information, refer [Baserow Backend API (REST API)](<https://baserow.io/docs/apis/rest-api>) for workspace-related endpoints, generating tokens, and the full API specification.

## Required Permissions

- The connector uses API Token Authentication (and OAuth 2.0 for enterprise SSO integrations) to securely interact with your Baserow data. To ensure the connector can sync your workspaces, databases, and tables, you must generate an API token with the specific scopes listed in the following table.
- API Scopes Required:

| Scope | Description |
| --- | --- |
| create | Required to create new databases, tables, fields, or rows through the API |
| read | Required to list workspaces, view database structures, and retrieve row data |
| update | Required to modify existing table schemas, update field names, or edit record values |
| delete | Required to remove records, tables, or other resources from the workspace |

### Advanced Access Control (RBAC)

If you’re using Baserow Enterprise, permissions are further governed by Role-Based Access Control. Ensure the user associated with the API token is assigned one of the following roles at the workspace or database level:

- **Admin** - Full access to all operations
- **Builder** - Can modify structure and data (required for create, read, update, delete)
- **Editor** - Can modify data but not structure (required for row-level read, update)
- **Viewer** - Read-only access (restricts token to read scope only)

  > **Note**
  >
  > Only Admin can fetch roles. Builder, Editor, and Viewer cannot fetch roles. All roles (Admin, Builder, Editor, and Viewer) can generate tokens and fetch users.
- Configuration Steps:

  1. Sign in to your Baserow account.
  2. Go to **Settings \> API Tokens**.
  3. Create a new token and select the relevant workspace.
  4. Select the **create**, **read**, **update**, and **delete** scopes based on your integration needs.
  5. Copy the generated token for use in the connector setup.

  For more information about token management and security best practices, refer the [Baserow API Documentation](<https://baserow.io/user-docs/personal-api-tokens>).

> [!NOTE]
>
> The linked document is not maintained by SailPoint and is subject to change without notice.

# Schema Reference

The application schema is used to configure the objects returned from a connector.

> [!NOTE]
>
> - The **Account Schema** tab is used to define the attributes for each object type in the application being configured. The schema attributes can be defined as **Entitlement** or **Multi-Valued**. Refer to [Managing Source Account Schemas](<https://documentation.sailpoint.com/saas/help/accounts/schema.html>) for more information.
> - The schema attributes that are not present by [default](<#default-account-schema>) must be defined as strings if not specified.

The Baserow connector uses the following default correlation and object configurations.

## Default Account Schema

Each source supports a variety of details, or attributes, about each user who has an account, such as their name, email address, manager name, and location.

The set of account attributes each source stores and how they're organized is known as the account's *schema*. To best represent your data, you can configure sources to use an account schema matching the one you use in the external connector. Refer to [Managing Source Account Schemas](<https://documentation.sailpoint.com/saas/help/accounts/schema.html>) for more information.

### Default Account ID

SailPoint requires that certain attributes remain in your configuration. These attributes are referred to as *account IDs*.

> [!CAUTION]
>
> Changing the attribute marked as the account ID after aggregating accounts can result in duplicate accounts being created. To avoid this, either reset the accounts on this source before editing the account ID attribute or edit the account ID attribute before aggregating accounts.
>
> To resolve issues caused by changing account IDs, reconfigure them to their default values.

The following table lists the default account IDs for this connector:

| Account ID | Schema Object Type |
| --- | --- |
| id | Account |

### Default Account Attributes

The Baserow connector supports the following default account schema attributes and customer configurable attributes. The attributes must be defined as strings if not specified.

| Attribute Name | Description |
| --- | --- |
| id | Unique ID for the role assignment record |
| name | Display name of the user associated with the workspace membership |
| email | Registered email address of the user |
| workspace | Unique ID of the workspace associated with the user |
| permissions | The access level granted to the user within the workspace |
| created\_on | Timestamp indicating when the user was added to the workspace |
| user\_id | Internal unique ID of the user account in the system |
| to\_be\_deleted | Boolean flag indicating whether the user membership is scheduled for deletion |
| two\_factor\_auth | Information related to the user’s two-factor authentication configuration |

## Default Entitlement Attributes

Entitlement attributes define the entitlements, such as groups or roles, that can be assigned to the managed system's user accounts. Refer to [Managing Entitlements](<https://documentation.sailpoint.com/saas/help/access/entitlements.html>) for more information.

> [!CAUTION]
>
> Changing the attribute marked as the Entitlement ID after aggregating accounts or entitlements can result in duplicate entitlements being created, or access profiles and roles breaking. To avoid this, edit the entitlement schema before performing any aggregations.

### Default Role Attributes

The Baserow connector supports roles. The following attributes must be configured on the managed system and in the SailPoint source schema to manage roles.

| Attribute Name | Description |
| --- | --- |
| role | The name of the assigned role |
| subject.id | Internal unique ID of the user account in the system |
| subject.username | Username used for authentication |
| subject.first\_name | First name of the user |
| subject.email | Email address associated with the user account |
| subject\_id | Direct reference to the user’s unique ID |
| scope\_id | Unique ID of the resource where the role applies |
| subject\_type | The type of entity receiving the role |
| scope\_type | Type of resource |