Use BLOB/CLOB datatype as an input parameter for an action through JSON in REST Integration IFS Cloud

Hi,

I am looking for a solution to the above-mentioned problem.

Yes, it is

Hi, 

→ I have created a action with LongText  as datatype, 

→And later I have passed the longtext value as parameter to one of my procedures, as a CLOB datatype.

→the content got as a input from json will be encrypted, so I will be decrypting and converting to BLOB and storing into a variable of blob datatype.

→the obtained blob value will be sent as parameter to edm_file_storage_api.write_file_data.

Thanks in advance.

It is POST service.

Hi,

the json payload looks as below,

{
  "CReport" : {
    "Content" : "’",
    "ContentFormat" : "application/pdf",
    "Number" : "12349",
    "LanguageCode" : "en-US",
    "ReportFormat" : "PDF",
    "ReportType" : "Acrobat"
  }
}

in the content the encrypted longtext/ decrypted BLOB values will be parsed.

I also miss some bits and pieces. In the procedure, you have four parameters, none of them is that structure I think.

At any rate, what I think is happening is that you don't post the data in the form/format that the ODP expects.

Try stripping things down to their bare minimum by removing parameters or attributes in the structure until it works, then add things back.

Good luck!
 

How to send in CLOB/BLOB is described here in 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___;