|Custom regular expression
|Simple formatting checks (i.e. allowing commas and periods as decimal places, supporting multiple currency symbols).
|Checking data against your database, a third party data source, or writing custom validations in the language of your choice.
|Creating complex, performant custom validations entirely within OneSchema.
OneSchema supports custom regex in SQL format which can be selected in the data validations list when creating a new template column.
A validation webhook is a way to use an API endpoint to create a custom validator. OneSchema will pass data to a specified endpoint, and it can be validated against a database, a third party data source, or complex logic checks can be performed. OneSchema simply expects a response of errors and warnings.
Validation webhooks are configured on the template to which they apply. To add a webhook to a template, head to your templates page and click Details on the template you want to edit.
Select Validation webhooks in the left sidebar, followed by Add a new validation hook in the center of the screen.
Then enter a name, endpoint, and select which columns should be passed through. Optionally set a secret key for http basicauth and a bath size.
Then, fill in the relevant fields.
|Validation hook name
|The name of your webhook.
|The url to the endpoint which will receive the webhook call.
|Template column Keys
|The keys of the columns you wish to include with the webhook call. Only selected columns will be sent.
|An optional token used to authenticate the webhook call.
|The number of rows of data to include in each call.
To configure your endpoint on the backend, continue with our guide on validation webhooks.
In-memory code-hooks enable custom validation logic to be written within OneSchema's admin portal without the need to configure a backend webhook endpoint. Some example use cases include merging rows, splitting and merging columns, and multi-column uniqueness checks.
These hooks are extremely performant and reduce implementation complexity when compared to validation webhooks, allowing the entire validation process to be handled by OneSchema.
Note that in-memory code-hooks cannot make external calls, so if you need to validate against your database or a third-party source, you'll need to use a validation webhook.
Updated 5 months ago