# SugarCRM

## Snapshot

| Features                        | Details                                           |
| ------------------------------- | ------------------------------------------------- |
| Release Status                  | Released                                          |
| Source API Version              | V10                                               |
| Table Selection                 | Yes                                               |
| Column Selection                | Yes                                               |
| Edit Integration                | Yes                                               |
| Replication Type Selection      | No                                                |
| Authentication Parameters       | None                                              |
| Replication Type                | <p>Key Based Replication,<br>Full Replication</p> |
| Replication Key                 | date\_modified                                    |
| Suggested Replication Frequency | 24 hours                                          |

## **Tables/APIs Supported**

| accounts               | currencies                         |
| ---------------------- | ---------------------------------- |
| meetings               | contacts                           |
| cases                  | calendar                           |
| emails                 | calculated\_fields\_updated\_queue |
| tags                   | product\_catalog                   |
| purchases              | tasks                              |
| calls                  | notes                              |
| purchased\_line\_items |                                    |

## Integrate SugarCRM with Daton

1. Sign in to Daton
2. Select SugarCRM 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. In the next step you will be asked to enter sugar CRM site url, sugar CRM username and password
5. Post successful authentication you will be prompted to choose required tables from the list
6. Then select all required fields
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

## Sugar CRM Data

### accounts <a href="#billable-items" id="billable-items"></a>

Purpose: This API is used to fetch all the accounts for the given credentials

Replication: Key Based Incremental

Replication Key: date\_modified

**Fields**

| Name                             | Data Type |
| -------------------------------- | --------- |
| <p><br>business\_center\_id</p>  | STRING    |
| campaign\_id                     | STRING    |
| campaign\_name                   | STRING    |
| campaign\_accounts               | RECORD    |
| next\_renewal\_date              | STRING    |
| widget\_next\_renewal\_date      | STRING    |
| hint\_account\_size              | STRING    |
| hint\_account\_industry          | STRING    |
| hint\_account\_location          | STRING    |
| hint\_account\_industry\_tags    | STRING    |
| hint\_account\_founded\_year     | STRING    |
| hint\_account\_facebook\_handle  | STRING    |
| hint\_account\_logo              | STRING    |
| hint\_account\_pic               | STRING    |
| hint\_account\_naics\_code\_lbl  | STRING    |
| hint\_account\_fiscal\_year\_end | STRING    |
| geocode\_status                  | STRING    |
| following                        | BOOLEAN   |
| my\_favorite                     | BOOLEAN   |
| sync\_key                        | STRING    |
| assigned\_user\_id               | STRING    |
| assigned\_user\_name             | STRING    |
| assigned\_user\_link             | RECORD    |
| team\_count                      | STRING    |
| team\_count\_link                | RECORD    |
| team\_name                       | RECORD    |
| email1                           | STRING    |
| email2                           | STRING    |
| invalid\_email                   | STRING    |
| email\_opt\_out                  | STRING    |
| email\_addresses\_non\_primary   | STRING    |
| is\_escalated                    | BOOLEAN   |
| prosperworks\_id\_c              | STRING    |
| days\_since\_last\_activity\_c   | NUMERIC   |
| interaction\_count\_c            | NUMERIC   |
| channel\_c                       | STRING    |
| most\_recent\_opportunity\_c     | STRING    |
| first\_closed\_won\_opp\_c       | STRING    |
| type\_visibility\_c              | STRING    |
| custom\_type\_c                  | STRING    |
| last\_activity\_date\_c          | DATE      |
| first\_order\_c                  | STRING    |
| last\_order\_date\_c             | STRING    |
| date\_converted\_c               | STRING    |
| days\_since\_last\_order\_c      | NUMERIC   |
| master\_type\_c                  | STRING    |
| \_module                         | STRING    |

### currencies <a href="#billable-items" id="billable-items"></a>

Purpose: This API is used to fetch the currencies associated with the account

Replication: Full Replication

Replication Key: NA

**Fields**

| Name             | Data Type |
| ---------------- | --------- |
| id               | STRING    |
| name             | STRING    |
| symbol           | STRING    |
| iso4217          | STRING    |
| conversion\_rate | NUMERIC   |
| status           | STRING    |
| deleted          | BOOLEAN   |
| hide             | STRING    |
| unhide           | STRING    |
| my\_favorite     | BOOLEAN   |
| \_module         | STRING    |

### meetings <a href="#billable-items" id="billable-items"></a>

Purpose: This API is used to fetch all the meetings for the given credentials

Replication: Key Based Incremental

Replication Key: date\_modified

**Fields**

