Skip to content
For the complete documentation index, see llms.txt. This page is also available as Markdown.

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, mycompany if you access Confluence at mycompany.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

Field
Type

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

Field
Type

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

Field
Type

id

text

prefix

text

name

text

_links

json

space_operations

Sync type availability: Full-refresh

Child of spaces

Field
Type

operation

text

targetType

text

space_permission_assignments

Sync type availability: Full-refresh

Child of spaces

Field
Type

id

text

principal

json

type

text

space_properties

Sync type availability: Full-refresh

Child of spaces

Field
Type

id

text

key

text

value

json

version

json

_links

json

space_role_assignments

Sync type availability: Full-refresh

Child of spaces

Field
Type

id

text

principal

json

spaces_blogposts

Sync type availability: Full-refresh

Child of spaces

Field
Type

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

Field
Type

id

text

prefix

text

name

text

_links

json

spaces_pages

Sync type availability: Full-refresh

Child of spaces

Field
Type

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

Field
Type

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

Field
Type

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

Sync type availability: Full-refresh

Child of pages

Field
Type

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

Field
Type

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

Field
Type

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

Field
Type

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

Field
Type

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

Field
Type

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

Field
Type

id

text

prefix

text

name

text

_links

json

pages_versions

Sync type availability: Full-refresh

Child of pages

Field
Type

number

integer

createdAt

timestamp

message

text

minorEdit

boolean

authorId

text

page_likes_count

Sync type availability: Full-refresh

Child of pages

Field
Type

likes

integer

likedBy

integer

page_likes_users

Sync type availability: Full-refresh

Child of pages

Field
Type

accountId

text

userType

text

accountStatus

text

email

text

publicName

text

profilePicture

json

page_properties

Sync type availability: Full-refresh

Child of pages

Field
Type

id

text

key

text

value

json

version

json

_links

json

page_operations

Sync type availability: Full-refresh

Child of pages

Field
Type

operation

text

targetType

text

page_detail

Sync type availability: Full-refresh

Child of pages

Field
Type

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

Field
Type

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

Field
Type

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

Sync type availability: Full-refresh

Child of blogposts

Field
Type

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

Field
Type

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

Field
Type

id

text

prefix

text

name

text

_links

json

blogpost_versions

Sync type availability: Full-refresh

Child of blogposts

Field
Type

number

integer

createdAt

timestamp

message

text

minorEdit

boolean

authorId

text

blogpost_likes_count

Sync type availability: Full-refresh

Child of blogposts

Field
Type

likes

integer

likedBy

integer

blogpost_likes_users

Sync type availability: Full-refresh

Child of blogposts

Field
Type

accountId

text

userType

text

accountStatus

text

email

text

publicName

text

profilePicture

json

blogpost_properties

Sync type availability: Full-refresh

Child of blogposts

Field
Type

id

text

key

text

value

json

version

json

_links

json

blogpost_operations

Sync type availability: Full-refresh

Child of blogposts

Field
Type

operation

text

targetType

text

blogpost_detail

Sync type availability: Full-refresh

Child of blogposts

Field
Type

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

Field
Type

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

Field
Type

id

text

prefix

text

name

text

_links

json

attachment_versions

Sync type availability: Full-refresh

Child of attachments

Field
Type

number

integer

createdAt

timestamp

message

text

minorEdit

boolean

authorId

text

Sync type availability: Full-refresh

Child of attachments

Field
Type

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

Field
Type

id

text

key

text

value

json

version

json

_links

json

attachment_operations

Sync type availability: Full-refresh

Child of attachments

Field
Type

operation

text

targetType

text

attachment_detail

Sync type availability: Full-refresh

Child of attachments

Field
Type

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

Field
Type

id

text

prefix

text

name

text

_links

json

label_pages

Sync type availability: Full-refresh

Child of labels

Field
Type

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

Field
Type

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

Field
Type

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

Sync type availability: Full-refresh

Parent of footer_comment_children, footer_comment_likes_users, footer_comment_likes_count, footer_comment_versions, footer_comment_operations

Field
Type

id

text

status

text

body

json

version

json

pageId

text

blogPostId

text

authorId

text

createdAt

timestamp

_links

json

Sync type availability: Full-refresh

Child of footer_comments

Field
Type

id

text

status

text

body

json

version

json

pageId

text

blogPostId

text

authorId

text

createdAt

timestamp

_links

json

Sync type availability: Full-refresh

Child of footer_comments

Field
Type

accountId

text

userType

text

accountStatus

text

email

text

publicName

text

profilePicture

json

Sync type availability: Full-refresh

Child of footer_comments

Field
Type

likes

integer

likedBy

integer

Sync type availability: Full-refresh

Child of footer_comments

Field
Type

number

integer

createdAt

timestamp

message

text

minorEdit

boolean

authorId

text

Sync type availability: Full-refresh

Child of footer_comments

Field
Type

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

Field
Type

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

Field
Type

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

Field
Type

accountId

text

userType

text

accountStatus

text

email

text

publicName

text

profilePicture

json

inline_comment_likes_count

Sync type availability: Full-refresh

Child of inline_comments

Field
Type

likes

integer

likedBy

integer

inline_comment_versions

Sync type availability: Full-refresh

Child of inline_comments

Field
Type

number

integer

createdAt

timestamp

message

text

minorEdit

boolean

authorId

text

inline_comment_operations

Sync type availability: Full-refresh

Child of inline_comments

Field
Type

operation

text

targetType

text

classification_levels

Sync type availability: Full-refresh

Field
Type

id

text

name

text

description

text

space_permissions

Sync type availability: Full-refresh

Field
Type

id

text

principal

json

type

text

space_roles

Sync type availability: Full-refresh

Field
Type

id

text

key

text

name

text

permissions

json

tasks

Sync type availability: Full and incremental refresh

Cursor: createdAt

Field
Type
Cursor

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