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?
You may use the atlassian-python-api module from https://atlassian-python-api.readthedocs.io/confluence.html
use 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']
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@Jerome Diard was close but not right
here is code that works for you, if you want get body of page in confluence by python.
```
```
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I don't have a direct confluence username and password, what would I need to do to do the same using my microsoft credentials
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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 requests
contentApiUrl = '/rest/api/content'
# Change these based on your instance
confluenceBaseUrl = '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 requestUrl
requestResponse = 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 must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.