Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,293,343
Community Members
 
Community Events
165
Community Groups

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

How can I get the contents of a table in a confluence page using REST API? 

I was able to get the content of the page. But I just want the contents of the table as a list. Any pointers will be appreciated.

5 answers

Yea there is no direct way to get just the table. You have to get all the content and then parse it yourself to get only the table. I am not sure what programming language you are using for this but for python one good library for this is called BeautifulSoup (https://www.crummy.com/software/BeautifulSoup/bs4/doc/).

There are similar libraries like this for other languages so I would look for one in your language and use it to parse the content. 

This relates to the following Confluence Server Page:

Confluence REST API examples

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

This page contains examples of using the Confluence Content REST API using curl. The responses are piped into python -mjson.tool (JSON encoder / decoder) to make them easier to read.

The question was to get contents from a confluence table. This macro is about scraping a webpage URL, get contents and display in Confluence table.

Hows it related?

Hi,

can any of you provide details about how to scrape table contents from table in confluence page by using rest api & then python script?

you found anything , stucked in same problem.

@Mohan , @Nipun Goel,

For parsing tables I used the following Stack Overflow answer, specifically the response by schmijos.

Use this in tandem with a requests.get for the URL you want from confluence, and make sure to add the following at the end of the URL

?expand=body.view

 

hey @George Ivanov

I have a page that has similar url as yours  https://v-and-b.atlassian.net/wiki/spaces/PD/pages/1127186433/Table+Scraper+from+URL+Macro, do you know what would be the url, if I want to extract content from that page? I often see people have urls that contain "rest/api/content" which I don't have. Thanks

How did you get the content of the page using REST API? Did it contain table values?

The REST API (which you can find on google) includes all page content in XML format. Of course it includes a normal html table, yes.

https://<domain>/rest/api/content/12345?expand=body.storage

This format can be used to get the contents of the confluence page. 

Like Nick Spreitzer likes this

Your best bet is to grab the storage format and parse the returned XML for your table.

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Confluence

Confluence: Where work and wellness meet

Feeling overwhelmed by the demands of work and life? With a 25% increase in the prevalence of anxiety and depression worldwide during the pandemic, for most of us, it’s a resounding yes . 🙋‍♀️ ...

733 views 5 21
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you