Home Integrations Latest Article HCM Advertise

January 15, 2021

Read BI Report base64 encoded response

In the previous post we have seen the PART 1 of BI Report Invocation. If you don't have seen that requesting you to first check that out by clicking here.

In this article we will develop the left part (PART 2) i.e. convert the base64 encoded run report operation response  and then read it in proper XML format using stage activity.


ADVERTISEMENT




PART 2 : Steps to read the base64 encoded report output.

    • Add Assign activity to decode the run report base64 encoded output

    • Enter a meaning full name and then click Create

    • Click "+" to create one Variable

    • Give variable any meaningful name and then click Edit icon

ADVERTISEMENT


    • drag an drop the runReport Response (*reportBytes) and then put it inside a String function after that put Complete thing as input of decodeBase64ToReference function
[Please take reference from below image]


    • click save and close the assign activity window

    • Now lets add one Stage activity to read the response data in xml format

ADVERTISEMENT


    • Enter any meaning full name and then click Create


    • configure the below parameter as suggested below 
Choose Stage File Operation : select Read Entire File
Configure File Reference : Select Yes 
Specify the file reference : click edit and drag and drop the assign activity variable in it. click save and Close. Click Next




    • select XML Schema (XSD) Document as File Structure and click Next

    • select the schema file and then click Next 

ADVERTISEMENT



*Note : For your information the above selected schema is actually defining the structure of your BI Report Response. If you want to get the structure of your BI Report Response then just decode the base64 output data (just google base64 decode tool and then paste the base64 output to decode) and after that you can see the XML format. Using this xml you can create the schema file.


Base64 decode Tool
    • Stage Read operation configuration completed , click Done.

    • Save the integration and close the window. Activate the integration and submit it to test it.


    • Once integration processed successfully, open the monitoring window and check the stage Read Response. You can the see the Report Response in proper readable XML Format. Now you can use these data for further processing in the integration flow.



Thank You !we have successfully developed the integration to invoke BI Report in an integration. If you have any questions please do let me know in comment section. 


ADVERTISEMENT