| Name                     | Data Type |
| ------------------------ | --------- |
| id                       | STRING    |
| name                     | STRING    |
| date\_entered            | TIMESTAMP |
| date\_modified           | TIMESTAMP |
| modified\_user\_id       | STRING    |
| modified\_by\_name       | STRING    |
| modified\_user\_link     | RECORD    |
| created\_by              | STRING    |
| created\_by\_name        | STRING    |
| created\_by\_link        | RECORD    |
| description              | STRING    |
| deleted                  | BOOLEAN   |
| accept\_status           | STRING    |
| set\_accept\_links       | STRING    |
| location                 | STRING    |
| password                 | STRING    |
| join\_url                | STRING    |
| host\_url                | STRING    |
| displayed\_url           | STRING    |
| creator                  | STRING    |
| external\_id             | STRING    |
| duration\_hours          | NUMERIC   |
| duration\_minutes        | NUMERIC   |
| date\_start              | TIMESTAMP |
| date\_end                | TIMESTAMP |
| parent\_type             | STRING    |
| status                   | STRING    |
| type                     | STRING    |
| direction                | STRING    |
| parent\_id               | STRING    |
| reminder\_checked        | STRING    |
| reminder\_time           | NUMERIC   |
| email\_reminder\_checked | STRING    |
| email\_reminder\_time    | NUMERIC   |
| email\_reminder\_sent    | BOOLEAN   |
| outlook\_id              | STRING    |
| sequence                 | NUMERIC   |
| contact\_name            | STRING    |
| contacts                 | RECORD    |
| parent\_name             | STRING    |
| accept\_status\_users    | STRING    |
| internal\_notes          | STRING    |
| contact\_id              | STRING    |
| repeat\_type             | STRING    |
| repeat\_interval         | NUMERIC   |
| repeat\_dow              | STRING    |
| repeat\_until            | STRING    |
| repeat\_count            | NUMERIC   |
| repeat\_selector         | STRING    |
| repeat\_days             | STRING    |
| repeat\_ordinal          | STRING    |
| repeat\_unit             | STRING    |
| repeat\_parent\_id       | STRING    |
| recurrence\_id           | STRING    |
| recurring\_source        | STRING    |
| following                | BOOLEAN   |
| my\_favorite             | BOOLEAN   |
| sync\_key                | STRING    |
| assigned\_user\_id       | STRING    |
| assigned\_user\_name     | STRING    |
| assigned\_user\_link     | RECORD    |
| team\_count              | STRING    |
| team\_count\_link        | RECORD    |
| team\_name               | RECORD    |
| type\_of\_meeting\_c     | STRING    |
| \_module                 | STRING    |

### contacts <a href="#billable-items" id="billable-items"></a>

Purpose: This API is used to fetch all the contacts associated in the account

Replication: Key Based Incremental

Replication Key: date\_modified

**Fields**

