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
Best answer by heibde
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>');
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>');
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.
