...
Understanding the Big Picture
Design Considerations
...
- Both can modify values at the row level.
- Custom File Processing additionally supports adding new fields to the row as well as the processing of the entire file for more complex scenarios.
...
Does Custom File Generation need to be considered in context of this design considerations?
Custom File Generation uses a PowerShell script in an entirely different context than Customer Record Processing and Custom File Processing. Whereas the latter items modify the content of an uploaded file during processing, Custom File Generation executes a script on a schedule to generate a file.
...
- API invocation is supported by Custom Record Processing (on Agent screen)
- This works well if we are confident that any logic requiring use of the API happens after the file has been converted to tabular data by the Custom File Processor.
- However, it is of course only applicable if we retain the Custom Record Processing capability.
- API invocation is supported by Custom File Processing (on Data Map screen)
- Building a Data Map requires discovery of the source file columns. When a Custom File Processor is used and that script requires the use of the API, then we must prompt for an API Connection for executing the script (per Multi-Connection enhancements).
- If we use this approach, it may be preferred that ODS API support for the preprocessor is explicitly enabled as a configuration option for each applicable Preprocessor script.
- API invocation is supported by Custom Record Processing and Custom File Processing
- This favors flexibility for undiscovered use cases.
User Interface Changes
...
Menu
Manage Scripts
Add Script
Add Data Map
Database Changes (TODO)
| Table | Change | Justification |
|---|---|---|