Confluence integration

[Pavel]

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,

[Nic Brough -Adaptavist-]

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.

[Pavel]

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

[Pavel]

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.