Hi,
I need to get the table from page in confluence and use it in Jupyter Notebook. I read the documentation https://developer.atlassian.com/server/confluence/confluence-rest-api-examples/ and tried using examples.
But when I run request
params = (('expand', 'body.storage'),)response = requests.get('https://wiki.tele2.ru/pages/rest/api/content/27691117', params=params, auth=('login', 'pass'))
I get empty response.
Can anyone help me?
Hi @Oleg Gonshtein
Welcome to the Atlassian Community
I'm not the best with Python coding, but I believe I can help you.
Since you are using the requests library, I'm assuming you already installed it using pip.
The below script should get you the page contents.
import requestscontentApiUrl = '/rest/api/content'# Change these based on your instanceconfluenceBaseUrl = 'http://localhost:6740/c740'pageId = '3309573'username = 'admin'password = 'admin'requestUrl = '{confluenceBaseUrl}{contentApiUrl}/{pageId}?expand=body.storage'.format(confluenceBaseUrl = confluenceBaseUrl, contentApiUrl = contentApiUrl, pageId = pageId)print requestUrlrequestResponse = requests.get(requestUrl, auth=(username, password))print requestResponse.json()
A search for other Community posts will certainly find some more elaborated Python scripts, such as in this post.
I hope that helps.
Kind regards,Thiago Masutti
You may use the atlassian-python-api module from https://atlassian-python-api.readthedocs.io/confluence.htmluse the confluence.get_page_by_id API (warning the html document has a typo for this API, it has no "self" parameter), make sure to set the expand parameter to "body.storage"
The API then returns d, a dictionary where the page view storage content is located in d['body']['storage']['value']
@Jerome Diard was close but not righthere is code that works for you, if you want get body of page in confluence by python.```
```
@Jerome Diard Thanks for pointing out the typo, was going crazy for a bit. : )
https://gist.github.com/quest4i/3b8b287e8158b63220550ecbcb98555f
covert confluece page to markdown
I don't have a direct confluence username and password, what would I need to do to do the same using my microsoft credentials
It looks like you're new here. Sign in or register to get started.
