How to use CLOB/BLOB datatypes IN and OUT parameter in IFS Cloud

Hi ​@shanmugapriyan.p 

Please find the answer below

The documentation:

https://docs.ifs.com/techdocs/23r2/040_tailoring/300_extensibility/100_odata_provider/1110_large_param_action/#large_parameters_in_actions

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 ​@Charana Udugama 

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?