Validating API Payloads in Python
python
Description
When using the /_table/{table_name} endpoint you can insert a new record into a database backed by a DreamFactory generated database API. By default the underlying database constraints will serve as a validation backstop, meaning if a required (not nullable) field is not provided, the database will throw an error and DreamFactory will in return return a 500 status code to the client. Alternatively, you might however wish to customize both the validation logic and error response. This can be achieved by using DreamFactory's scripting engine. To do so you can add custom logic to the POST endpoint's pre-process event handler, meaning the custom code will execute before the destination data source is contacted.
Code
payload = event.request.payload
if(payload):
if 'first_name' not in payload:
raise ValueError('First name field missing')
if payload.first_name == '':
raise ValueError("First name field required")
