Hi, how to extract data from confluence space

[Emmie M]

In our project we have a confluence space with tabular data. Is there a way to extract this data to a sql server ?

Thanks
Emmie

[Nic Brough -Adaptavist- · Accepted solution]

There's no export or extract, you'll need to write something that can scrape the page, find the data you want and read it out of the content.

[Emmie M]

Thanks for the answer 

[Brahm Bothma]

This is related:

Get the contents of table in a confluence page using REST API

https://community.atlassian.com/t5/Answers-Developer-Questions/Get-the-contents-of-table-in-a-confluence-page-using-REST-API/qaq-p/479798#U845811

with some good code at:

Confluence REST API examples

https://developer.atlassian.com/server/confluence/confluence-rest-api-examples/

[Peter Schroeder]

Hey Emmie, 

By integrating directly with Confluence’s API, Onna collects all data and metadata from an entire Confluence site or individual spaces in their native format. 

If you're looking to extract Confluence data, Onna makes it easy. 

- Peter