python 3.x - is it possible to save dataframe to atlassian page using api?

Question

How to save pandas dataframe directly to Atlassian confluence page using API in python? I used atlassian-python-api library. but didn't get any solution.

question from:https://stackoverflow.com/questions/65892299/is-it-possible-to-save-dataframe-to-atlassian-page-using-api

Answer 1

In the future, please review how to ask questions that are MCVE so that others can help you more easily.

If you are using the altassian python api, you should be able to do this relatively easily

from the documentation for the confluence module, running the confluence.create_page command will create a page in your given workspace.

confluence.create_page(space, title, body, parent_id=None, type='page', representation='storage', editor='v2')

In your case, if you want to create the pandas dataframe as a table in confluence, you should use the DataFrmae.to_markdown command introduced in pandas version 1.0.0.

From the docs, the command will generate markdown which you can see below.

s = pd.Series(["elk", "pig", "dog", "quetzal"], name="animal")
print(s.to_markdown())


|    | animal   |
|---:|:---------|
|  0 | elk      |
|  1 | pig      |
|  2 | dog      |
|  3 | quetzal  |

Which will yield markdown as such.

	animal
0	elk
1	pig
2	dog
3	quetzal