import os
from atlassian import Confluence
import pandas as pd
confluence = Confluence(
url=URL,
username=os.environ["CONFLUENCE_USERNAME"],
password=os.environ["CONFLUENCE_TOKEN"],
cloud=True
)
space = "SPACE"
page_title = "testpage"
page = confluence.get_page_by_title(space=space, title=page_title)
page_id = page["id"]
page_content = confluence.get_page_by_id(page_id, expand="body.storage")["body"]["storage"]["value"]
header = "Insert my table here"
start_header_index = page_content.find(header)
insert_index = start_header_index + len(header) + 5 # 5 is for '</hX>'
df = pd.DataFrame({"col1": [1, 2], "col2": ["a", "b"]})
table_html = df.to_html(index=False)
top_page_content = page_content[:insert_index]
bottom_page_content = page_content[insert_index:]
new_page_content = top_page_content + table_html + bottom_page_content
confluence.update_page(page_id=page_id, title=title, body=new_page_content)
confluence.get_page_by_id(page_id=page_id)
orig_body = confluence.get_page_by_id(page_id, expand="body.storage")["body"]["storage"]["value"]
confluence.get_page_property(page_id=page_id, page_property_key="content-appearance-published")
confluence.get_page_properties(page_id=page_id)