<!-- TIER:1 -- Writing Scripts A script is a JavaScript function that runs at a specific hook point in the Celigo data pipeline. Scripts handle logic that expressions, filters, and visual mappings cannot -- complex conditionals, cross-record calculations, API calls within the pipeline, and custom routing. Concerns when writing a script: - Choosing the right hook point -- which function type matches what you're trying to accomplish - Input/output contracts -- what contains and what the function must return (array length rules are strict) - Expression alternative -- filter, transform, and outpu…