Changelog

A new set of APIs to programmatically manage templates and template hooks. New functionality now available:

• Create / Read / Update / Delete code hooks and/or native template hooks (previously, it was only possible to create and delete code hooks).
• Update a template via API
• Push template to environment(s) via API

‍

Users can now organize their FileFeeds into folders.

Users can add text replacements for FileFeeds (within the same customization). Under the User Education tab, users can toggle between Importer and FileFeeds to see the different options.

You can now specify the environment and allowed domains for embedding FileFeeds in the developer dashboard.

All files uploaded into OneSchema will now automatically be scanned for malware through Amazon GuardDuty. Users will be prevented the user from downloading the file from the UI and from the external API if malware is detected.

The FileFeeds SDK has been upgraded to support session tokens!

• Support for session_token as an initialization and launch parameter. When a session_token from an existing, valid session is passed along with a corresponding JWT, the session will be resumed. The session_token will be included in the init_succeeded and saved event data payloads, and the session_id will no longer be returned.
• By default, OneSchema will automatically save the session_token and resume the session if it was not closed through normal means (e.g., browser closing or refreshing). However, the session will not resume if the user cancels it or if it ends.

OneSchema now supports single-sign-on (SSO) and Security Assertion Markup Language (SAML) authentication to manage authentication and access to the OneSchema dashboard.

Users can now specify which sheet in a multi-sheet Excel file to use in the FileFeeds product. If a user does not specify, the first sheet will automatically be the one selected for upload.

Our FileFeeds embedding SDKs are now public for both JS and React:

• https://www.npmjs.com/package/@oneschema/filefeeds
• https://www.npmjs.com/package/@oneschema/filefeeds-react

A new version of our SDKs for the Importer (0.6.0) is now available for all 4 supported frameworks: JS, React, Vue and Angular.

• Added compatibility with OneSchema FileFeeds packages.
• Exported TypeScript types in Importer React package.
• Dropped TemplateGroups feature.
• Added tslib as direct dependency.

Importer React SDK 0.7.0 update: inline prop is defaulted to true

‍When upgrading to this version, if you still need the non-inline behavior, you could set inline={false} explicitly. Or, you could switch to the inline rendering (which is more native to React environment) and adjust your style attribute and CSS rules to achieve the desired UI presentation.

OneSchema now has logs for all types of supported webhooks:

1. Importer Event webhooks
2. Importer Metadata webhooks
3. FileFeed Event webhooks

• Pipelines are now built into FileFeeds and called Transforms
• FileFeeds now respect pushed templates (relying on the latest template version pushed to the Production environment)
• Change history: you can now see the history of saved transforms per FileFeed
• New bulk action & pop-up: “Missing required columns”, clicking on “Add all missing columns” forces all required template columns onto the FileFeed
• “Save transforms” button moved to the top right corner of Transforms
• When uploading a new sample file to a FileFeed, the column mapping modal auto-opens
• Sample file columns mapped to template columns are now highlighted by a green “MAPPED” badge
• Other minor UI/UX updates

Allows uploading XML files to both Importer and FileFeeds.

The new “JSON to CSV” pre-parsing hook for Pipelines allows you to extract fields from JSON: it creates a new column for each key in the JSON object and fills the cells with the respective values. The feature also supports array de-nesting: it duplicates the row for every array item.

‍

Users can now set custom JSON metadata on FileFeeds via the settings page or via API. The metadata will be attached to validation webhook payloads, import webhook payloads, and to JSON file exports as file_feed_metadata. There is a 2000 character limit and this metadata will not be attached to CSV exports.

Users can now use an import webhook as a file feed destination! Note that import webhooks for the Importer and FileFeeds product are separate - you may find tabs on the webhook page in your dashboard to delineate between the two.

Users can now manually fix file feed errors: open a FileFeed run that has “Error rows remaining”, click “Manually fix errors”, and it will open the familiar experience that OneSchema Importer users know as “Review & finalize.”

‍

We're excited to announce the addition of 3 new validation types:

• UPC (Universal Product Code): is a barcode symbology that is used worldwide for tracking trade items in stores.
• EAN (International Article Number or European Article Number): A superset of UPC.
• IMEI (International Mobile Equipment Identity): a numeric identifier, usually unique, for mobile phones.

If an end-user clicks on the “bin” icon next to a column on the Mapping step (which triggers the “This column will not be imported” message) - this action will now be saved in historical mappings, and reapplied for future uploads with the same column names.

This newpreparsing hook allows you to accept fixed width files (e.g. TXT, DAT) and convert them to CSV.

‍

