BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: No events within the next 45 days.

BI4 - Restful API - Variables with special characters


 
Search this topic... | Search SDK (VBA/ASP/JSP)... | Search Box
Register or Login to Post    Forum Index -> SDK (VBA/ASP/JSP)  Previous TopicPrint TopicNext Topic
Author Message
[ric]
Forum Member
Forum Member



Joined: 10 Jan 2008

Posts: 11


flag
PostPosted: Tue Sep 11, 2018 2:27 am 
Post subject: BI4 - Restful API - Variables with special characters

Hi all,

I'm trying to modifiy a varibale wich contains specific characters in order to define a hyperlink in the report.
I did it with the old SDK (BOXIR3) without any issue.
Today, with the Restful API, I didn't succeed to keep the specifi charcter in order to have my hyperlink i the varable.

- Variable define in the report :
Code:
="<a href=\"../../opendoc/openDocument.jsp?iDocID=FsZAEVDwwQ4AuAMAAKDrHlsgABY_Q2kl&sIDType=CUID"+[_Filtres_eff]+"&lsMNatCtr=03;04&lsMContrat=CDD&lsMTy_Eff=I&lsMStatus="+[Status]+"&sRefresh=Y\" target=\"_blank\">"+[Effectif Alternants]+"</a>"


- Variable received with the api Restful
Code:

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<variable dataType="String" qualification="Measure">
     <id>LA0</id>
     <name>01 - Eff_Ins_Hy_lien_CSP_Alternants</name>
     <formulaLanguageId>[01 - Eff_Ins_Hy_lien_CSP_Alternants]</formulaLanguageId>
     <definition>="&lt;a href=\"../../opendoc/openDocument.jsp?iDocID=FsZAEVDwwQ4AuAMAAKDrHlsgABY_Q2kl&amp;sIDType=CUID"+[_Filtres_eff]+"&amp;lsMNatCtr=03;04&amp;lsMContrat=CDD&amp;lsMTy_Eff=I&amp;lsMStatus="+[Status]+"&amp;sRefresh=Y\" target=\"_blank\"&gt;"+[Effectif Alternants]+"&lt;/a&gt;"</definition>
</variable>


If i send it again with &lt; or &gt; the varible is updated in the report with &lt; and &gt; instead of < and >. The link is not displayed anymore in the report...

Does anybody know how i can update this type of variable.
Thank you in advance.
Rich.
Back to top
[ric]
Forum Member
Forum Member



Joined: 10 Jan 2008

Posts: 11


flag
PostPosted: Tue Sep 11, 2018 2:43 am 
Post subject: Re: BI4 - Restful API - Variables with special characters

Finally worked fine with a proper StringEscapeUtils.escapeXml. banghead.gif
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> SDK (VBA/ASP/JSP)  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0324 seconds using 17 queries. (SQL 0.0024 Parse 0.0009 Other 0.0291)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo