Skip to Content
avatar image
Former Member

Rest API : import document in BO 4.2

Hi experts,

I want to import with an automatic process (promote job is too complicated for us) the documents (pptx, xls, pdf) in the BO folders and tagged these in the categories.

I think, I can use the Rest API, is it correct ? Have you got a better idea ?

I found this documentation : https://blogs.sap.com/2013/09/05/scripting-web-intelligence-the-restful-raylight-web-services/ & https://blogs.sap.com/2014/10/17/scripting-web-intelligence-the-restful-raylight-web-services-with-python-sample/

But it is not clear for me, have you got an explanations : which language ? Web Services are mandatory ?

Infos : System : 4.2 SP2 + BW 7.3 sp9

In advance thank you for your help.

Goulwen

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Oct 15, 2016 at 09:46 AM

    Hi Goulwen,

    You can use the RESTful Web services for importing/uploading document to Enterprise.

    • You can upload any BOE or Non-BOE documents.
    • BOE files: Webi, Crystal and Lumira documents. These documents are uploaded as Web Intelligence, Crystal Reports and Lumira Document respectively. Apart from these BOE documents, rest all documents gets uploaded as Agnostic .
    • Non-BOE files like: word, pdf, txt etc. These documents are uploaded as Word Document, Adobe Acrobat and Text respectively.

    Following is the REST call that you have to fire for each document upload:-

    URL - http://<server-name>:<port>/biprws/infostore/folder/<folder-id>/file {Replace <folder-id> with the SI_ID of the folder in which you want to upload a file.}

    Method - POST

    Headers -

    content-type: application/xml

    X-Sap-Logontoken: "<Your-logon-token-in-double-quotes"

    Request Body -

    <entry>

    <title type="text">test</title>

    <content type="application/xml">

    http://www.sap.com/rws/bip">

    <attr name="id" type="int32"></attr> {Leave this as blank, as this will assign by CMS}

    <attr name="title" type="string">test</attr>

    <attr name="cuid" type="string"></attr> {Leave this as blank, as this will assign by CMS}

    <attr name="parentID" type="int32">5213</attr> {This is the folder-id that you are providing in URL}

    </attrs>

    </content>

    </entry>

    For more information, download the RESTful Web Services SDK Developer Guides for BI platform 4.2 using this link.

    Detailed & elaborated information present in Section - 6.8 Uploading and Downloading File.

    Hope this helps you !!!

    Thanks,

    Shailendra

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 13, 2016 at 07:53 PM

    Looks like you can publish or download files with Restful SDK

    Here's a link to the API for this:
    https://uacp2.hana.ondemand.com/viewer/#/db6a17c0d1214fd6971de66ea0122378/4.2.3/en-US/13b5eb029d0b409bb7cb311ff9b94502.html

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 13, 2016 at 05:49 PM

    I'm not sure that you can use the RESTful Web Services for publishing files. You may have to use either the Java or .NET SDKs for this. I have sample .NET code available on my site that may help get you started. Go to http://www.dellstinnett.com/sample_code.html and look for "Code for BOEPublishFiles Assembly". This is old code, but there haven't been changes to this area of the SDK since I wrote this.

    -Dell

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 09, 2016 at 02:48 PM

    Thank Toby,

    I will try your solution

    Goulwen

    Add comment
    10|10000 characters needed characters exceeded