Users can now specify a desired export format for their FileFeed output via the settings pane. Currently, CSV and JSON are supported.

We've launched a new preparsing hook that can be used for advanced Excel parsing. One example use case for this is the ability to ignore Excel's scientific notation formatting.

Users can specify a regex for filtering which files are processed from their FileFeed source. This is applied at the FileFeed level and can be changed in FileFeed settings or upon instantiation of a new FileFeed. Files in the source directory that don't match the regex will be ignored.

Customers can now specify a template column as multi-mappable, which allows your users to map multiple uploaded columns to the same template column. This enables better functionality for use cases such as aggregating multiple columns into a single column, and managing validation of multiple columns of the same type.

We're excited to just expand the capabilities of theExcel template file that your users can download during the import process! This new feature enables you to upload a custom file in place of our default generated one. You can find the configuration for this in the Settings tab of each template. Please note that the customization must be enabled for the download button to appear in the importer.

We've launched a new column to the table of Template Validation Hooks, listing the Template Columns attached to each hook. This is to help template owners manage and verify the hooks in use.

We've increased the efficiency of our Rust data infrastructure, allowing support for uploading even larger files than before (up to 50M rows). Note: performance will be affected if code hooks are used, depending on the complexity of the code hook.

Access Control is a feature that is now available for all Enterprise customers! With Access Control, three user roles are available:

• Admin: This user can manage your team’s access to OneSchema in addition to the Developer role’s permissions.
• Developer: This user will have access to the full OneSchema product experience. This includes templates, environments, API keys, webhooks, customizations, and analytics.
• Analyst: This user is able to view imports in Import Activity

The new Locked Columns feature allows template owners to lock the value of specific columns, which is useful for fields where you don't want users to be able to edit certain data types. Once locked, the cells in these columns will be read-only, highlighted with a darker gray background, and have a popover indicating their lock status. If there are any errors/warnings for these cells, the error/warning message is displayed as before. Autofixing and accepting suggestions is enabled, however, manual edits are not.

With our new sheet_operation_performed event, you'll now be able to receive event webhooks for all events that happen on Pane 4. This gives you greater insights into the end user behavior which helps both with finding ways to improve your product, as well as building in-depth auditing capabilities.

We've launched a new customization that allows your users to add a row to uploaded files in importer! The added row will always appear at the end of the file.

We've launched additional endpoints for creating code hooks via the API to allow you to easily manage your code hooks locally.

We've launched a new experience on template pages around environments that will enable admins to better manage making and pushing changes to templates. Admins will now see UI on the All Templates page that indicates which environments a template was last pushed to, and UI that indicates the number of changes made to a template that have not been pushed.

Frequent Error Types has now been added to the Importer Analytics! This lets you see which columns your users are experiencing the most validation errors on the Review & Finalize pane.

Importer Analytics unlocks powerful information about how your customers are interacting with your importer. From here, you can see data like conversion percentages, time spent per pane, and frequent errors your customers are encountering.

For complex use cases where diving even further into analytics is necessary, Event Webhooks allows you to see data around the following events:

• Embed Initialized
• Embed Resumed
• Embed Closed
• File Uploaded
• Header Selected
• Columns Mapped
• Import Submitted

The new search filter on Import Activity provides a more seamless experience by enabling you to filter import activity across template_key, original file name, and user_id.

We've made updates to our pane 4 experience to create a better experience when the uploaded file has warnings. With this new experience, when your user clicks the "Rows with issues" tab, they'll see a dropdown which allows them to filter on only errors OR only warnings. They'll also be able to filter on warnings for a specific column with the new warning pills, and the error sidebar now separates warnings from errors.

Our newly launched column level error resolution actions in pane 4 allow your users will to access the predefined actions via error popover and via column header dropdowns. This gives them more flexibility and options when it comes to bulk fixing their data, enabling an even easier data cleaning experience!

The log details popover for Validation Webhooks now contains "rows sent" and "errors returned". This will aid you in more easily debugging validation webhook issues.

We've just launched a redesign to the all templates page that allows users to search and sort their templates by various criteria (eg. template key, label, created time) and filter templates by whether they were created from the API. Our goal is to continue making it easier and much faster for you to find a template they are looking for, especially for organizations with a large amount of dynamic templates.

We've added a customization that allows customers to add a maximum row limit that can be imported, and they can also add an optional custom header and description message for this error. When this customization is active and there are more rows than the specified limit, we will display an error in the importer and block the user from continuing with the import.

We've added a customization option that allows you to add education widgets to your importer! This enables you specify different widgets for each of the 4 Importer panes, have it default open or closed, and supports markdown.

