Open wingechr opened 3 years ago
It works if you use "is_nullable": False
instead.
Good catch! should be "False" of course. I will update this in the API tutorial series.
Cool, thanks a lot. If you update the tutorial, I have something else that you may want to include and is currently not documented, as far as i could see:
to add (single columns) foreign keys with create table api request, you cannot use the constraints
section, instead, you also add it to the column definition like so:
{
"name": "SOME_COLUMN_NAME",
"data_type": "SOME_DATA_TYPE",
"foreign_key": [{
"table": "SCHEMA.REFERENCED_TABLE",
"column": "REFERENCED_COLUMN"
}]
}
then we should also update the oep api readthedocs? I will include/update this in the tutorial :+1:
According to multiple tutorials, columns can be configured to not allow NULL values by adding
"is_nullable": "NO"
in the definition.This does not work.
Here is a complete example. I create a table and upload an empty record, then retrieve the data and get a record with a NULL value (None)