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 |