get_page_by_id(page_id, expand='body.storage') returns string, instead of a dictionary

[Rajesh Vr]

confluence = Confluence(url=conf_site, username=conf_user, password=conf_passwd)

pg = confluence.get_page_by_id(page_id, expand='body.storage')
pg_content = pg['body']

pg_content = pg['body'] throws error as:
page_content = page['body']
TypeError: string indices must be integers


Can you please help me to fix this issue?

[Peter Van de Voorde]

Hi @Rajesh Vr 

Welcome to the Atlassian Community.

Can you please try

pg_content = pg.body instead of pg_content = pg['body']


Cheers,
Peter

[Rajesh Vr]

I tried with: 

pg.body, but got the following error:

AttributeError: 'str' object has no attribute 'body'

[Peter Van de Voorde]

Ok, 

So basically pg is your body content in json format then already.
Can you try using the json python library like explained here: https://www.w3schools.com/python/python_json.asp 

To turn this string into a dictionary?

Cheers,
Peter

[Rajesh Vr]

I tried the json, but with no luck :-(

p = json.loads(page) itself throws json Decode error.

Then I directly used: table = pandas.read_html(page) which throws error: 
raise ValueError("No tables found")
ValueError: No tables found

My goal is to read a table from confluence page and update. 

[Rajesh Vr]

Could anyone please share example code snippet for reading and updating Confluence page tables using python/or any other methods?

[Peter Van de Voorde]

Hey @Rajesh Vr ,

Just asking for the full code isn't really going to help you learn and expand your Python and Confluence knowledge. It's not how we do things in the community. We focus on supporting people with their learning efforts.

So take a look at these links for inspiration on how to potentially solve your problem:

• https://community.atlassian.com/t5/Confluence-questions/Update-Confluence-Table-Inside-Table-Excerpt-Using-Python/qaq-p/1710626
• https://community.atlassian.com/t5/Confluence-questions/Update-Confluence-page-with-Python-using-REST-API/qaq-p/1086666
• https://community.atlassian.com/t5/Confluence-questions/Update-confluence-page-using-rest-API/qaq-p/1821275
• https://developer.atlassian.com/server/confluence/confluence-rest-api-examples/
• https://www.c-sharpcorner.com/blogs/using-python-apis-to-create-and-update-confluence-page

I hope they help.

Cheers,
Peter

[Rajesh Vr]

hello @Peter Van de Voorde ,

I had already referred the first link in your list, and researched a few more similar sites, but without success.

Let me now try using REST APIs directly after referring other links in your list. I will update here in case I have something to share. 

cheers,

-Rajesh