Confluence
Connect your Confluence wiki to your data warehouse. Sync spaces, pages, blogposts, comments, labels, and tasks to BigQuery, Redshift, PostgreSQL, Databricks, and more.
Using the Erathos platform
When selecting Confluence as a new connector on the Erathos platform, you will need to name your connection and fill in the following form:
Site — your Confluence site subdomain (for example,
mycompanyif you access Confluence atmycompany.atlassian.net)Token — your Atlassian API token, validated together with your Atlassian account email to authenticate all requests to the Confluence API
With this connection created you can seamlessly move your Confluence data to your BigQuery, Redshift or PostgreSQL data warehouse.
How to find my token?
Confluence authenticates with Atlassian API tokens using Basic authentication. To generate one, go to https://id.atlassian.com/manage-profile/security/api-tokens and click Create API token. Give the token a label (for example, Erathos) and click Create — the token value is displayed only once, so copy it right away.
Make sure the Atlassian account you used to generate the token has access to the Confluence site you want to sync. The API token is validated together with your Atlassian account email, and both must belong to the account that can access your {site}.atlassian.net Confluence instance.
In the Erathos platform, fill in the Site field with your Confluence subdomain (for example, mycompany) and paste the API token into the Token field. Click Save and close to complete the setup.
Endpoints and fields
spaces
Sync type availability: Full-refresh
Parent of space_detail, space_labels, space_operations, space_permission_assignments, space_properties, space_role_assignments, spaces_blogposts, spaces_content_labels, spaces_pages
id
text
key
text
name
text
type
text
status
text
authorId
text
homepageId
text
description
json
icon
json
_links
json
space_detail
Sync type availability: Full-refresh
Child of spaces
id
text
key
text
name
text
type
text
status
text
authorId
text
homepageId
text
description
json
icon
json
_links
json
labels
json
properties
json
operations
json
permissions
json
roleAssignments
json
space_labels
Sync type availability: Full-refresh
Child of spaces
id
text
prefix
text
name
text
_links
json
space_operations
Sync type availability: Full-refresh
Child of spaces
operation
text
targetType
text
space_permission_assignments
Sync type availability: Full-refresh
Child of spaces
id
text
principal
json
type
text
space_properties
Sync type availability: Full-refresh
Child of spaces
id
text
key
text
value
json
version
json
_links
json
space_role_assignments
Sync type availability: Full-refresh
Child of spaces
id
text
principal
json
spaces_blogposts
Sync type availability: Full-refresh
Child of spaces
id
text
status
text
title
text
spaceId
text
authorId
text
ownerId
text
lastOwnerId
text
createdAt
timestamp
version
json
_links
json
spaces_content_labels
Sync type availability: Full-refresh
Child of spaces
id
text
prefix
text
name
text
_links
json
spaces_pages
Sync type availability: Full-refresh
Child of spaces
id
text
status
text
title
text
spaceId
text
parentId
text
parentType
text
position
text
authorId
text
ownerId
text
lastOwnerId
text
createdAt
timestamp
version
json
_links
json
pages
Sync type availability: Full-refresh
Parent of pages_attachments, pages_footer_comments, pages_inline_comments, pages_direct_children, pages_children, pages_ancestors, pages_descendants, page_labels, pages_versions, page_likes_count, page_likes_users, page_properties, page_operations, page_detail
id
text
status
text
title
text
spaceId
text
parentId
text
parentType
text
position
text
authorId
text
ownerId
text
lastOwnerId
text
createdAt
timestamp
version
json
_links
json
pages_attachments
Sync type availability: Full-refresh
Child of pages
id
text
status
text
title
text
pageId
text
blogPostId
text
customContentId
text
authorId
text
createdAt
timestamp
fileId
text
mediaType
text
mediaTypeDescription
text
fileSize
integer
comment
text
version
json
_links
json
pages_footer_comments
Sync type availability: Full-refresh
Child of pages
id
text
status
text
body
json
version
json
pageId
text
blogPostId
text
authorId
text
createdAt
timestamp
_links
json
pages_inline_comments
Sync type availability: Full-refresh
Child of pages
id
text
status
text
body
json
version
json
pageId
text
blogPostId
text
authorId
text
createdAt
timestamp
resolvedProperties
json
_links
json
pages_direct_children
Sync type availability: Full-refresh
Child of pages
id
text
status
text
title
text
spaceId
text
parentId
text
parentType
text
position
text
authorId
text
ownerId
text
lastOwnerId
text
createdAt
timestamp
version
json
_links
json
pages_children
Sync type availability: Full-refresh
Child of pages
id
text
status
text
title
text
spaceId
text
parentId
text
parentType
text
position
text
authorId
text
ownerId
text
lastOwnerId
text
createdAt
timestamp
version
json
_links
json
pages_ancestors
Sync type availability: Full-refresh
Child of pages
id
text
status
text
title
text
spaceId
text
parentId
text
parentType
text
position
text
authorId
text
ownerId
text
lastOwnerId
text
createdAt
timestamp
version
json
_links
json
pages_descendants
Sync type availability: Full-refresh
Child of pages
id
text
status
text
title
text
spaceId
text
parentId
text
parentType
text
position
text
authorId
text
ownerId
text
lastOwnerId
text
createdAt
timestamp
version
json
_links
json
page_labels
Sync type availability: Full-refresh
Child of pages
id
text
prefix
text
name
text
_links
json
pages_versions
Sync type availability: Full-refresh
Child of pages
number
integer
createdAt
timestamp
message
text
minorEdit
boolean
authorId
text
page_likes_count
Sync type availability: Full-refresh
Child of pages
likes
integer
likedBy
integer
page_likes_users
Sync type availability: Full-refresh
Child of pages
accountId
text
userType
text
accountStatus
text
text
publicName
text
profilePicture
json
page_properties
Sync type availability: Full-refresh
Child of pages
id
text
key
text
value
json
version
json
_links
json
page_operations
Sync type availability: Full-refresh
Child of pages
operation
text
targetType
text
page_detail
Sync type availability: Full-refresh
Child of pages
id
text
status
text
title
text
spaceId
text
parentId
text
parentType
text
position
text
authorId
text
ownerId
text
lastOwnerId
text
createdAt
timestamp
version
json
_links
json
body
json
labels
json
properties
json
operations
json
likes
json
versions
json
isFavoritedByCurrentUser
boolean
blogposts
Sync type availability: Full-refresh
Parent of blogposts_attachments, blogposts_footer_comments, blogposts_inline_comments, blogpost_labels, blogpost_versions, blogpost_likes_count, blogpost_likes_users, blogpost_properties, blogpost_operations, blogpost_detail
id
text
status
text
title
text
spaceId
text
authorId
text
ownerId
text
lastOwnerId
text
createdAt
timestamp
version
json
_links
json
blogposts_attachments
Sync type availability: Full-refresh
Child of blogposts
id
text
status
text
title
text
pageId
text
blogPostId
text
customContentId
text
authorId
text
createdAt
timestamp
fileId
text
mediaType
text
mediaTypeDescription
text
fileSize
integer
comment
text
version
json
_links
json
blogposts_footer_comments
Sync type availability: Full-refresh
Child of blogposts
id
text
status
text
body
json
version
json
pageId
text
blogPostId
text
authorId
text
createdAt
timestamp
_links
json
blogposts_inline_comments
Sync type availability: Full-refresh
Child of blogposts
id
text
status
text
body
json
version
json
pageId
text
blogPostId
text
authorId
text
createdAt
timestamp
resolvedProperties
json
_links
json
blogpost_labels
Sync type availability: Full-refresh
Child of blogposts
id
text
prefix
text
name
text
_links
json
blogpost_versions
Sync type availability: Full-refresh
Child of blogposts
number
integer
createdAt
timestamp
message
text
minorEdit
boolean
authorId
text
blogpost_likes_count
Sync type availability: Full-refresh
Child of blogposts
likes
integer
likedBy
integer
blogpost_likes_users
Sync type availability: Full-refresh
Child of blogposts
accountId
text
userType
text
accountStatus
text
text
publicName
text
profilePicture
json
blogpost_properties
Sync type availability: Full-refresh
Child of blogposts
id
text
key
text
value
json
version
json
_links
json
blogpost_operations
Sync type availability: Full-refresh
Child of blogposts
operation
text
targetType
text
blogpost_detail
Sync type availability: Full-refresh
Child of blogposts
id
text
status
text
title
text
spaceId
text
authorId
text
ownerId
text
lastOwnerId
text
createdAt
timestamp
version
json
_links
json
body
json
labels
json
properties
json
operations
json
likes
json
versions
json
isFavoritedByCurrentUser
boolean
attachments
Sync type availability: Full-refresh
Parent of attachments_labels, attachment_versions, attachments_footer_comments, attachment_properties, attachment_operations, attachment_detail
id
text
status
text
title
text
pageId
text
blogPostId
text
customContentId
text
authorId
text
createdAt
timestamp
fileId
text
mediaType
text
mediaTypeDescription
text
fileSize
integer
comment
text
version
json
_links
json
attachments_labels
Sync type availability: Full-refresh
Child of attachments
id
text
prefix
text
name
text
_links
json
attachment_versions
Sync type availability: Full-refresh
Child of attachments
number
integer
createdAt
timestamp
message
text
minorEdit
boolean
authorId
text
attachments_footer_comments
Sync type availability: Full-refresh
Child of attachments
id
text
status
text
body
json
version
json
pageId
text
blogPostId
text
authorId
text
createdAt
timestamp
_links
json
attachment_properties
Sync type availability: Full-refresh
Child of attachments
id
text
key
text
value
json
version
json
_links
json
attachment_operations
Sync type availability: Full-refresh
Child of attachments
operation
text
targetType
text
attachment_detail
Sync type availability: Full-refresh
Child of attachments
id
text
status
text
title
text
pageId
text
blogPostId
text
customContentId
text
authorId
text
createdAt
timestamp
fileId
text
mediaType
text
mediaTypeDescription
text
fileSize
integer
comment
text
version
json
_links
json
labels
json
properties
json
operations
json
versions
json
collaborators
json
labels
Sync type availability: Full-refresh
Parent of label_pages, label_blogposts, label_attachments
id
text
prefix
text
name
text
_links
json
label_pages
Sync type availability: Full-refresh
Child of labels
id
text
status
text
title
text
spaceId
text
parentId
text
parentType
text
position
text
authorId
text
ownerId
text
lastOwnerId
text
createdAt
timestamp
version
json
_links
json
label_blogposts
Sync type availability: Full-refresh
Child of labels
id
text
status
text
title
text
spaceId
text
authorId
text
ownerId
text
lastOwnerId
text
createdAt
timestamp
version
json
_links
json
label_attachments
Sync type availability: Full-refresh
Child of labels
id
text
status
text
title
text
pageId
text
blogPostId
text
customContentId
text
authorId
text
createdAt
timestamp
fileId
text
mediaType
text
mediaTypeDescription
text
fileSize
integer
comment
text
version
json
_links
json
footer_comments
Sync type availability: Full-refresh
Parent of footer_comment_children, footer_comment_likes_users, footer_comment_likes_count, footer_comment_versions, footer_comment_operations
id
text
status
text
body
json
version
json
pageId
text
blogPostId
text
authorId
text
createdAt
timestamp
_links
json
footer_comment_children
Sync type availability: Full-refresh
Child of footer_comments
id
text
status
text
body
json
version
json
pageId
text
blogPostId
text
authorId
text
createdAt
timestamp
_links
json
footer_comment_likes_users
Sync type availability: Full-refresh
Child of footer_comments
accountId
text
userType
text
accountStatus
text
text
publicName
text
profilePicture
json
footer_comment_likes_count
Sync type availability: Full-refresh
Child of footer_comments
likes
integer
likedBy
integer
footer_comment_versions
Sync type availability: Full-refresh
Child of footer_comments
number
integer
createdAt
timestamp
message
text
minorEdit
boolean
authorId
text
footer_comment_operations
Sync type availability: Full-refresh
Child of footer_comments
operation
text
targetType
text
inline_comments
Sync type availability: Full-refresh
Parent of inline_comment_children, inline_comment_likes_users, inline_comment_likes_count, inline_comment_versions, inline_comment_operations
id
text
status
text
body
json
version
json
pageId
text
blogPostId
text
authorId
text
createdAt
timestamp
resolvedProperties
json
_links
json
inline_comment_children
Sync type availability: Full-refresh
Child of inline_comments
id
text
status
text
body
json
version
json
pageId
text
blogPostId
text
authorId
text
createdAt
timestamp
resolvedProperties
json
_links
json
inline_comment_likes_users
Sync type availability: Full-refresh
Child of inline_comments
accountId
text
userType
text
accountStatus
text
text
publicName
text
profilePicture
json
inline_comment_likes_count
Sync type availability: Full-refresh
Child of inline_comments
likes
integer
likedBy
integer
inline_comment_versions
Sync type availability: Full-refresh
Child of inline_comments
number
integer
createdAt
timestamp
message
text
minorEdit
boolean
authorId
text
inline_comment_operations
Sync type availability: Full-refresh
Child of inline_comments
operation
text
targetType
text
classification_levels
Sync type availability: Full-refresh
id
text
name
text
description
text
space_permissions
Sync type availability: Full-refresh
id
text
principal
json
type
text
space_roles
Sync type availability: Full-refresh
id
text
key
text
name
text
permissions
json
tasks
Sync type availability: Full and incremental refresh
Cursor: createdAt
id
text
status
text
body
json
pageId
text
blogPostId
text
inlineCommentId
text
authorId
text
assigneeId
text
createdAt
timestamp
✓
dueAt
timestamp
completedAt
timestamp
associatedWithId
text
_links
json
Entity Relationships
Last updated

