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
Community showcase
Published Nov 29, 2018 in New to Confluence

How to use Confluence Cloud for stakeholder management

Most of us don’t need much convincing that stakeholder management is important. It just makes sense that keeping everyone in-the-know on projects and assigning clearly defined roles is key to having ...

1,204 views 4 6
Read article

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