Unable to add or update column values using REST API

REST
1

I create a new table called Test. I created a new column called testcolumn of type INT. I use the REST interface to make the following request.

{
“isolationLevelEnum” : “READ_COMMITTED”,
“operations”: [
{
“operationType”: “CREATE”,
“table”: “Test”,
“payload”: {
“testcolumn”: 5
}
}
]
}

I get the following response
{
“created”: 1644882655000,
“testcolumn”: null,
“___class”: “Test”,
“ownerId”: null,
“updated”: null,
“objectId”: “A6113E0B-3D4E-4A84-B506-4B1D386C94F1”
}

I can never create the right value in the testcolumn. I have tested both int and string column types.

Also tried this by calling REST endpoint from python script - same problem. Am I setting up table wrong? Can you replicate?

Thanks

2

I just ran a request against your database using Advanced REST Client and it worked just fine (you can see the created record in your database):

Advanced REST client 2022-02-14 18-10-51
Advanced REST client 2022-02-14 18-10-511425×1055 121 KB

3

Thank you. That works!

My mistake was that I was using the URL https://…backendless.app/api/data/Test because that was in the REST Console. The GET and Delete functions work in the REST Console but the POST and PUT methods don’t seem to update the fields properly. Not sure if this was intended or not, but if not I hope it helps you. Thanks

4

the REST Console doesn’t support Transactions API. It works only with the basic CRUD.

1 Like