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

[Aswini Vayyala]

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.

[Alex Yasurek]

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. 

[Brahm Bothma]

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.

[George Ivanov]

Hi All,

you can use the following macro: https://v-and-b.atlassian.net/wiki/spaces/PD/pages/1127186433/Table+Scraper+from+URL+Macro

Here are step-by-step instructions: https://v-and-b.atlassian.net/wiki/spaces/PD/blog/2020/05/26/1142554679/How+to+Display+a+HTML+Table+from+a+URL+as+a+Confluence+Table

[ravikanth mogulla]

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?

[Mohan]

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?

[Nipun Goel]

you found anything , stucked in same problem.

[Pierre Ibrahim]

@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

[George Ivanov]

Hi, you can use the following macro: https://v-and-b.atlassian.net/wiki/spaces/PD/pages/1127186433/Table+Scraper+from+URL+Macro

[Wenchang Zhou]

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

[Rupa Jain]

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

[Steven F Behnke]

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.

[nishanth.shenoy]

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

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

[Steven F Behnke]

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