Looking for anyone who knows how to or (better yet) has an example of an IPA flow that can execute a Report and output the report as CSV or Excel format to the Infor cloud SFTP server?
We are on multi-tenant Cloudsuite HCM. Thanks!
If you’re looking to extract data from CloudSuite, consider the following options:
Use Web Services: Leverage Infor Process Automation (IPA) with the Web Run node to call CloudSuite web services and retrieve data.
Data Replication Sets: Configure data replication to generate a CSV file, then use IPA to move or transfer the file as needed.
Data Lake Querying: Execute SQL queries against the Data Lake using IPA in combination with Data Lake IONAPI to access and extract the required data.
Thank you, Vikram. Yes, I am aware of those options. We have many many complex reports that are already built and used frequently by our users. The goal is to be able to export them on demand to a file system where we can have other automation move them to specific places on our network for various ingestion.
Have you already tried using Web Runs? When a report (User Folder list) is exported to CSV in the UI it looks like there's a chain of three web requests: 1. POST request to submit the report that returns the Async ID2. GET request to retrieve the ReportDocument ID using the Async ID3. GET request to download the output using the ReportDocument IDYou might be able to leverage those three requests in an IPA, save the output of the third request to a PfiFileStorage record, and then SFTP.
