PDE Connector

Select any number of available PDA views to extract. Available views listed in Job creation form.

Rolling Date Range or Custom Job Run

Supported Filters:

• start_date >= record updated_on or created_on date

• end_date < record updated_on or created_on date

AWS S3 or SFTP (supports Key-Pair and password auth)

PGP encryption

File Naming:

• Automatically appends .csv.gz to the filename.

• Also supports {idx} as a wildcard.

Data Extract (Invoice)

Custom Configuration - any query against the PDA views.

Rolling Date Range or Custom Job Run

Supports Max ID Query

Supported Filters:

• start_date >= record created_on date

• end_date < record created_on date

• (max_source_id - only if max id query is used) <= record id

• (min_source_id - only if max id query is used) > record id

• Invoice Specific, comma separated list, no space

  • invoice_id, invoice_number, bill_cycle_name, billing_account_number_external, billing_account_number, ba_category_type_type

AWS S3 or SFTP (supports Key-Pair and password auth)

PGP encryption

File Naming:

• Automatically appends .csv or .csv.pgp to the filename.