Update Confluence page automatically

[Rajat Gupta]

Hi,

My script generates a csv file in format say:

project1,owner1,details1

project2,owner2,details2

How do I update a confluence page using rest api's commands with this data? Preferably, I would like to use a bob swift cvs table on my confluence page and update the cvs data using the rest api command.

Suggestions please.

Thanks

[Bob Swift · Accepted solution]

Unless you want to do the programming yourself, it would be much easier to use the Confluence Command Line Interface (CLI) to upload the file in wiki format. Especially easy if your CSV is in a file:

--action storePage --space XXX --title "My page" --content "{csv}" --file myFile.csv --content2 "{csv}"

The file content is included after content and before content2.

An alternative is to use addAttachment to add the file as an attachment and store the page with the wiki markup for the csv macro that accesses the csv from an attachment. 

Make sure your script is producing valid CSV as defined in the reference on CSV Macro.