| Name                                | Data Type |
| ----------------------------------- | --------- |
| id                                  | STRING    |
| name                                | STRING    |
| date\_entered                       | TIMESTAMP |
| date\_modified                      | TIMESTAMP |
| modified\_user\_id                  | STRING    |
| modified\_by\_name                  | STRING    |
| modified\_user\_link                | RECORD    |
| created\_by                         | STRING    |
| created\_by\_name                   | STRING    |
| created\_by\_link                   | RECORD    |
| description                         | STRING    |
| deleted                             | BOOLEAN   |
| salutation                          | STRING    |
| first\_name                         | STRING    |
| last\_name                          | STRING    |
| full\_name                          | STRING    |
| title                               | STRING    |
| facebook                            | STRING    |
| twitter                             | STRING    |
| googleplus                          | STRING    |
| department                          | STRING    |
| do\_not\_call                       | BOOLEAN   |
| phone\_home                         | STRING    |
| phone\_mobile                       | STRING    |
| phone\_work                         | STRING    |
| phone\_other                        | STRING    |
| phone\_fax                          | STRING    |
| primary\_address\_street            | STRING    |
| primary\_address\_street\_2         | STRING    |
| primary\_address\_street\_3         | STRING    |
| primary\_address\_city              | STRING    |
| primary\_address\_state             | STRING    |
| primary\_address\_postalcode        | STRING    |
| primary\_address\_country           | STRING    |
| alt\_address\_street                | STRING    |
| alt\_address\_street\_2             | STRING    |
| alt\_address\_street\_3             | STRING    |
| alt\_address\_city                  | STRING    |
| alt\_address\_state                 | STRING    |
| alt\_address\_postalcode            | STRING    |
| alt\_address\_country               | STRING    |
| assistant                           | STRING    |
| assistant\_phone                    | STRING    |
| picture                             | STRING    |
| email\_and\_name1                   | STRING    |
| lead\_source                        | STRING    |
| account\_name                       | STRING    |
| accounts                            | RECORD    |
| account\_id                         | STRING    |
| dnb\_principal\_id                  | STRING    |
| opportunity\_role\_fields           | STRING    |
| opportunities                       | RECORD    |
| opportunity\_role\_id               | STRING    |
| opportunity\_role                   | STRING    |
| reports\_to\_id                     | STRING    |
| report\_to\_name                    | STRING    |
| reports\_to\_link                   | RECORD    |
| birthdate                           | STRING    |
| portal\_name                        | STRING    |
| portal\_active                      | BOOLEAN   |
| portal\_app                         | STRING    |
| portal\_user\_company\_name         | STRING    |
| preferred\_language                 | STRING    |
| cookie\_consent                     | BOOLEAN   |
| cookie\_consent\_received\_on       | STRING    |
| business\_center\_name              | STRING    |
| business\_centers                   | RECORD    |
| business\_center\_id                | STRING    |
| dp\_consent\_last\_updated          | DATE      |
| campaign\_id                        | STRING    |
| campaign\_name                      | STRING    |
| campaign\_contacts                  | RECORD    |
| c\_accept\_status\_fields           | STRING    |
| calls                               | RECORD    |
| m\_accept\_status\_fields           | STRING    |
| meetings                            | RECORD    |
| accept\_status\_id                  | STRING    |
| accept\_status\_name                | STRING    |
| accept\_status\_calls               | STRING    |
| accept\_status\_meetings            | STRING    |
| accept\_status\_messages            | STRING    |
| hint\_account\_size                 | STRING    |
| hint\_account\_industry             | STRING    |
| hint\_account\_location             | STRING    |
| hint\_account\_description          | STRING    |
| <p><br>hint\_industry\_tags</p>     | STRING    |
| hint\_account\_founded\_year        | STRING    |
| hint\_account\_facebook\_handle     | STRING    |
| hint\_account\_twitter\_handle      | STRING    |
| hint\_account\_logo                 | STRING    |
| hint\_contact\_pic                  | STRING    |
| hint\_photo                         | STRING    |
| hint\_phone\_1                      | STRING    |
| hint\_phone\_2                      | STRING    |
| hint\_account\_website              | STRING    |
| hint\_account\_naics\_code\_lbl     | STRING    |
| hint\_account\_sic\_code\_label     | STRING    |
| hint\_account\_fiscal\_year\_end    | STRING    |
| hint\_account\_annual\_revenue      | STRING    |
| geocode\_status                     | STRING    |
| sync\_contact                       | BOOLEAN   |
| market\_interest\_prediction\_score | STRING    |
| mkto\_sync                          | BOOLEAN   |
| entry\_source                       | STRING    |
| site\_user\_id                      | STRING    |
| following                           | BOOLEAN   |
| my\_favorite                        | BOOLEAN   |
| sync\_key                           | STRING    |
| assigned\_user\_id                  | STRING    |
| assigned\_user\_name                | STRING    |
| assigned\_user\_link                | RECORD    |
| team\_count                         | STRING    |
| team\_count\_link                   | RECORD    |
| team\_name                          | RECORD    |
| email                               | RECORD    |
| email1                              | STRING    |
| email2                              | STRING    |
| invalid\_email                      | BOOLEAN   |
| email\_opt\_out                     | BOOLEAN   |
| email\_addresses\_non\_primary      | STRING    |
| source\_id                          | STRING    |
| source\_type                        | STRING    |
| source\_meta                        | STRING    |
| denorm\_account\_name               | STRING    |
| last\_activity\_date\_c             | DATE      |
| prosperworks\_id\_c                 | STRING    |
| contact\_status\_c                  | STRING    |
| interaction\_count\_c               | NUMERIC   |
| create\_opportunity\_c              | STRING    |
| linkedin\_c                         | STRING    |
| lead\_created\_c                    | STRING    |
| \_module                            | STRING    |

### cases <a href="#billable-items" id="billable-items"></a>

Purpose: This API is used to fetch all the cases associated with the given account

Replication: Key Based Incremental

Replication Key: date\_modified

**Fields**

| Name                              | Data Type |
| --------------------------------- | --------- |
| id                                | STRING    |
| name                              | STRING    |
| date\_entered                     | TIMESTAMP |
| date\_modified                    | TIMESTAMP |
| modified\_user\_id                | STRING    |
| modified\_by\_name                | STRING    |
| modified\_user\_link              | RECORD    |
| created\_by                       | STRING    |
| created\_by\_name                 | STRING    |
| created\_by\_link                 | RECORD    |
| description                       | STRING    |
| deleted                           | BOOLEAN   |
| case\_number                      | NUMERIC   |
| type                              | STRING    |
| status                            | STRING    |
| priority                          | STRING    |
| resolution                        | STRING    |
| work\_log                         | STRING    |
| follow\_up\_datetime              | TIMESTAMP |
| widget\_follow\_up\_datetime      | STRING    |
| resolved\_datetime                | STRING    |
| pending\_processing               | BOOLEAN   |
| account\_name                     | STRING    |
| accounts                          | RECORD    |
| account\_id                       | STRING    |
| service\_level                    | STRING    |
| business\_center\_name            | STRING    |
| business\_centers                 | RECORD    |
| business\_center\_id              | STRING    |
| source                            | STRING    |
| request\_close                    | BOOLEAN   |
| request\_close\_date              | STRING    |
| portal\_viewable                  | BOOLEAN   |
| widget\_status                    | STRING    |
| primary\_contact\_name            | STRING    |
| case\_contact                     | RECORD    |
| primary\_contact\_id              | STRING    |
| following                         | BOOLEAN   |
| my\_favorite                      | BOOLEAN   |
| sync\_key                         | STRING    |
| assigned\_user\_id                | STRING    |
| assigned\_user\_name              | STRING    |
| assigned\_user\_link              | RECORD    |
| team\_count                       | STRING    |
| team\_count\_link                 | RECORD    |
| team\_name                        | RECORD    |
| source\_id                        | STRING    |
| source\_type                      | STRING    |
| source\_meta                      | STRING    |
| first\_response\_target\_datetime | STRING    |
| first\_response\_actual\_datetime | STRING    |
| first\_response\_sla\_met         | STRING    |
| first\_response\_user\_id         | STRING    |
| first\_response\_user\_name       | STRING    |
| first\_response\_user\_link       | RECORD    |
| first\_response\_sent             | BOOLEAN   |
| is\_escalated                     | BOOLEAN   |
| denorm\_account\_name             | STRING    |
| type\_other\_details\_c           | STRING    |
| cases\_cases\_1\_name             | STRING    |
| cases\_cases\_1\_right            | RECORD    |
| cases\_cases\_1cases\_ida         | STRING    |
| order\_number\_c                  | STRING    |
| carrier\_c                        | STRING    |
| subcategory\_c                    | STRING    |
| in\_progress\_status\_c           | STRING    |
| product\_temp\_class\_c           | STRING    |
| root\_cause\_c                    | STRING    |
| closed\_reason\_other\_c          | STRING    |
| closed\_reason\_c                 | STRING    |
| category\_c                       | STRING    |
| \_module                          | STRING    |

