I’m trying to insert data to my Wix collection using the API. I’m using a POST function and am posting a JSON document. It’s supposed to simply add a new row to a database containing 1 value.
Here is the http-functions.js which I can trigger without issues (it’s more or less a copy of the example from the documentation):
import {created, serverError} from 'wix-http-functions';
import wixData from 'wix-data';
export function post_peopleCount(request) {
let options = {
"headers": {
"Content-Type": "application/json"
}
};
// get the request body
return request.body.text()
.then( (body) => {
// insert the item in a collection
return wixData.insert("NumberOfPeopleDB", JSON.parse(body));
} )
.then( (results) => {
options.body = {
"inserted": results
};
return created(options);
} )
// something went wrong
.catch( (error) => {
options.body = {
"error": error
};
return serverError(options);
} );
}
The database looks like this:
and the JSON I am posting looks like this:
But the Error I am getting is:
But the permissions I have set for the collection is:
Do you know why I might be getting that “WD_PERMISSION_DENIED” and 500 Server Error? (The data does not get entered.)
Thanks!