Solved

PLSQL Routing for binary file

  • 13 January 2020
  • 1 reply
  • 408 views
dsj
Rank
Userlevel 7
Badge +20
  • dsj
  • Superhero (Partner)
  • 669 replies

Hi All,

 

I’m bit confused about how PLSQL method works for inbound messages with binary data (eg: incoming PDF)

My interpretation of the documentation is that the IFS framework will encode input binary file to base64, placed in the BIN_DATA attribute of framework generated XML; thus the input of the PLSQL method is an XML. 

Both examples in the documentation were also written considering that the input is a XML 

However, my experience was that input clob for the PL SQL method is actual file data instead of a XML.

Am I confused with the documentation or is is there anything I have missed?

Example Function just return the input:

 

Application Message with Message Response PDF

My assumption was the response would be a XML with encoded file data; instead it’s actual input file

 

Cheers!

Damith

icon

Best answer by dsj 13 January 2020, 15:37

View original
DSJ - https://dsj23.me

1 reply

dsj
Rank
Userlevel 7
Badge +20

It was a NOOB mistake and found the answer.

Documentation and the functionality works as it should.

I was trying to return the input ‘thinking’ I should get the framework created XML but what happens under the hood is since the return message has the BINARY_PARAMETER/BIN_DATA element, framework extracts the binary file and send as output.

For someone who’s curious, here’s how the input XML clob looks like

<?xml version='1.0' encoding='UTF-8'?>
<BINARY_PARAMETER xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ifsrecord="urn:ifsworld-com:ifsrecord" xmlns="urn:ifsworld-com:schemas:connectframework_binary_parameter" ifsrecord:state="new">
 <BIN_DATA ifsrecord:datatype="Binary" ifsrecord:dirty="true">
 BASE64 ENCODED FILE
 </BIN_DATA>
</BINARY_PARAMETER>

Cheers!

DSJ - https://dsj23.me

Reply


Terms & ConditionsCookie settings