Solved

Outbound Integration - CSV file creation

+4

Hello All,

I have a requirement of creating CSV file in IFS 10 and sending it to external services .

I need to send the file using SFTP connector(integration)

Does anybody have an Idea on how to create a csv file and send it through Clob variable in PLSQL_Server_Api. Any sample code would help.

Regards,

Thej

icon

Best answer by heibde 26 September 2022, 08:01

Userlevel 4

+9

Hi,

it’s extremly simple to send csv files in Apps 10:

define a variable cvs_ of datatype CLOB and fill it with the content of the csv file.
call Plsqlap_Server_API.Post_Outbound_BizAPI(bizapi_name_ => '', xml_ => csv_, sender_ => 'IFS', receiver_ => '<any value for identifying it in routing condition, e, g. MY_CSV>');

That’s all.

Best regards

Heinz

+4

Thank you for Sharing Heinz .. I will give it a try .

Sign up