### calendar <a href="#billable-items" id="billable-items"></a>

Purpose: This API is used to fetch all the calendar details for the given account

Replication: Key Based Incremental

Replication Key: date\_modified

**Fields**

| Name                            | Data Type |
| ------------------------------- | --------- |
| id                              | STRING    |
| name                            | STRING    |
| date\_entered                   | TIMESTAMP |
| date\_modified                  | TIMESTAMP |
| modified\_user\_id              | STRING    |
| modified\_by\_name              | STRING    |
| modified\_user\_link            | RECORD    |
| created\_by                     | STRING    |
| created\_by\_name               | STRING    |
| created\_by\_link               | RECORD    |
| description                     | STRING    |
| deleted                         | BOOLEAN   |
| subject                         | STRING    |
| calendar\_module                | STRING    |
| event\_start                    | STRING    |
| event\_end                      | STRING    |
| duration\_minutes               | STRING    |
| duration\_hours                 | STRING    |
| duration\_days                  | STRING    |
| calendar\_type                  | STRING    |
| color                           | STRING    |
| dblclick\_event                 | STRING    |
| allow\_create                   | BOOLEAN   |
| allow\_update                   | BOOLEAN   |
| allow\_delete                   | BOOLEAN   |
| event\_tooltip\_template        | STRING    |
| day\_event\_template            | STRING    |
| week\_event\_template           | STRING    |
| month\_event\_template          | STRING    |
| agenda\_event\_template         | STRING    |
| timeline\_event\_template       | STRING    |
| schedulermonth\_event\_template | STRING    |
| ical\_event\_template           | STRING    |
| calendar\_filter                | STRING    |
| following                       | BOOLEAN   |
| my\_favorite                    | BOOLEAN   |
| sync\_key                       | STRING    |
| team\_count                     | STRING    |
| team\_count\_link               | RECORD    |
| team\_name                      | RECORD    |
| assigned\_user\_id              | STRING    |
| assigned\_user\_name            | STRING    |
| assigned\_user\_link            | RECORD    |
| \_module                        | STRING    |

### emails <a href="#billable-items" id="billable-items"></a>

Purpose: This API is used to fetch all the emails for the given credentials

Replication: Key Based Incremental

Replication Key: date\_modified

**Fields**

| Name                 | Data Type |
| -------------------- | --------- |
| id                   | STRING    |
| date\_entered        | TIMESTAMP |
| date\_modified       | TIMESTAMP |
| assigned\_user\_id   | STRING    |
| assigned\_user\_name | STRING    |
| assigned\_user\_link | RECORD    |
| modified\_user\_id   | STRING    |
| modified\_by\_name   | STRING    |
| modified\_user\_link | RECORD    |
| created\_by          | STRING    |
| created\_by\_name    | STRING    |
| created\_by\_link    | RECORD    |
| deleted              | BOOLEAN   |
| from\_addr\_name     | STRING    |
| to\_addrs\_names     | STRING    |
| description\_html    | STRING    |
| description          | STRING    |
| date\_sent           | TIMESTAMP |
| message\_id          | STRING    |
| message\_uid         | STRING    |
| name                 | STRING    |
| type                 | STRING    |
| status               | STRING    |
| flagged              | BOOLEAN   |
| reply\_to\_status    | BOOLEAN   |
| intent               | STRING    |
| mailbox\_id          | STRING    |
| mailbox\_name        | STRING    |
| mailbox              | RECORD    |
| state                | STRING    |
| reply\_to\_id        | STRING    |
| parent\_name         | STRING    |
| parent               | RECORD    |
| parent\_type         | STRING    |
| parent\_id           | STRING    |
| direction            | STRING    |
| total\_attachments   | NUMERIC   |
| sync\_key            | STRING    |
| my\_favorite         | BOOLEAN   |
| following            | BOOLEAN   |
| team\_count          | STRING    |
| team\_count\_link    | RECORD    |
| team\_name           | RECORD    |
| \_acl                | RECORD    |
| \_module             | STRING    |

