Is there a way to schedule a query's results (like one already built as a Quick Report) to be sent as a CSV or XML file to an SFTP location via IFS Connect, rather than only being able to schedule it as an emailed report?

All FAQ questions / Integrations and APIs

Answer

Build a small custom scheduled script that reuses the same SQL as your Quick Report as a PL/SQL cursor, assembles the CSV/XML output as a CLOB, and sends it through IFS Connect using Plsqlap_Server_API.Post_Outbound_Message (the same underlying mechanism as posting an outbound BizAPI/integration message) — scheduling that custom script (rather than the Quick Report's own built-in email-scheduling option) is what gets the output routed to IFS Connect's outbound handling, which can then deliver it to an SFTP location via a routing rule the way any other outbound integration message would be.

Documentation-based answer. Confirm the product and release before applying it. This answer has not been verified in an IFS environment.

← Browse Integrations and APIs questions