Report
The Report Task lets you run Advanced Reports queries and downloads them to Persisted Storage. You can then use this report extract to drive batch integrations or feed to downstream reporting platforms.
Configuration
The report task accepts the following configuration:
| Configuration | Description |
|---|---|
| Output File Name | Name of file. Any existing file in Persisted Storage will be overwritten |
| Sensitivity | Files can be accessed from Flow Studio to allow for debugging / review provided your User has two new Integration Flow app permissions: “Persisted Storage Access” and “Persisted Storage Get”. It is expected that sometimes a file will contain sensitive data. For this we’ve created an separate permission “Persisted Storage Get Sensitive Record” to further restrict access. Options: - Sensitive - Not Sensitive |
| Time to Live (TTL) | All files created by Storage Task are temporary and will be deleted once the TTL expires to conserve space. Each time a file is updated (using the PUT operation with a filename of an existing file) the TTL will be extended. Options: - One Week - One Month |
| Report Query | Dropdown list of all reports available in your tenant. |
| Parameters | Any parameters identified in the selected report will appear in the list below. Parameters can be defined in your report using the {{param}} notation. |
Task Output
Returns the output from the invoked flow that can be used in subsequent tasks.
| Operation | Output Variables | DataType | Description |
|---|---|---|---|
| Put Record, Delete Record | OperationOutput | Text | Success or Failure |
| Query By Key | StorageRecord | Json Object | File details and content |
| Content | Json Object | Json content of file | |
| FileIdentifier | string | File name | |
| FileSize | Number | Size of file in bytes | |
| Sensitivity | String | Sensitivity level of the file. Values: - Sensitive - Not Sensitive | |
| LastModified | DateTime | Date and time last modified | |
| ExpirationDate | DateTime? | Date and time when document will be purged | |
| ExecutionId | Guid | ExecutionId that created or last updated the file | |
| Query by Prefix | RecordsList | Collection | Collection of Storage Records matching your Prefix |
| FileIdentifier | string | File name | |
| FileSize | Number | Size of file in bytes | |
| Sensitivity | String | Sensitivity level of the file. Values: - Sensitive - Not Sensitive | |
| LastModified | DateTime | Date and time last modified | |
| ExpirationDate | DateTime? | Date and time when document will be purged | |
| ExecutionId | Guid | ExecutionId that created or last updated the file |