We're excited to roll out environment scopes for API keys, which enables those keys to only access embeds in the prescribed environment. This helps customers uplevel the security of their organization by ensuring that their developers' local and staging environments should not have access to customer PII.

The cell popover for errors and warnings with suggestions now has a new button, "Accept for X cells". Clicking this button will accept all suggestions for cells in the column that have exactly 1 suggestion, making it even easier for your users to clean their files. The button will appear for users if there are at least 2 cells in the column which have exactly 1 suggestion.

With Picklist Descriptions, you can now use template overrides to set descriptions for each individual picklist option. These will be displayed in each dropdown of the OneSchema importer:

- Picklist mapping

- Picklist cell editing

- Picklist error popovers to replace all

These 3 improvements to picklists help customers whose use cases require long picklist values to be inputted:

1. Picklist pills will now truncate properly with a tooltip on hover to show the full value
2. The base width of the dropdown has just naturally been increased 20% across the board
3. The width of the dropdown will now actually increase if the column width increases

This new customization option under the "User Education" tab enables an informational sidebar on the mapping pane for your users. This will display a green check next to columns that have been mapped, and update dynamically as users select their mappings.

Users now have the ability to generate a sample test file for a template, eliminating the need for a file on hand to experience the importer. The button to generate a sample file lives can be found in the sandbox preview below the importer. The generated data will mostly conform with the template column options, but the data may not be 100% valid according to the template.

We've launched an update to our number autofixer, which can now handle negative numbers in account format. You can utilize this to automatically correct entries formatted as (100), and automatically change them to -100.

Our new Alternative Picklist Names feature enables you to specify one or more "alternative_names" for each picklist value via template overrides. If any of the alternative names appear in the uploaded file, they will automatically be mapped to the picklist value.

The number data type now has a new selection for the format, either be "US" (the default), or "EU". The EU number data type uses "," as the decimal separator and "." as the thousand separator.

The external API keys page has been updated so every user can see all external API keys in their organization. With these changes, a user can create multiple keys, set a label, and see when an API key was last used. In addition, deleting a user also now does not delete any API key(s) created by that user.

OneSchema now supports Fullview as a screen recording provider, allowing customers to analyzing recordings of their customers using OneSchema and optimize the experience.

Customers can now use the "Required Column Groups" feature to set that at least one column in a group must be mapped.

Our new Boolean data type feature allows users to define true and false values more easily.

You can now set specific colors for each picklist option! A list of 10 default options are provided, but exact HEX values can be used as desired.

Customers can now set environment variables in webhook keys. This helps customers who want to keep their secret keys isolated across different environments.

OneSchema Pipelines lets non-technical team members (account managers, operations) setup recurring CSV integrations with your customers’ complex data feeds without engineers getting involved. Map, transform, and ingest CSV files via SFTP, API, or email without needing to write a single line of code.

Customers can now select which environments to push when creating dynamic templates.

Customizations and Templates determine the behavior of OneSchema Importers. Using overrides can allow specific behavior for individual importing sessions. Customers now have the ability to define validation hooks in template overrides.

We've launched a feature to split Historical Matching into User-specific and Org-level matching. Previously, this only worked on the org-level. This helps customers whose users are differentiated enough that they do not want to have cross-user mappings be saved.

Customers can now use environment variables in Importer Webhooks

Environments allow you to safely push and validate changes to templates in stages to align with the environments in your deploy process.

OneSchema automatically sets up environments for Production, Staging, and Development. See our guide on custom environments to set up custom environments.

We’ve made improvements to our Template Overrides functionality by adding the ability to add and remove columns from the overrides.

We’ve made improvements to our custom code transformations and validations, also known as OneSchema Code Hooks. These Code Hook upgrades aim to greatly enhance both how your team builds custom functions that support your company’s unique business logic, as well as how your end-users experience the OneSchema Importer.

A new post-upload hook now exists for transposing (swapping the rows and columns) of a file.

To better support end users with bulk error resolution, we’ve improved our copy and paste functionality on the Review & Finalize pane to enable multiple cell copying and pasting.

We’ve added UI for end users to immediately filter for all rows, only rows with errors, or only clean rows.

String Replacements allow you to change the headers and buttons of every step of the importer. This can be helpful if there’s an existing string inside of the importer flow that you feel could be edited to better fit your existing brand (or use case).

For some customers, an end user deleting a row of data prior to import can break their entire flow. We’ve added a customization option that allows you granular control over how and if the end user should be able to delete rows from the Review & Finalize pane.

