I wrote the code to put data into existing confluence page. My code is like below.I'm using Python here
import requests
import json
url = 'https://domain.atlassian.net/wiki/rest/api/content/pageid'
headers ={
'Accept':'application/json',
'Authorization': 'basic <access token>',
'content_type':'application/json'}
payload = json.dumps({
'version':{
number:version number},
'title':'title of existing page',
'type':'page',
'status':'current',
'body':{
'storage':{
'value':'''
<tbody><tr><th><p><strong>header1</strong></p></th><th><p><strong>header2</strong></p></th>
<th><p><strong>header3</strong></p></th><th><p><strong>header4</strong></p></th>
<th><p><strong>Remarks</strong></p></th></tr><tr><td><p>DRLT</p></td><td><p>Drogas Lithuania</p></td>
<td><p>i want to update data here from csv file</p></td>
<td><p>csv data</p></td>
<td><p></p></td></tr><tr><td><p>branch</p></td><td><p>csv data</p></td>
<td><p>csv data</p></td>
<td><p>csv data</p></td>
html code of confluence page. It has 5 tables.'''
'representation':'storage'}}})
response = requests.request(
"put"
url,
data = payload
headers = headers)
print(json.dumps(json.loads(response.text),sort_keys= True, indent = 4,separoters=(",",":")
I'm new to this confluence I have no idea how to update data into confluence tables using rest apis. I every time changing data in html code and put into confluence page.
I want to update data into 3 tables in html code from csv file automatically
like every time run script it'll read csv data and change html table contents itself.
How can i achieve that?
Please help me through this..........
