# Close.io (v2017-03-01)
Information note **Close.io (v2017-03-01) end of life**
This version of Close.io reached end of life on **September 17, 2018** and is no longer functioning.
[Upgrade to the latest version (v1) to continue replicating data.](https://help.qlik.com/en-US/stitch/integrations/saas/closeio)
## Close.io feature snapshot
A high-level look at Stitch's Close.io (v2017-03-01) integration, including release status, useful links, and the features supported in Stitch.
| **STITCH** | | | |
| --- | --- | --- | --- |
| **[Release status](https://help.qlik.com/en-US/stitch/integrations/identify-an-integration-version)** | Sunset on September 17, 2018 | **Supported by**
the Info icon
Indicates if the integration is supported by Stitch or the Singer community. | [Stitch](https://community.qlik.com/t5/Support/ct-p/qlikSupport) |
| **Stitch plan**
the Info icon
The type of Stitch plan required to use the integration. | Standard | **[API availability](https://help.qlik.com/en-US/stitch/developers/stitch-connect/guides/source-destination-reference)**
the Info icon
Indicates if the integration is available as a source in Stitch Connect. | the Remove icon
This version of the integration isn't available via the API.
Not available |
| **Singer GitHub repository** | [singer-io/tap-closeio](https://github.com/singer-io/tap-closeio) | | |
| **REPLICATION SETTINGS** | | | |
| **[Anchor Scheduling](https://help.qlik.com/en-US/stitch/replication/replication-scheduling/anchor-scheduling)**
the Info icon
A type of replication scheduling where an integration's Replication Frequency is anchored to a time you select. | the Success icon
This feature is supported for this version of the integration.
Supported | **[Advanced Scheduling](https://help.qlik.com/en-US/stitch/replication/replication-scheduling/advanced-scheduling)**
the Info icon
A type of replication scheduling that allows you to specify granular start times for data extraction using cron expressions. | the Remove icon
Advanced Scheduling is not supported for this integration.
Unsupported |
| **Table-level reset**
the Info icon
Indicates if data can be reset at the table level. If unsupported, data can only be reset at the integration level. | the Remove icon
Table-level resets are not supported for this integration. Resets are only supported at the integration level.
Unsupported | **[Configurable Replication Methods](https://help.qlik.com/en-US/stitch/replication/replication-methods)**
the Info icon
Indicates if Replication Methods can be defined by you for tables in the integration. | the Remove icon
Configurable Replication Methods are not supported for this integration. Stitch will use pre-defined replication methods for tables you set to replicate.
Unsupported |
| **DATA SELECTION** | | | |
| **Table selection**
the Info icon
The ability to select individual tables for replication in the Stitch interface. If table selection is unavailable, all tables and all the columns they contain will be set to replicate by default. | the Remove icon
Table selection is not supported for this integration. All available table and fields will be automatically selected for replication.
Unsupported | **Column selection**
the Info icon
The ability to select individual columns for replication in the Stitch interface. If column selection is unavailable, all columns will be set to replicate by default. | the Remove icon
Column selection is not supported for this integration. All available columns in tables set to replicate will be selected.
Unsupported |
| **Select all**
the Info icon
Indicates if the integration supports selecting all available tables and columns. | the Remove icon
As this integration doesn't support table or column selection, all available tables and columns are automatically replicated.
Unsupported | | |
| **TRANSPARENCY** | | | |
| **[Extraction Logs](https://help.qlik.com/en-US/stitch/replication/extractions/integration-extraction-logs)**
the Info icon
Logs detailing the Extraction phase of the replication process for a given integration. Includes error info, should an error occur. | the Remove icon
This feature is not supported for this version of the integration.
Unsupported | **[Loading Reports](https://help.qlik.com/en-US/stitch/replication/integration-loading-reports)**
the Info icon
Reports detailing the Loading phase of the replication process for a given integration. Includes the number of rows loaded for each table and error info, should an error occur. | the Success icon
This feature is supported for this version of the integration.
Supported |
## Close.io table reference
Information note
**Schemas and versioning**
Schemas and naming conventions can change from version to version, so we recommend verifying your integration’s version before continuing.
The schema and info displayed below is for **version 2017-03-01** of this integration.
leads Replication Method: Key-based Incremental Key-based Incremental Replication is a replication method in which Stitch identifies new and updated data using a column called a Replication Key. Primary Key: id Contains Nested Structures?: Yes If your destination doesn't natively support nested structures, Stitch will de-nest them and create subtables. See Table Info for details. The leads table contains the leads in your Close.io account. Table Info & Attributes
### leads & Nested Structures
**This table contains nested structures.** If you use a data warehouse that doesn't natively support nested structures, some of the attributes listed below may be in a subtable.
These items are marked with a `*`
### leads Attributes
While we try to include everything Close.io has here, **this may not be a full list of attributes.** Refer to [Close.io's documentation](http://developer.close.io/#leads-list-or-search-for-leads) for a full list and description of each attribute.
* Lead ID (`id`)
* integration\_links`*`
* description
* updated\_by
* status\_id
* opportunities`*`
* organization\_id
* date\_updated
* created\_by
* tasks`*`
* status\_label
* created\_by\_name
* date\_created
* contacts`*`
* updated\_by\_name
* display\_name
* html\_url
* addresses`*`
* name
* url
#### leads\_\_opportunities
**Replication Method:** Key-based Incremental
Key-based Incremental Replication is a replication method in which Stitch identifies new and updated data using a column called a Replication Key.
**Primary Key:** `id : _sdc_level_0_id`
**Contains Nested Structures?:** No
The `leads__opportunities` table contains info about the opportunities associated with the leads in your Close.io account. **This subtable will only be created if your data warehouse doesn't natively support nested data structures.**
[Table Info & Attributes](https://help.qlik.com/en-US/stitch/integrations/saas/closeio/v2017-03-01#leads__opportunities-data)
### leads\_\_opportunities Attributes
While we try to include everything Close.io has here, **this may not be a full list of attributes.** Refer to [Close.io's documentation](http://developer.close.io/#leads-list-or-search-for-leads) for a full list and description of each attribute.
* Lead ID (`id`)
* Row ID (\_sdc\_level\_0\_id)
* items\_\_value
* items\_\_date\_lost
* items\_\_created\_by
* items\_\_user\_id
* items\_\_contact\_id
* items\_\_updated\_by\_name
* items\_\_updated\_by
* items\_\_status\_id
* items\_\_user\_name
* items\_\_organization\_id
* items\_\_value\_formatted
* items\_\_date\_created
* items\_\_id
* items\_\_value\_currency
* items\_\_value\_period
* items\_\_lead\_id
* items\_\_confidence
* items\_\_contact\_name
* items\_\_date\_updated
* items\_\_status\_label
* items\_\_note
* items\_\_lead\_name
* items\_\_status\_type
* items\_\_created\_by\_name
* items\_\_date\_won
#### activities
**Replication Method:** Append-Only Incremental
Key-based Incremental Replication is a replication method in which Stitch identifies new and updated data using a column called a Replication Key.
**Primary Key:** `id`
**Contains Nested Structures?:** Yes
If your destination doesn't natively support nested structures, Stitch will de-nest them and create subtables. See Table Info for details.
The `activities` table contains the activities performed on a lead or its contacts.
[Table Info & Attributes](https://help.qlik.com/en-US/stitch/integrations/saas/closeio/v2017-03-01#activities-data)
### activities & Nested Structures
**This table contains nested structures.** If you use a data warehouse that doesn't natively support nested structures, some of the attributes listed below may be in a subtable.
These items are marked with a `*`
#### Activity Types & Subtables
Depending on the type of activity - `EmailThread`, for example - you may see subtables, as these record types contain nested data structures.
#### Append-Only Replication
**This table is Append-Only.** Whenever an existing row is updated, it will be appended to the end of the table **as a new row.**
### activities Attributes
While we try to include everything Close.io has here, **this may not be a full list of attributes.** Refer to [Close.io's documentation](http://developer.close.io/#activities-list-or-filter-all-created-activities) for a full list and description of each attribute.
* Activity ID (`id`)
* envelope
* properties`*`
* message\_id
* sender`*`
* date
* subject
* is\_autoreply
* from`*`
* bcc`*`
* reply\_to
* to`*`
* in\_reply\_to`*`
* date\_created
* references`*`
* body\_text\_quoted`*`
* need\_smtp\_credentials
* in\_reply\_to\_id
* updated\_by\_name
* old\_status\_label
* transferred\_from
* user\_id
* updated\_by
* cc`*`
* opportunity\_value
* task\_assigned\_to
* created\_by
* status
* email\_account\_id
* template\_id
* transferred\_to
* attachments`*`
* message\_ids`*`
* voicemail\_duration
* local\_phone
* body\_html\_quoted`*`
* opens`*`
* task\_id
* lead\_id
* task\_assigned\_to\_name
* body\_text
* thread\_id
* task\_text
* user\_name
* note
* source
* import\_id
* to`*`
* recording\_url
* date\_scheduled
* subject
* body\_preview
* created\_by\_name
* phone
* sender
* duration
* date\_sent
* \_type
* new\_status\_label
* opportunity\_value\_formatted
* opportunity\_id
* opens\_summary
* new\_status\_type
* remote\_phone
* new\_status\_id
* contact\_id
* body\_html
* opportunity\_date\_won
* opportunity\_value\_currency
* old\_status\_type
* bcc`*`
* organization\_id
* old\_status\_id
* opportunity\_confidence
* date\_updated
* template\_name
* opportunity\_value\_period
* voicemail\_url
* send\_attempts `*`
* direction