Did you use any one CLOB/BLOB datatype as an IN and OUT parameter for projection action through JSON in REST Integration IFS Cloud?
Hi
Please find the answer below
The documentation:
Look at the example files in the link in the documentation.
Basically you need to:
Create Temporary LOB Storage:

In the Response you get an “OData-EntityId” that you shall use in next call:

Next step is to send the LOB data to the temporary LOB storage URL you got from previous call’s response:

Then You can call your projection action like this:

For reference, this is my ProjectionAction and plsql Implementation:
action LoadExternalFile {
initialcheck none;
parameter CreatedFrom Text;
parameter FileName Text;
parameter Message LongText;
}
PROCEDURE Load_External_File___ (
created_from_ IN VARCHAR2,
file_name_ IN VARCHAR2,
message_ IN CLOB)
IS
BEGIN
C_Ext_File_Server_Util_API.Load_External_File(created_from_, file_name_, message_);
END Load_External_File___;
Hi
Thanks for the reply.
I want to send a JSON request inside the procedure using CLOB OUT datatypes. So could you have any reference procedure with sending in the stream content / {{OData-EntityID}}ClobData?
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.