Admins can now specify the particular date format that’s expected for template columns instead of relying on OneSchema’s date detection (which defaults to a month, day, year interpretation). This impacts scenarios where a file’s uploaded date column contains a majority of ambiguous dates, and the format is not MM/DD/YY (e.g. 01/02/2022 can be either January 2nd, 2022 or February 1st, 2022).

Custom columns can now be supported inside of validation webhooks. Review our updated docs to understand the different use cases, how to set up custom columns, and example JSON POST/responses.

To provide further customization of our Upload pane, the optional message box can now be customized using Markdown. Our customers can insert URLs to additional data import resources for the end user.

JSON object is newly available as a data type validation for template columns.

Customers can now choose to return a list of suggestions from a validation webhook. End users will be prompted to select one of the suggestions as a part of the error resolution process.

OneSchema’s money data type validation and autofix feature now supports the Pound (£), the Euro (€), and the Yen (¥) currency symbols.

The error messaging for the Number data type and Money data type has been improved so end users can better understand why the value is invalid and how to fix it.

Rather than sending batched rows of data to a customer webhook, sheet metadata can now be sent via webhook. This is significantly faster and also enables you to directly use the metadata to retrieve data via external API (e.g. GET rows for paginated JSON or POST sheets for S3 URL download of CSV/excel/JSON).

Since we’ve started building OneSchema, one of the deepest pain points we’ve seen in our customer base is building and maintaining recurring spreadsheet import workflows. Expensive engineering teams have to write brittle scripts to ingest the data, and spend countless engineering months maintaining validations to make sure all customer data is being imported correctly.

In the case of a failure, it’s extremely painful for the technical team to track down the root cause of the failure, and all the while the customer is frustrated because their data isn’t up-to-date in your product. OneSchema Headless empowers engineering teams to leverage OneSchema’s mapping, validation, and error resolution capabilities to painlessly build custom integrations with a wide variety of data sources, like SFTP/S3 file drops, CSV email attachments, messy API data, and more.

Users can now see logs of their importer and validation webhooks (up to the past 14 days). This should enable users to better debug their webhooks when they run into errors, and enable your teams to monitor webhook activity.

Customers can now instruct OneSchema to send processed files directly to their own presigned URL.

Customers now have the option of having OneSchema instances hosted in Canada.

Customers now have the option of having OneSchema instances hosted in Australia.

Because our customers span a variety of industries, we often see workflows that come with unique business logic built into their specific datasets.

To make OneSchema even more flexible for these custom use cases, we’ve created OneSchema Code Hooks. Code Hooks empower your engineering team to generate tailored functions to reformat, transform, and/or validate data specific to your business's needs inside of the importer flow.

Similar to historical column mapping, historical picklist option mapping remembers mappings and pre-fills the values for subsequent uploads. This behavior is active if the “Historical match” customization in the “Map columns” section is set.

Sessions can now be resumed in case a user's browser crashes or they do not finish an import. To enable this feature, update your SDK to the latest version(0.3.3) and pass in the param saveSession as true. Then sessions using the same userJwt and template key on the same browser will be prompted on resume as seen in the screenshot below.

OneSchema templates just got even more powerful.

• With the alternative mappings feature, you can tell OneSchema which mappings you’re expecting to see so that your user won’t have to map them manually.
• Use fill default values to automatically fill in empty cells instead of leaving them blank
• Check out the flexible options on our data type validations that let you validate everything from digits after the decimal to excluding special characters.

We've also redesigned the template column creation modal to better organize all the different data validations options and to make template creation easier for you.

You can now host OneSchema inside of your AWS or Azure cloud environment. The self-hosted model provides full isolation of data in your own cloud, and is best for customers who are handling government data (GovCloud), or other extremely sensitive data with unique contractual / compliance requirements. OneSchema will deploy updates and maintenance to the platform through an IAM user.

A dashboard with granular UI customizations is now available for you to make the OneSchema Importer look and feel like your existing product UI! We’ve also updated our default icon set and illustrations to be more brand-neutral, to help OneSchema’s Importer fit better in any product, even without customizations.

A dashboard with granular UI customizations is now available for you to make the OneSchema Importer look and feel like your existing product UI! We’ve also updated our default icon set and illustrations to be more brand-neutral, to help OneSchema’s Importer fit better in any product, even without customizations.

With our Branding Suite, you can now access 20+ customization options, including:

• Primary, secondary, and background colors
• Buttons
• Success, Warning, and Error states
• Custom illustrations
• Font family and font colors

Watch this 3 minute step-by-step demo of the OneSchema Branding Suite that demonstrates how to fully customize your importer's color, font, and more.