### product\_catalog <a href="#billable-items" id="billable-items"></a>

Purpose: This API is used to fetch all the product catalogs for the given credentials

Replication: Key Based Incremental

Replication Key: date\_modified

**Fields**

| Name                    | Data Type |
| ----------------------- | --------- |
| id                      | STRING    |
| name                    | STRING    |
| date\_entered           | TIMESTAMP |
| date\_modified          | TIMESTAMP |
| modified\_user\_id      | STRING    |
| modified\_by\_name      | STRING    |
| modified\_user\_link    | RECORD    |
| created\_by             | STRING    |
| created\_by\_name       | STRING    |
| created\_by\_link       | RECORD    |
| description             | STRING    |
| deleted                 | BOOLEAN   |
| type\_id                | STRING    |
| manufacturer\_id        | STRING    |
| manufacturer\_name      | STRING    |
| manufacturer\_link      | RECORD    |
| category\_id            | STRING    |
| category\_name          | STRING    |
| category\_link          | RECORD    |
| type\_name              | STRING    |
| type\_link              | RECORD    |
| mft\_part\_num          | STRING    |
| vendor\_part\_num       | STRING    |
| date\_cost\_price       | STRING    |
| cost\_price             | STRING    |
| discount\_price         | STRING    |
| list\_price             | STRING    |
| cost\_usdollar          | STRING    |
| discount\_usdollar      | STRING    |
| list\_usdollar          | STRING    |
| status                  | STRING    |
| tax\_class              | STRING    |
| active\_status          | STRING    |
| date\_available         | STRING    |
| website                 | STRING    |
| support\_name           | STRING    |
| support\_description    | STRING    |
| support\_contact        | STRING    |
| support\_term           | STRING    |
| pricing\_formula        | STRING    |
| service\_duration\_unit | STRING    |
| renewable               | BOOLEAN   |
| service                 | BOOLEAN   |
| lock\_duration          | BOOLEAN   |
| following               | BOOLEAN   |
| my\_favorite            | BOOLEAN   |
| sync\_key               | STRING    |
| assigned\_user\_id      | STRING    |
| assigned\_user\_name    | STRING    |
| assigned\_user\_link    | RECORD    |
| currency\_id            | STRING    |
| base\_rate              | STRING    |
| currency\_name          | STRING    |
| currencies              | RECORD    |
| currency\_symbol        | STRING    |
| team\_count             | STRING    |
| team\_count\_link       | RECORD    |
| team\_name              | RECORD    |
| \_module                | STRING    |

### tags <a href="#billable-items" id="billable-items"></a>

Purpose: This API is used to fetch all the tags for the given account

Replication: Key Based Incremental

Replication Key: date\_modified

**Fields**

| Name                 | Data Type |
| -------------------- | --------- |
| id                   | STRING    |
| name                 | STRING    |
| date\_entered        | TIMESTAMP |
| date\_modified       | TIMESTAMP |
| modified\_user\_id   | STRING    |
| modified\_by\_name   | STRING    |
| modified\_user\_link | RECORD    |
| created\_by          | STRING    |
| created\_by\_name    | STRING    |
| created\_by\_link    | RECORD    |
| description          | STRING    |
| deleted              | BOOLEAN   |
| name\_lower          | STRING    |
| following            | BOOLEAN   |
| my\_favorite         | BOOLEAN   |
| sync\_key            | STRING    |
| source\_id           | STRING    |
| source\_type         | STRING    |
| source\_meta         | STRING    |
| assigned\_user\_id   | STRING    |
| assigned\_user\_name | STRING    |
| assigned\_user\_link | RECORD    |
| \_module             | STRING    |

### purchases <a href="#billable-items" id="billable-items"></a>

Purpose: This API is used to fetch all the purchases for the given credentials

Replication: Key Based Incremental

Replication Key: date\_modified

**Fields**

