How to update a page with Python using REST API?

weegreenblobbie

I would like to write content to an existing page using the REST API, here's my current script:

 

#!/usr/bin/python
#
# Reference: http://isbullsh.it/2012/06/Rest-api-in-python/
#

import sys
import getpass

import json
import requests

BASE_URL = "http://confluence.XXXXXX.com/rest/api/content"

PAGEID = 9470040

def main():

    username = raw_input('login: ')
    passwd = getpass.getpass()

    url = "{base}/{pageid}".format(
        base = BASE_URL, pageid = PAGEID)

    data = json.dumps(
    {
        'id' : '%d' % PAGEID,
        'type' : 'page',
        'title' : 'Sandbox',
        'space' : {'key' : 'HSWc'},
        'body' :
        {
            'storage' :
            {
                'representation' : 'storage',
                'value' : """
<table>
    <tbody>
        <tr>
            <th>Hello</th>
            <th>World</th>
        </tr>
        <tr>
            <td>Nick</td>
            <td>Rocks!</td>
        </tr>
    </tbody>
</table>
"""
            }
        }
    })

    r = requests.put(
        url,
        data = data,
        auth = (username, passwd),
        headers = {
            'Content-Type' : 'application/json',
            'Accept' : 'application/json'
            }
    )

    r.raise_for_status()


if __name__ == "__main__" : main()

But I'm getting "requests.exceptions.HTTPError: 400 Client Error: Bad Request"

There currently isn't any working documentation for using the REST API.  Please help!

weegreenblobbie

I've now got a working example.  The documentation does not specify all the required fields to make this work, but it does state that the next version number must be specified.

So root cause to my failure was not explicitly specifying the next version number.

After I corrected that, the newly modified page was orphaned (https://jira.atlassian.com/browse/CRA-487).  But as sash pointed out, I found the same workaround.  Below is my complete working example:

$ python write_page.py -h
usage: write_page.py [-h] [-u USER] [-t TITLE] [-f FILE] pageid [html]
positional arguments:
  pageid                Specify the Conflunce page id to overwrite
  html                  Write the immediate html string to confluence page
optional arguments:
  -h, --help            show this help message and exit
  -u USER, --user USER  Specify the username to log into Confluence
  -t TITLE, --title TITLE
                        Specify a new title
  -f FILE, --file FILE  Write the contents of FILE to the confluence page

import argparse
import getpass
import sys

import json
import keyring
import requests

#-----------------------------------------------------------------------------
# Globals

BASE_URL = "http://confluence.XXXXX.com/rest/api/content"

VIEW_URL = "http://confluence.XXXXX.com/pages/viewpage.action?pageId="


def pprint(data):
    '''
    Pretty prints json data.
    '''
    print json.dumps(
        data,
        sort_keys = True,
        indent = 4,
        separators = (', ', ' : '))


def get_page_ancestors(auth, pageid):

    # Get basic page information plus the ancestors property

    url = '{base}/{pageid}?expand=ancestors'.format(
        base = BASE_URL,
        pageid = pageid)

    r = requests.get(url, auth = auth)

    r.raise_for_status()

    return r.json()['ancestors']


def get_page_info(auth, pageid):

    url = '{base}/{pageid}'.format(
        base = BASE_URL,
        pageid = pageid)

    r = requests.get(url, auth = auth)

    r.raise_for_status()

    return r.json()


def write_data(auth, html, pageid, title = None):

    info = get_page_info(auth, pageid)

    ver = int(info['version']['number']) + 1

    ancestors = get_page_ancestors(auth, pageid)

    anc = ancestors[-1]
    del anc['_links']
    del anc['_expandable']
    del anc['extensions']

    if title is not None:
        info['title'] = title

    data = {
        'id' : str(pageid),
        'type' : 'page',
        'title' : info['title'],
        'version' : {'number' : ver},
        'ancestors' : [anc],
        'body'  : {
            'storage' :
            {
                'representation' : 'storage',
                'value' : str(html),
            }
        }
    }

    data = json.dumps(data)

    url = '{base}/{pageid}'.format(base = BASE_URL, pageid = pageid)

    r = requests.put(
        url,
        data = data,
        auth = auth,
        headers = { 'Content-Type' : 'application/json' }
    )

    r.raise_for_status()

    print "Wrote '%s' version %d" % (info['title'], ver)
    print "URL: %s%d" % (VIEW_URL, pageid)


def get_login(username = None):
    '''
    Get the password for username out of the keyring.
    '''

    if username is None:
        username = getpass.getuser()

    passwd = keyring.get_password('confluence_script', username)

    if passwd is None:
        passwd = getpass.getpass()
        keyring.set_password('confluence_script', username, passwd)

    return (username, passwd)


def main():

    parser = argparse.ArgumentParser()

    parser.add_argument(
        "-u",
        "--user",
        default = getpass.getuser(),
        help = "Specify the username to log into Confluence")

    parser.add_argument(
        "-t",
        "--title",
        default = None,
        type = str,
        help = "Specify a new title")

    parser.add_argument(
        "-f",
        "--file",
        default = None,
        type = str,
        help = "Write the contents of FILE to the confluence page")

    parser.add_argument(
        "pageid",
        type = int,
        help = "Specify the Conflunce page id to overwrite")

    parser.add_argument(
        "html",
        type = str,
        default = None,
        nargs = '?',
        help = "Write the immediate html string to confluence page")

    options = parser.parse_args()

    auth = get_login(options.user)

    if options.html is not None and options.file is not None:
        raise RuntimeError(
            "Can't specify both a file and immediate html to write to page!")

    if options.html:
        html = options.html

    else:

        with open(options.file, 'r') as fd:
            html = fd.read()

    write_data(auth, html, options.pageid, options.title)


if __name__ == "__main__" : main()