Editing macro at the page through ScriptRunner for Confluence

[zaharovvv_suek_ru]

I have a confluence page. 

Is it possible:
1. Find macro on the page which has name `Page properties`
2. Is it possible to update fields of macro `Page Properties` such as `Тип`, `Код`, `Модуль` programmatically through Confluence API?
3. Is it possible to delete field such as `Ссылка` programmatically through Confluence API?

I've attached an image to the message to clarify what I want.
Is it possible to do?

[Sven Schatter _Lively Apps_ · Accepted solution]

Hi @zaharovvv_suek_ru,

yes, this is possible! It just requires quite a bit of programming on your side. In fact, our Confluence app Diary actually makes use of this exact mechanism. Except, it doesn't use the Page Properties table, but a table inside it's own macro body. However, if you think it helps you, you can go have a look at how we did it. :)

Basically, you first want to get the Storage Format of your page via the Confluence REST API. You can then parse the XHTML, change the <table> in the Page Properties Macro however you want, and save the manipulated Storage Format again, using another Confluence REST API endpoint.

I've also already answered a very similar question to this over at the Developer Community - might also be worth checking out.

Best regards,
Sven