| Name                    | Data Type |
| ----------------------- | --------- |
| id                      | STRING    |
| name                    | STRING    |
| date\_entered           | TIMESTAMP |
| date\_modified          | TIMESTAMP |
| modified\_user\_id      | STRING    |
| modified\_by\_name      | STRING    |
| modified\_user\_link    | RECORD    |
| created\_by             | STRING    |
| created\_by\_name       | STRING    |
| created\_by\_link       | RECORD    |
| description             | STRING    |
| deleted                 | BOOLEAN   |
| start\_date             | DATE      |
| end\_date               | DATE      |
| service                 | BOOLEAN   |
| total\_revenue          | STRING    |
| total\_quantity         | NUMERIC   |
| pli\_count              | NUMERIC   |
| renewable               | BOOLEAN   |
| product\_template\_id   | STRING    |
| product\_template\_name | STRING    |
| product\_templates      | RECORD    |
| account\_name           | STRING    |
| accounts                | RECORD    |
| account\_id             | STRING    |
| type\_id                | STRING    |
| type\_name              | STRING    |
| product\_types          | RECORD    |
| category\_id            | STRING    |
| category\_name          | STRING    |
| categories              | RECORD    |
| following               | BOOLEAN   |
| my\_favorite            | BOOLEAN   |
| sync\_key               | STRING    |
| assigned\_user\_id      | STRING    |
| assigned\_user\_name    | STRING    |
| assigned\_user\_link    | RECORD    |
| team\_count             | STRING    |
| team\_count\_link       | RECORD    |
| team\_name              | RECORD    |
| currency\_id            | STRING    |
| base\_rate              | STRING    |
| currency\_name          | STRING    |
| currencies              | RECORD    |
| currency\_symbol        | STRING    |
| \_module                | STRING    |

### tasks <a href="#billable-items" id="billable-items"></a>

Purpose: This API is used to fetch all the tasks for the given credentials

Replication: Key Based Incremental

Replication Key: date\_modified

**Fields**

| Name                      | Data Type |
| ------------------------- | --------- |
| id                        | STRING    |
| name                      | STRING    |
| date\_entered             | TIMESTAMP |
| date\_modified            | TIMESTAMP |
| modified\_user\_id        | STRING    |
| modified\_by\_name        | STRING    |
| modified\_user\_link      | RECORD    |
| created\_by               | STRING    |
| created\_by\_name         | STRING    |
| created\_by\_link         | RECORD    |
| description               | STRING    |
| deleted                   | BOOLEAN   |
| status                    | STRING    |
| date\_due\_flag           | BOOLEAN   |
| date\_due                 | TIMESTAMP |
| time\_due                 | STRING    |
| date\_start\_flag         | BOOLEAN   |
| date\_start               | TIMESTAMP |
| parent\_type              | STRING    |
| parent\_name              | STRING    |
| parent                    | RECORD    |
| parent\_id                | STRING    |
| contact\_id               | STRING    |
| contact\_name             | STRING    |
| contacts                  | RECORD    |
| contact\_phone            | STRING    |
| contact\_email            | STRING    |
| priority                  | STRING    |
| following                 | BOOLEAN   |
| my\_favorite              | BOOLEAN   |
| sync\_key                 | STRING    |
| assigned\_user\_id        | STRING    |
| assigned\_user\_name      | STRING    |
| assigned\_user\_link      | RECORD    |
| team\_count               | STRING    |
| team\_count\_link         | RECORD    |
| team\_name                | RECORD    |
| update\_status\_button\_c | STRING    |
| \_module                  | STRING    |

### calls <a href="#billable-items" id="billable-items"></a>

Purpose: This API is used to fetch all the calls for the given credentials

Replication: Key Based Incremental

Replication Key: date\_modified

**Fields**

| Name                               | Data Type |
| ---------------------------------- | --------- |
| id                                 | STRING    |
| name                               | STRING    |
| date\_entered                      | TIMESTAMP |
| date\_modified                     | TIMESTAMP |
| modified\_user\_id                 | STRING    |
| modified\_by\_name                 | STRING    |
| modified\_user\_link               | RECORD    |
| created\_by                        | STRING    |
| created\_by\_name                  | STRING    |
| created\_by\_link                  | RECORD    |
| description                        | STRING    |
| deleted                            | BOOLEAN   |
| internal\_notes                    | STRING    |
| duration\_hours                    | NUMERIC   |
| duration\_minutes                  | NUMERIC   |
| date\_start                        | TIMESTAMP |
| date\_end                          | TIMESTAMP |
| parent\_type                       | STRING    |
| parent\_name                       | STRING    |
| email\_reminder\_checked           | STRING    |
| email\_reminder\_time              | NUMERIC   |
| email\_reminder\_sent              | BOOLEAN   |
| outlook\_id                        | STRING    |
| accept\_status                     | STRING    |
| set\_accept\_links                 | STRING    |
| contact\_name                      | STRING    |
| contacts                           | RECORD    |
| lead\_id                           | STRING    |
| leads                              | RECORD    |
| lead\_name                         | STRING    |
| accept\_status\_users              | STRING    |
| contact\_id                        | STRING    |
| repeat\_type                       | STRING    |
| repeat\_interval                   | NUMERIC   |
| repeat\_dow                        | STRING    |
| repeat\_until                      | STRING    |
| repeat\_count                      | NUMERIC   |
| repeat\_selector                   | STRING    |
| repeat\_days                       | STRING    |
| repeat\_ordinal                    | STRING    |
| repeat\_unit                       | STRING    |
| repeat\_parent\_id                 | STRING    |
| recurrence\_id                     | STRING    |
| recurring\_source                  | STRING    |
| transcript                         | STRING    |
| aws\_contact\_id                   | STRING    |
| call\_recording\_url               | STRING    |
| call\_recording                    | STRING    |
| aws\_lens\_data                    | STRING    |
| sentiment\_score\_agent\_string    | STRING    |
| sentiment\_score\_customer\_string | STRING    |
| following                          | BOOLEAN   |
| my\_favorite                       | BOOLEAN   |
| sync\_key                          | STRING    |
| assigned\_user\_id                 | STRING    |
| assigned\_user\_name               | STRING    |
| assigned\_user\_link               | RECORD    |
| team\_count                        | STRING    |
| team\_count\_link                  | RECORD    |
| team\_name                         | RECORD    |
| call\_type\_c                      | STRING    |
| contact\_c                         | STRING    |
| next\_steps\_c                     | STRING    |
| \_module                           | STRING    |

