Skip to main content

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

Hi,

 

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

  1. define a variable cvs_ of datatype CLOB and fill it with the content of the csv file.
  2. 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


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


Reply