Hey all,
I am trying to delete a relation, but it always results in an error that doesn’t make sense to me, so I’m assuming I am misunderstanding how to properly delete a relation. I am following Delete Relation using condition - Backendless REST API Documentation in the docs, which seems to be doing what I want.
So I have a table called Games and another called Timespans.
Games looks like this:
and Timespan looks like this:
So as you can see, a game has a 1:N relation with timespan and I want to be able to delete one (or any amount really) from a game.
As a simple example, for a single delete I send out the following:
"https://springloop.springlab.nl/api/data/Games/38FA2189-0D8D-4FA7-BD60-0A814B5BC0E6/timespan?whereClause=name%3dZomer"
From what I understand, this should delete the relation from the game with the ID in the timespan column, where the name of the timespan is Zomer.
However, I get the following error:
"code":1054,"message":"Column 'Zomer' does not exist in table 'Timespans'","errorData":{}}
Any pointer on what I am doing wrong, because it seems I am misunderstanding the documentation.
Thanks!