Designed for ETL developers and integration specialists, the file parser API offers a resilient, simple way to process flat files into structured data that can be loaded into another file or into a database. By tunneling your files through this API, you can catch most minor formatting errors as well as unexpected changes to the files, like column changes, format changes, different regional settings, etc.
When you upload a delimited or fixed-width flat file to the API, it will attempt to automatically interpret the file format and the datatypes of all the cell values. It will also,
The API is free for evaluation purposes. For this purpose, you can try it out with files up to 20 kB (20 480 bytes). If you want to load larger files, you'll need an API key. As with everything else, as long as it's free, there are no guarantees with regards to service level or functionality and we may choose to alter or even suspend evaluation access to the API at any time.
With a paid plan, you can load much larger files and you get a service-level agreement (SLA) detailing the kind of uptime and service metrics you can expect.
If you need a lot more throughput, or if you just have trust issues (and who doesn't?), we'll set you up with a way to run the API locally on your infrastructure, on prem or in the cloud!
The entire service is written in node.js with no frameworks and a minimum of libraries. All you need is really a web server of your choice. Contact us for a quote.
Remember: It's not magic. I've built in a lot of checks and safeguards, but in the end, there are things that an automated web service won't be able to fix. Use the errors/warnings feature in the JSON blob to detect unresolved errors in a manner that is suitable to your ETL and data quality needs.