 What’s New in FlightPath Data 1.1.87

FlightPath Data 1.1.87 takes off! The Winter 2026 release focuses on new CSV, JSONL, and Excel validation capabilities. In addition it delivers a few high value FlightPath Server management upgrades in FlightPath Data.

JSONL Lands In FlightPath Data

JSONL is essentially one JSON document per line. It is used heavily in logging, AI API prompts, and other dynamic environments. FlightPath JSONL support catches up with CsvPath Framework.
▶ Create and edit JSONL
▶ Edit CSV and JSON in grid view
▶ New JSON text editing view
▶ Edit JSONL as JSON

FlightPath Server Integration

▶ Config sync form: a fine grained control over config uploads
▶: Env sync form: enables desktop OS env vars to sync as sandboxed server project vars
▶ Sandboxed custom functions: support on server and desktop projects. Now your desktop project custom functions are project-specific and can live on the server without leaking into other projects.
▶ External functions anywhere: in FlightPath Data functions can be loaded from a file anywhere visible to the Python process. Server paths remain restricted for security.

New XPath and JSONPath Support

Support for using XPath and JSONPath expressions is a preview of more JSON and XML features in store for later in 2026, both in CsvPath Validation Language statements and alongside them.

New Functions and Improvements

▶ 24 new functions and over 35 total improvements
▶ blank(name|header) and wildcard() support Any in actuals, including None
▶ put() support added for dict, list, date, datetime, and None
▶ line_before() to compare current line header value to last line header value
▶ remove() to drop one or more headers
▶ rename(@stack) or rename(“a”, “b”, “c”…) to reset individual header names
▶ Self-documenting markdown docs generated by the functions themselves. E.g. https://github.com/csvpath/csvpath/blob/main/docs/func_gen/advance.md. These docs are barebones, but always 100% up to date. The original function docs .md pages will be maintained but should not be considered the most current and/or correct.

Qualifier changes

Qualifiers are a key part of CsvPath Validation Language. They name variables produced by functions behind the scenes. And they modify function, header, and variable behaviors. ▶ Support for name qualifiers in error() that are visible in error events. E.g. error.myname(“this is a msg”) outputs: 2025-12-08 00h42m40s-886915:temps.txt:1:Ⓜ️myname[1]: this is a msg
▶ Added skipnone qualifier primarily for push(). With notnone on push() None is flagged as an error; whereas, in some cases we just want to not push Nones.
▶ Support for the distinct qualifier in string(), integer(), decimal(), date(), datetime()

Dozens of Data Preboarding Workflow Improvements

▶ Added use-delimiter and use-quotechar for FlightPath Data and FlightPath Server projects to identify default settings for production and production-like runs
▶ When/do operator right-hand sides now contribute to matching and respects nocontrib
▶ Changed to a fixed width font in the printouts tab for cleaner printout review and previews