CONTACTLISTS
- Last Updated: March 4, 2020
- 1 minute read
- DataDirect Connectors
- ODBC
- HubSpot 8.0
- Documentation
Endpoint
https://api.hubapi.com/contacts/v1/lists
Columns
The CONTACTLISTS table contains the following columns. Columns marked with an asterisk comprise the primary key.
| Column Name | Data Type |
|---|---|
| PORTALID* | Integer |
| CREATEDAT | Timestamp(3) |
| FILTERSAGGREGATE | JSON(16777215) |
| INTERNALLISTID | Integer |
| ISDYNAMIC | Boolean |
| LASTPROCESSINGSTATECHANGEAT | Timestamp(3) |
| LASTSIZECHANGEAT | Timestamp(3) |
| LISTID | Integer |
| LISTSIZE | Integer |
| NAME | VarChar(64) |
| PROCESSINGSTATE | VarChar(64) |
| UPDATEDAT | Timestamp(3) |