Export To CSV Combined

Properties

• Input
  • Document Ids
    • Type:List<int>
    • Description: A list of unique identifiers for the documents to be exported to CSV. This is a required argument.
  • CSV Separator
    • Type:string
    • Description: The separator to use for CSV fields. This is a required argument.
    • Default Value:";"
  • Document Category Ids
    • Type:List<int?>
    • Description: A list of unique identifiers for the document categories used to limit export results. This is an optional argument.
  • Combine By External ID
    • Type:bool
    • Description: Specifies whether to combine output by the document's external ID property. This is an optional argument.
    • Default Value:false

Usage

1. Setup Activity:
   • Add the "Export To CSV Combined" activity to your UiPath workflow.
   • Configure the required input arguments:
     • Document Ids: Provide a list of document IDs whose extraction results you wish to export.
     • CSV Separator: Define the separator character to use in the CSV file.
   • Optionally, specify:
     • Document Category Ids: Limit the export results to specific document categories by providing their IDs.
     • Combine By External ID: Set totrueif you want to combine rows in the CSV based on the document's external ID.
2. Execution:
   • The activity executes asynchronously, exporting the specified documents' extraction results to a CSV list.
   • IfCombine By External IDis enabled, rows with the same external ID will be merged in the CSV output.
3. Output:
   • The activity returns aList<string>, where each string represents a line in the CSV file, starting with column headers followed by the data rows.

Considerations

• Data Selection: Ensure that the document IDs are accurate and accessible to avoid errors during the export process.
• CSV Formatting: The chosen CSV separator should not conflict with the data content to ensure proper CSV formatting.
• Category Filtering: Use document category IDs to refine the export results, focusing on specific subsets of documents if needed.
• Combining Rows: When combining by external ID, ensure that the external ID field is consistently populated across documents to achieve the desired output.