I'm struggling a bit with the API for a relation. When I include the ID field of the relation in the list of active columns for an API and setup that ID field under record lookups:
- the GET request returns one or more instances of the relation including the ID field
- but for creating records using the POST request I have to supply the ID field value (!) in the request body
If I remove the ID field from the list of active columns:
- I can POST a new record without the ID
- but the GET request doesn't return the ID
Maybe I got something wrong on this - but typically with a REST-like API you can POST without ID - especially when the underlying database can assign IDs for the records - and it still return the IDs, so you can use the returned IDs to get or update single records.
Thanks, Oli