### notes <a href="#billable-items" id="billable-items"></a>

Purpose: This API is used to fetch all the notes for the given credentials

Replication: Key Based Incremental

Replication Key: date\_modified

**Fields**

| Name                 | Data Type |
| -------------------- | --------- |
| id                   | STRING    |
| name                 | STRING    |
| date\_entered        | TIMESTAMP |
| date\_modified       | TIMESTAMP |
| modified\_user\_id   | STRING    |
| modified\_by\_name   | STRING    |
| modified\_user\_link | RECORD    |
| created\_by          | STRING    |
| created\_by\_name    | STRING    |
| created\_by\_link    | RECORD    |
| description          | STRING    |
| deleted              | BOOLEAN   |
| file\_mime\_type     | STRING    |
| file\_ext            | STRING    |
| file\_source         | STRING    |
| file\_size           | NUMERIC   |
| file\_url            | STRING    |
| filename             | STRING    |
| upload\_id           | STRING    |
| email\_type          | STRING    |
| email\_id            | STRING    |
| note\_parent\_id     | STRING    |
| parent\_type         | STRING    |
| parent\_id           | STRING    |
| contact\_id          | STRING    |
| portal\_flag         | BOOLEAN   |
| embed\_flag          | BOOLEAN   |
| parent\_name         | STRING    |
| parent               | RECORD    |
| contact\_name        | STRING    |
| contact              | RECORD    |
| contact\_phone       | STRING    |
| contact\_email       | STRING    |
| account\_id          | STRING    |
| opportunity\_id      | STRING    |
| acase\_id            | STRING    |
| lead\_id             | STRING    |
| product\_id          | STRING    |
| quote\_id            | STRING    |
| user\_name           | STRING    |
| external\_user       | RECORD    |
| external\_id         | STRING    |
| entry\_source        | STRING    |
| attachment\_flag     | BOOLEAN   |
| following            | BOOLEAN   |
| my\_favorite         | BOOLEAN   |
| sync\_key            | STRING    |
| assigned\_user\_id   | STRING    |
| assigned\_user\_name | STRING    |
| assigned\_user\_link | RECORD    |
| team\_count          | STRING    |
| team\_count\_link    | RECORD    |
| team\_name           | RECORD    |
| source\_id           | STRING    |
| source\_type         | STRING    |
| source\_meta         | STRING    |
| \_module             | STRING    |

### purchased\_line\_items <a href="#billable-items" id="billable-items"></a>

Purpose: This API is used to fetch all the purchased line items for the given credentials

Replication: Key Based Incremental

Replication Key: date\_modified

**Fields**

