Python Field validation example
This script validates that certain fields are in the POST request when creating records. If not, an exception is raised and 500 error returned to the client. If the script exists normally with no exception being thrown then the records will be written to the database and the post-process script, if any, will be run.
# POST /api/v2/db/_table/account triggers script db._table.account.post.pre_process # This script runs BEFORE records are written to the db. payload = event['request']['payload']; if 'annual_revenue' not in payload: raise ValueError('Missing field annual revenue'); if payload['annual_revenue'] <= 0: raise ValueError('Annual Revenue must be > 0');