f/cfml

Using BoxLang to process CSV files and push data to an API endpoint

Using BoxLang to process CSV files and push data to an API endpoint

A vendor sent bulk data as Excel instead of JSON, conflicting with an API endpoint's small-payload limit. A quick BoxLang CLI script parsed the CSV, handled Excel currency formatting, and chunked the output into 100-row JSON files. A second script POSTed each file to the endpoint with SHA-1 auth headers. Total time: ~15 minutes. BoxLang's command-line scripting made it a natural fit for the job.

kisdigital.com View

Comments

No comments yet. Log in to start the conversation.

f/cfml

Adobe ColdFusion, Lucee, and BoxLang

Created Feb 13, 2026

2  Members

Moderators
u/rob