Confluence integration

Dear colleagues,

We've started some PoC project to integrate Confluence with BMC Remedy software. More over I'm a new in concept of integration Confluence at all.

I've read materials from your resources and found that the best way to integrate is using SOAP API web service to create a new article in Confluence. The other part of integration is a most defference. This is a database integration. Out Confluence installation is based upon PostgreSQL. I've connected my Remedy database and Confluence Database by creation of a new view in MS SQL Management Studio. So during my development I need to find a practice table through confluence database wich can join such type of items (The name of article, The description of article, The Create_Date of article, the article_owner, The web-page of Article).

 

Well I'll be appreciate if you help me witm my questions.

  1. How to create a new article in Confluence by SOAP web service ?
  2. Need more technical information about database structure and a table wich include columns described above

Thanks,

 

3 answers

1 vote

The best way to do this is to use the REST API, not SOAP (as it is deprecated and will eventually be removed) and certainly never the database - you can not write to a Confluence database while the application is running, and it's a good idea not to read it either, as you need to understand the structure, and that changes with upgrades, whereas the APIs tend not to.

To get started with the REST API, have a look at https://developer.atlassian.com/confdev/confluence-rest-api  - it will also let you do the reads that you probably want.

Nic, thanks for your reply. The problem is that BMC dont support REST API only SOAP.

But I'll ready to test REST also perhaps I can get some integration anyway.

Well I'm checking REST API calls and have some wrong outputs. Could you please find out what exactly wrong with my request ?

This is for GET opertaion:

http://IPMYSERVER/confluence/rest/api/content/?type=page&title=БЗ&expand=space,body.view,version,container

I'm waitind to get detail desription of my article but get :

<Response xmlns="http://IPMYSERVER/rest/api/content">
   <_links>
      <base>https://MYSERVER/confluence</base>
      <context>/confluence</context>
      <self>http://IPMYSERVER/confluence/rest/api/content</self>
   </_links>
   <limit>20</limit>
   <results/>
   <size>0</size>
   <start>0</start>
</Response>

I need detail list if my article. Am I wrong with my request ?

Could you please to get me some example how to create a new content by POST operation ?

Its better for me to use such kind of request with POST operation:

http://example.com/rest/api/content?type=blogpost&spaceKey=TST&title=Bacon&postingDay=2014-02-13&expand=space,body.view,version,container

Suggest an answer

Log in or Sign up to answer
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Kesha Thillainayagam
Posted Apr 13, 2018 in Confluence

We want to hear how your non-technical teams are using Confluence!

Hi Community! Kesha (kay-sha) from the Confluence marketing team here! Can you share stories with us on how your non-technical (think Marketing, Sales, HR, legal, etc.) teams are using Confluen...

2,925 views 27 12
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you