The File Reader system enables automated data extraction and processing from various file formats.

Configuration

  • Reader Name: Custom identifier for use in automations
  • Document Type Selection: Choose from supported file formats
  • Automation Integration: Readers can be used as automation triggers or steps

Supported Document Types

Purchase Orders

  • Process procurement documents
  • Extract order details
  • Parse vendor information

Text Files

  • Plain text processing
  • Log file analysis
  • Structured text parsing

Table Data

  • CSV/Excel processing
  • Structured data extraction
  • Column mapping

JSON

  • Parse JSON structures
  • Extract nested data
  • Transform JSON objects

Features

  • Automated data extraction
  • Field mapping to app records
  • Data transformation rules
  • Error handling
  • Validation checks
  • Batch processing
  • Custom parsing rules

Usage in Automations

  • Trigger workflows based on file uploads
  • Extract data for record creation
  • Transform file contents into structured data
  • Validate incoming data
  • Route files based on content
  • Update existing records with file data