How to automatically import data from external JSON to Confluence page

[V-Key Support]

hi everyone,

I trying to figure out if there is a way to import set of data from an external site into confluence page with JSON format.

The tricky part is also schedule to have the page run periodically (exp. once a month) to retrieve any update data (calling to the same URL)

Is there an available add-on could do the trick?

thank you for your help

[Stephen Sifers]

Hello,

Since the source you’re wanting to import into Confluence would already be JSON, you can ideally use a script to scrub your website and store the JSON as a variable. Once you have the JSON stored, you can then use the Confluence REST API to then add the JSON data into a Confluence page as the content of a page.

You may find more about the REST API within the documentation for Creating Content with the REST API. Along with REST API Examples.

You may find a marketplace add-on available within the Atlassian Marketplace. This option would have an additional cost while the REST API is already included and available within Confluence.

I hope this give you an additional option to marketplace add-ons along with increasing your functionality within Confluence.

Regards,
Stephen Sifers

[V-Key Support]

Thank you Stephen, we are currently testing with Script Runner to fetch data automatically.