28 comments:

  1. DebJanuary 19, 2021 at 3:31 PM

    Nice article but to define schema there is an easier way. Go to OTBI Catalogs and run the report and export it as csv. Use the CSV file in the stage activity.

    Regards,
    Deb

    ReplyDelete
    Replies
    1. K a b i r Y a d a vJanuary 20, 2021 at 11:04 AM

      Thanks Dev but this article is written from OIC perspective. For your approach we have to login different environment and do the rest suggested stuff's, which i don't want :)

      Delete
  2. lazydevJanuary 20, 2021 at 8:07 AM

    I am a beginner in OIC and thanks for your posts so much. It's very helpful for me to understand the platform. I can't wait to look forward to your next post :D

    ReplyDelete
    Replies
    1. K a b i r Y a d a vJanuary 20, 2021 at 10:57 AM

      Its a pleasure for me,Thank you so much:)

      Delete
    2. lazydevMarch 16, 2021 at 3:35 PM

      BTW, do you know there is a community or forum that I can join and discuss around OIC? Thanks!

      Delete
    3. K a b i r Y a d a vMarch 25, 2021 at 10:58 AM

      give me some time, will let you know.... :)

      Delete
    4. lazydevMarch 25, 2021 at 12:22 PM

      Thanks, Kabir Yadav!

      Delete
    5. lazydevApril 8, 2021 at 9:03 AM

      By the way, do you know how to build and publish a accelerator and recipes on OIC? I searched in Oracle Docs, but I found nothing about that.

      Delete
  3. sjosyamFebruary 11, 2021 at 12:06 AM

    Hi, Thanks for the blog. I would like to know how a report output that is large (>10MB) be handled in this kind of scenario? Appreciate a response.

    Thanks

    ReplyDelete
    Replies
    1. K a b i r Y a d a vFebruary 19, 2021 at 10:31 PM

      You can use "Read File in Segments" as Stage File Operation

      Delete
  4. UnknownMarch 5, 2021 at 12:19 AM

    Sir i am big fan of your blog, can you please help to put the report catalog which is used here and xsd schema which is used.
    while practicing same i was facing some issue.

    ReplyDelete
    Replies
    1. K a b i r Y a d a vMarch 10, 2021 at 9:17 AM

      Sorry, that is not avilable now :). XSD you can easily create using the steps which I have mentioned above in my post (inside *Note )

      Delete
  5. Hari krishnaMarch 18, 2021 at 2:32 PM

    Awesome brother. Nice article.

    ReplyDelete
  6. Rahul SahaApril 3, 2021 at 10:01 AM

    Hi Kabir ,
    The above example is when we have one report generated when OIC integration is executed . If we have multiple reports present when OIC integration is created , how can we read the contents of each report .

    ReplyDelete
    Replies
    1. K a b i r Y a d a vApril 11, 2021 at 7:47 PM

      I think u have to repeat same steps to invoke and read each BIP report.
      "Stage activity" should be repeated for each BIP because the output file format (schema)of every BIP response may not be same.

      Delete
  7. UnknownApril 10, 2021 at 2:54 PM

    Hi,

    I am new to OIC.

    I am not able to decode the code through Base64 site. Some junk characters are appearing on Decoded data.
    ====================
    PK 5R xl/worksheets/sheet1.xml[sH ߧj x+ͩIEjjD[ $9Of:'/ŷw7k5
    8|Ei2^_DMwqr2ֵ]tJ 1׿\O4 (4!(.SȷGq^z Ns;ƯLۉ}v*~O?"> 9p=mz9N osݒ3wq;Ak۷H\eZ8 Iϴ3V u#:us/{H9Q p GuQ؟8@upr/4a4uiQ׎zCsҷG[ƏiJ z ZzV5 uX[7*r'K?Z%*?
    ̩l4ۖju5T rW?3啰 a
    ===============================================
    My BIP report output is in excel.

    Regards
    Deepak

    ReplyDelete
    Replies
    1. K a b i r Y a d a vApril 11, 2021 at 7:35 PM

      IF you can send your BIP response then i can try to help you. You can send it personally to my email id (check 'contact me' option at top right hand side)

      Delete
    2. UnknownJuly 28, 2021 at 4:43 PM

      Hi Kabir,

      For me also its not working, can you please check my mail and share your suggestions.

      Delete
    3. K a b i r Y a d a vJuly 29, 2021 at 8:42 PM

      i replied to your email, please check and confirm back

      Delete
  8. UnknownApril 30, 2021 at 11:01 PM

    How can we get the report in different formats like csv

    ReplyDelete
    Replies
    1. K a b i r Y a d a vJuly 29, 2021 at 8:44 PM

      it's easy, any ERP professional can help you on this

      Delete
  9. UnknownAugust 28, 2021 at 1:27 PM

    Hi Kabir,

    Good article.It will be helpful if you share your knowledge on securities as well in OIC

    ReplyDelete
  10. AkshayNovember 18, 2021 at 12:32 PM

    Very helpful article
    Can you create a blog regarding receiving data from SAP via SAP adapter in OIC to ERP further , what kind of use cases we can have for this approach

    ReplyDelete
  11. K a b i r Y a d a vNovember 25, 2021 at 1:17 PM

    Thanks Akshay for appreciating my work :)

    ReplyDelete
  12. AnonymousJanuary 20, 2022 at 6:57 PM

    hi kabir,
    How do we define schema from the xml that is generated?

    ReplyDelete
    Replies
    1. K a b i r Y a d a vJanuary 24, 2022 at 11:23 AM

      1 --> u can do it manually but that's a lengthy process
      2 --> u can directly generate it by googling 'generate schema from XML'😋

      Delete

If you have any doubts, Please let me know.