Can't update a foreign key value

[alprotasov]

Hello!

I have a foreign key field: user = Column(Integer(), ForeignKey('clean_controller.id'))

When I try to make a PATCH/PUT request with the request body {"user": 11}

I get HTTP/1.0 422 UNPROCESSABLE ENTITY There is a clean_controller table and there is a row with id 11 in it. class CleanPoint(CommonColumns): tablename = 'clean_point' id = Column(Integer(), primary_key=True, autoincrement=True) ....

What is the correct way to update it?

[dkellner]

The response body should contain more information on why the validation failed, can you provide that one, too?

One thing that could be the problem: you're referring to clean_controller but your example only contains clean_point.

[alprotasov]

Sorry. Copy-pasted incorrect class. class CleanController(CommonColumns): tablename = 'clean_controller' id = Column(Integer(), primary_key=True, autoincrement=True) name = Column(VARCHAR(30))

And the error is {"_issues": {"user": "unknown field"}, "_status": "ERR"}

After I removed FK from the field it works fine. I mean user = Column(Integer())

[dkellner]

You'll need to add a relationship too, e.g. as in https://github.com/pyeve/eve-sqlalchemy/blob/master/examples/many_to_one/many_to_one/domain.py . At the moment plain ForeignKeys are not exposed by the API.