| Name                             | Data Type |
| -------------------------------- | --------- |
| id                               | STRING    |
| name                             | STRING    |
| date\_entered                    | TIMESTAMP |
| date\_modified                   | TIMESTAMP |
| modified\_user\_id               | STRING    |
| modified\_by\_name               | STRING    |
| modified\_user\_link             | RECORD    |
| created\_by                      | STRING    |
| created\_by\_name                | STRING    |
| created\_by\_link                | RECORD    |
| description                      | STRING    |
| deleted                          | BOOLEAN   |
| annual\_revenue                  | STRING    |
| book\_value\_usdollar            | STRING    |
| cost\_price                      | STRING    |
| cost\_usdollar                   | STRING    |
| date\_closed                     | DATE      |
| date\_closed\_timestamp          | NUMERIC   |
| deal\_calc                       | STRING    |
| deal\_calc\_usdollar             | STRING    |
| discount\_amount                 | STRING    |
| discount\_amount\_signed         | STRING    |
| discount\_amount\_usdollar       | NUMERIC   |
| discount\_price                  | STRING    |
| discount\_select                 | BOOLEAN   |
| discount\_usdollar               | STRING    |
| list\_usdollar                   | STRING    |
| mft\_part\_num                   | STRING    |
| revenue                          | STRING    |
| revenue\_usdollar                | STRING    |
| total\_amount                    | STRING    |
| subtotal                         | STRING    |
| category\_id                     | STRING    |
| category\_name                   | STRING    |
| categories                       | RECORD    |
| manufacturer\_id                 | STRING    |
| manufacturer\_name               | STRING    |
| manufacturer                     | RECORD    |
| product\_template\_id            | STRING    |
| product\_template\_name          | STRING    |
| product\_templates               | RECORD    |
| lock\_duration                   | BOOLEAN   |
| product\_type\_id                | STRING    |
| product\_type\_name              | STRING    |
| product\_type                    | RECORD    |
| purchase\_id                     | STRING    |
| purchase\_name                   | STRING    |
| purchase                         | RECORD    |
| revenuelineitem\_id              | STRING    |
| revenuelineitem\_name            | STRING    |
| revenuelineitem                  | RECORD    |
| account\_id                      | STRING    |
| account\_name                    | STRING    |
| account\_link                    | RECORD    |
| status                           | STRING    |
| following                        | BOOLEAN   |
| my\_favorite                     | BOOLEAN   |
| sync\_key                        | STRING    |
| assigned\_user\_id               | STRING    |
| assigned\_user\_name             | STRING    |
| assigned\_user\_link             | RECORD    |
| team\_count                      | STRING    |
| team\_count\_link                | RECORD    |
| team\_name                       | RECORD    |
| asset\_number                    | STRING    |
| book\_value                      | STRING    |
| book\_value\_date                | STRING    |
| date\_purchased                  | STRING    |
| date\_support\_expires           | STRING    |
| date\_support\_starts            | STRING    |
| list\_price                      | STRING    |
| pricing\_formula                 | STRING    |
| quantity                         | NUMERIC   |
| serial\_number                   | STRING    |
| renewable                        | BOOLEAN   |
| service                          | BOOLEAN   |
| service\_duration\_value         | NUMERIC   |
| service\_duration\_unit          | STRING    |
| catalog\_service\_duration\_unit | STRING    |
| service\_duration\_multiplier    | NUMERIC   |
| service\_end\_date               | DATE      |
| service\_start\_date             | DATE      |
| support\_contact                 | STRING    |
| support\_description             | STRING    |
| support\_name                    | STRING    |
| support\_term                    | STRING    |
| tax\_class                       | STRING    |
| vendor\_part\_num                | STRING    |
| website                          | STRING    |
| renewal                          | BOOLEAN   |
| currency\_id                     | STRING    |
| base\_rate                       | STRING    |
| currency\_name                   | STRING    |
| currencies                       | RECORD    |
| currency\_symbol                 | STRING    |
| denorm\_account\_name            | STRING    |
| \_module                         | STRING    |

### calculated\_fields\_updater\_queue

Purpose: This API is used to fetch all the calculated fields updater queue for the given credentials

Replication: Key Based Incremental

Replication Key: date\_modified

**Fields**

| Name                                                     |           |
| -------------------------------------------------------- | --------- |
| id                                                       | STRING    |
| name                                                     | STRING    |
| date\_entered                                            | TIMESTAMP |
| date\_modified                                           | TIMESTAMP |
| modified\_user\_id                                       | STRING    |
| modified\_by\_name                                       | STRING    |
| modified\_user\_link                                     | RECORD    |
| created\_by                                              | STRING    |
| created\_by\_name                                        | STRING    |
| created\_by\_link                                        | RECORD    |
| description                                              | STRING    |
| deleted                                                  | BOOLEAN   |
| target\_module                                           | STRING    |
| parent\_name                                             | STRING    |
| parent                                                   | RECORD    |
| parent\_type                                             | STRING    |
| parent\_id                                               | STRING    |
| record\_state                                            | STRING    |
| processed\_date                                          | TIMESTAMP |
| pre\_update\_record\_structure                           | STRING    |
| post\_update\_record\_structure                          | STRING    |
| queue\_number                                            | NUMERIC   |
| processed\_fields                                        | STRING    |
| wcfu\_config\_name                                       | STRING    |
| wsys\_wcfuconfigs\_wsys\_wcfuqueue                       | RECORD    |
| wcfu\_config\_id                                         | STRING    |
| wcfu\_log\_name                                          | STRING    |
| wsys\_wcfulogs\_wsys\_wcfuqueue                          | RECORD    |
| wcfu\_log\_id                                            | STRING    |
| db\_parent\_name                                         | STRING    |
| following                                                | BOOLEAN   |
| my\_favorite                                             | BOOLEAN   |
| sync\_key                                                | STRING    |
| team\_count                                              | STRING    |
| team\_count\_link                                        | RECORD    |
| team\_name                                               | RECORD    |
| assigned\_user\_id                                       | STRING    |
| assigned\_user\_name                                     | STRING    |
| assigned\_user\_link                                     | RECORD    |
| wsys\_wcfuconfigs\_wsys\_wcfuqueue\_name                 | STRING    |
| wsys\_wcfuconfigs\_wsys\_wcfuqueuewsys\_wcfuconfigs\_ida | STRING    |
| wsys\_wcfulogs\_wsys\_wcfuqueue\_name                    | STRING    |
| wsys\_wcfulogs\_wsys\_wcfuqueuewsys\_wcfulogs\_ida       | STRING    |
| \_module                                                 | STRING    |