Oracle Analytics Publisher

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Calling a report using a soap request changes the special characters.

Received Response
31
Views
1
Comments
Youssef_Antoury
Youssef_Antoury Rank 1 - Community Starter

Hello everyone,

I needed to call a report from visual builder studio, I did it by calling a soap request in JavaScript. I put the data type xml and got an xml response.

In BI publisher the report returns words with special characters because it's in French, for example : é, è, ê ...

The thing is that in the xml response that I'm getting from the SOAP API all the special characters are replaced by other symbols.

é is now é. What can I do to get the special characters ? Is there a charset that I need to change ?

I still need it to be xml, also the response is encoded in Base64 Encoding, does decoding it create this issue ?

Thank you

Answers

  • Hassan El Bouihi-Oracle
    Hassan El Bouihi-Oracle Rank 5 - Community Champion
    edited July 2023

    Hello Youssef,

    Converting the base64 to text will not affect the character sets.

    Please refer to this KM Note for details on implementing character sets:

    Chinese and Other Language Characters Appear as Question Marks(?) When Using Data Template (Doc ID 353164.1)

    Thank you

    Hassan