# Calendly V2

### Snapshot

| Features                        | Details               |
| ------------------------------- | --------------------- |
| Release Status                  | Released              |
| Source API Version              | V2                    |
| Table Selection                 | Yes                   |
| Column Selection                | Yes                   |
| Edit Integration                | Yes                   |
| Replication Type Selection      | No                    |
| Authentication Parameters       | Calendly Access Token |
| Replication Type                | Full Load             |
| Replication Key                 | NA                    |
| Suggested Replication Frequency | 24 hours              |

### Tables/APIs supported

| Scheduled Events         | Event Invitees           |
| ------------------------ | ------------------------ |
| Event Types              | Organization Memberships |
| Organization Invitations |                          |

### Integrate Calendly with Daton

1. Sign in to Daton
2. Select Calendly from Integrations page
3. Provide Integration Name, Replication Frequency and History. Integration name would be used in creating tables for the integration and cannot be changed later
4. Provide the Calendly access token. Follow this [link](https://docs.sarasanalytics.com/faqs/api-keys/how-to-generate-access-token-for-calendly) to generate access token
5. Post successful authentication you will be prompted to choose from the list of available tables
6. Then select all required fields for each table
7. Submit the integration

### Workflow

1. Integrations would be in Pending state initially and will be moved to Active state as soon as the first job loads data successfully on to the configured warehouse
2. Users would be able to edit/pause/re-activate/delete integration anytime
3. Users can view job status and process logs from the integration details page by clicking on the integration name from the active list

### Calendly Data

#### **Scheduled Events**

Purpose: This returns a list of all scheduled events of the organization

Source API Documentation: <https://developer.calendly.com/api-docs/2d5ed9bbd2952-list-events>

Replication: Full Replication

Replication Key: NA

**Fields**

| Name               | Data Type |
| ------------------ | --------- |
| uri                | STRING    |
| name               | STRING    |
| status             | STRING    |
| start\_time        | TIMESTAMP |
| end\_time          | TIMESTAMP |
| event\_type        | STRING    |
| location           | RECORD    |
| invitees\_counter  | RECORD    |
| created\_at        | TIMESTAMP |
| updated\_at        | TIMESTAMP |
| event\_memberships | RECORD    |
| event\_guests      | RECORD    |
| cancellation       | RECORD    |
| calendar\_event    | RECORD    |

#### **Event Invitees**

Purpose: This returns a list of invitees of the scheduled events of the organization

Source API Documentation: <https://developer.calendly.com/api-docs/eb8ee72701f99-list-event-invitees>

Replication: Full Replication

Replication Key: NA

**Fields**

| Name                      | Data Type |
| ------------------------- | --------- |
| email                     | STRING    |
| event                     | STRING    |
| name                      | STRING    |
| first\_name               | STRING    |
| last\_name                | STRING    |
| new\_invitee              | STRING    |
| old\_invitee              | STRING    |
| questions\_and\_answers   | RECORD    |
| cancel\_url               | STRING    |
| reschedule\_url           | STRING    |
| rescheduled               | BOOLEAN   |
| status                    | STRING    |
| text\_reminder\_number    | STRING    |
| timezone                  | STRING    |
| tracking                  | RECORD    |
| created\_at               | TIMESTAMP |
| updated\_at               | TIMESTAMP |
| uri                       | STRING    |
| canceled                  | BOOLEAN   |
| routing\_form\_submission | STRING    |
| cancellation              | RECORD    |
| payment                   | RECORD    |
| no\_show                  | RECORD    |
| reconfirmation            | RECORD    |

#### **Event Types**

Purpose: This returns all event types of the organization

Source API Documentation: <https://developer.calendly.com/api-docs/25a4ece03c1bc-list-user-s-event-types>

Replication: Full Replication

Replication Key: NA

**Fields**

| Name               | Data Type |
| ------------------ | --------- |
| uri                | STRING    |
| name               | STRING    |
| active             | BOOLEAN   |
| booking\_method    | STRING    |
| slug               | STRING    |
| scheduling\_url    | STRING    |
| duration           | NUMERIC   |
| kind               | STRING    |
| pooling\_type      | STRING    |
| type               | STRING    |
| color              | STRING    |
| created\_at        | TIMESTAMP |
| updated\_at        | TIMESTAMP |
| internal\_note     | STRING    |
| description\_plain | STRING    |
| description\_html  | STRING    |
| profile            | RECORD    |
| secret             | BOOLEAN   |
| deleted\_at        | TIMESTAMP |
| custom\_questions  | RECORD    |

#### Organization Memberships

Purpose: This returns a list of the organization memberships for all users belonging to an organization

Source API Documentation: <https://developer.calendly.com/api-docs/eaed2e61a6bc3-list-organization-memberships>

Replication: Full Replication

Replication Key: NA

**Fields**

| Name         | Data Type |
| ------------ | --------- |
| uri          | STRING    |
| role         | STRING    |
| user         | RECORD    |
| organization | STRING    |
| created\_at  | TIMESTAMP |
| updated\_at  | TIMESTAMP |

#### Organization Invitations

Purpose: This returns a list of organization invitations that were sent to the organization's members

Source API Documentation: <https://developer.calendly.com/api-docs/3ad68ee2cc606-list-organization-invitations>

Replication: Full Replication

Replication Key: NA

**Fields**

| Name           | Data Type |
| -------------- | --------- |
| uri            | STRING    |
| organization   | STRING    |
| email          | STRING    |
| status         | STRING    |
| created\_at    | TIMESTAMP |
| updated\_at    | TIMESTAMP |
| last\_sent\_at | TIMESTAMP |
| user           | STRING    |