To extract data via UltiPro® reports as part of a chain, add a step that includes an UltiPro connection command. By leveraging the integration between this and other applications' connections, you can integrate UltiPro data in a variety of use cases, from key performance indicator (KPI) dashboards and mashups, to data replication and custom reporting front-ends.
To enable these commands, an IT admin first creates an UltiPro connector.
Execute report
To run a report request and downloads its contents to a comma-separated values (CSV) file, use an Execute report command.
Properties
| Property |
Detail |
| Report Path |
Enter the path to the report.
To find the path in UltiPro, on the report's properties page, click View the search path, and copy the Search path.
|
| Parameters |
Enter the parameters to pass to the report. If none, leave blank. |
Outputs
| Output |
Output type |
| Report |
File |
| Report key |
String |
| Report size (bytes) |
Integer |
Exit codes
| Code |
Type |
Detail |
| 0 |
Success |
Success |
| 1 |
Error |
There was an error running the command |
| 2 |
Error |
Unable to authenticate with UltiPro |
Get report list
To retrieve a list of the public IBM Cognos® reports, use a Get report list command.
Properties
| Property |
Detail |
| Name filter |
Enter the name — or part of the name — of the reports to retrieve (optional). |
Outputs
| Output |
Output type |
| Reports |
JSON |
Exit codes
| Code |
Type |
Detail |
| 0 |
Success |
Success |
| 1 |
Error |
There was an error running the command |
| 2 |
Error |
Unable to authenticate with UltiPro |
Get report parameters
To retrieve a list of parameters for a report, use a Get report parameters command.
Properties
| Property |
Detail |
| Report path |
Enter the path of the report with the parameters to retrieve.
To find the path in UltiPro, on the report's properties page, click View the search path, and copy the Search path.
|
Outputs
| Output |
Output type |
| Report parameters |
JSON |
Exit codes
| Code |
Type |
Detail |
| 0 |
Success |
Success |
| 1 |
Error |
There was an error running the command |
| 2 |
Error |
Unable to authenticate with UltiPro |