Skip to main content
Question

ConnectivityProcessingHandler:LoadInboxMessage as projection in IFS Cloud

  • January 20, 2022
  • 5 replies
  • 342 views

Forum|alt.badge.img+8

In IFS10 (and previous versions) there is BizAPI ConnectivityProcessingHandler:LoadInboxMessage that can load IN_MESSAGE and IN_MESSAGE_LINE from a XML.

I cannot find equivalent Projection in IFS Cloud.

Do you know if there is such projection and the name of that projection?

 

Neno

5 replies

Forum|alt.badge.img+8
  • Author
  • Sidekick (Partner)
  • 26 replies
  • February 10, 2022

I’m answering my own question - there is no Projection for ConnectivityProcessingHandler:LoadInboxMessage . I had to develop PLSQL package and user PlSQL connector to get IN:MESSAGE data into Connectivity.


khajeewak
Sidekick (Partner)
Forum|alt.badge.img+3
  • Sidekick (Partner)
  • 6 replies
  • February 11, 2022

Hi NZCNESOSE,

Can you please explain a bit how you use PLSQL  connector to get into the connectivity table?

/Jeewan


Forum|alt.badge.img+8
  • Author
  • Sidekick (Partner)
  • 26 replies
  • February 13, 2022

In short, you create a Oracle package function with following parameter signature:
FUNCTION Load_Inbox(in_xml_ CLOB) RETURN CLOB

then, create IFS Connect address with type = PLSQL and enter name of the function and PLSQL parameter. Route your XML message to this address and you will get XML filen in  in_xml_ CLOB variable.

Thereafter use Oracle XMLTABLE functionality to “convert” XML into usable cursor that can be used to insert data into In_Message nd In_Message_Line.


khajeewak
Sidekick (Partner)
Forum|alt.badge.img+3
  • Sidekick (Partner)
  • 6 replies
  • February 14, 2022

Thank you.

/Jeewan


Forum|alt.badge.img+2
  • Sidekick (Partner)
  • 9 replies
  • February 11, 2025

Hi All,

Could you please verify whether we need to develop the same approach (procedure to create lines) for 23r2 and later versions, or if IFS has introduced a new process to create connectivity inbox data?

Thank you,
Lochana


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings