0
# Additional Streams
1

2
Additional HubSpot data streams covering forms, ownership, and supplementary functionality not covered in the main CRM, engagement, or marketing stream categories.
3

4
## Capabilities
5

6
### Form Submissions Stream
7

8
Form submission records capturing lead generation data and form interaction history.
9

10
```yaml { .api }
11
form_submissions:
12
  primary_key: ["id"]
13
  cursor_field: "submittedAt"
14
  sync_mode: incremental
15
  schema:
16
    type: object
17
    properties:
18
      id:
19
        type: string
20
        description: "Unique form submission identifier"
21
      formId:
22
        type: string
23
        description: "Associated form identifier"
24
      contactId:
25
        type: string
26
        description: "Contact who submitted the form"
27
      submittedAt:
28
        type: string
29
        format: date-time
30
        description: "Form submission timestamp"
31
      values:
32
        type: array
33
        items:
34
          type: object
35
          properties:
36
            name:
37
              type: string
38
              description: "Form field name"
39
            value:
40
              type: string
41
              description: "Submitted field value"
42
        description: "Form field values"
43
      pageUrl:
44
        type: string
45
        description: "URL of page where form was submitted"
46
      ipAddress:
47
        type: string
48
        description: "IP address of submitter"
49
```
50

51
**Usage Example:**
52

53
```yaml
54
source:
55
  type: airbyte/source-hubspot
56
  config:
57
    credentials:
58
      credentials_title: "Private App Credentials"
59
      access_token: "${HUBSPOT_ACCESS_TOKEN}"
60
    start_date: "2023-01-01T00:00:00Z"
61

62
destination:
63
  type: airbyte/destination-postgres
64
  config:
65
    streams:
66
      - stream_name: form_submissions
67
        sync_mode: incremental
68
```
69

70
### Owners Archived Stream
71

72
Archived owner records for users who are no longer active in the HubSpot account.
73

74
```yaml { .api }
75
owners_archived:
76
  primary_key: ["id"]
77
  cursor_field: "updatedAt"
78
  sync_mode: incremental
79
  schema:
80
    type: object
81
    properties:
82
      id:
83
        type: string
84
        description: "Unique owner identifier"
85
      userId:
86
        type: string
87
        description: "Associated user ID"
88
      email:
89
        type: string
90
        format: email
91
        description: "Owner email address"
92
      firstName:
93
        type: string
94
        description: "Owner first name"
95
      lastName:
96
        type: string
97
        description: "Owner last name"
98
      active:
99
        type: boolean
100
        const: false
101
        description: "Always false for archived owners"
102
      userIdIncludingInactive:
103
        type: string
104
        description: "User ID including inactive status"
105
      createdAt:
106
        type: string
107
        format: date-time
108
        description: "Owner creation timestamp"
109
      updatedAt:
110
        type: string
111
        format: date-time
112
        description: "Last update timestamp"
113
```
114

115
### Ticket Pipelines Stream
116

117
Ticket pipeline configuration for support ticket workflow management.
118

119
```yaml { .api }
120
ticket_pipelines:
121
  primary_key: ["id"]
122
  cursor_field: "updatedAt"
123
  sync_mode: incremental
124
  schema:
125
    type: object
126
    properties:
127
      id:
128
        type: string
129
        description: "Unique pipeline identifier"
130
      label:
131
        type: string
132
        description: "Pipeline display name"
133
      displayOrder:
134
        type: integer
135
        description: "Pipeline sort order"
136
      active:
137
        type: boolean
138
        description: "Whether pipeline is active"
139
      stages:
140
        type: array
141
        items:
142
          type: object
143
          properties:
144
            id:
145
              type: string
146
              description: "Stage identifier"
147
            label:
148
              type: string
149
              description: "Stage display name"
150
            displayOrder:
151
              type: integer
152
              description: "Stage sort order"
153
            metadata:
154
              type: object
155
              properties:
156
                isClosed:
157
                  type: boolean
158
                  description: "Whether stage represents closed tickets"
159
        description: "Pipeline stages"
160
      createdAt:
161
        type: string
162
        format: date-time
163
        description: "Pipeline creation timestamp"
164
      updatedAt:
165
        type: string
166
        format: date-time
167
        description: "Last update timestamp"
168
```
169

170
## Data Retention and Archival
171

172
These streams follow HubSpot's data retention policies:
173

174
- **Form Submissions**: Retained indefinitely unless manually deleted
175
- **Owners Archived**: Retained for audit purposes; reactivation possible
176
- **Ticket Pipelines**: Configuration changes tracked with timestamp history
177

178
## Integration Notes
179

180
These streams complement the main CRM functionality:
181

182
- **Form Submissions** link to Contacts via `contactId`
183
- **Owners Archived** maintains referential integrity with CRM records
184
- **Ticket Pipelines** define workflow structure for Tickets stream
185

186
Use these streams for complete data lineage and workflow understanding.