Database Operations Command

Fri Oct 31, 2014 10:56 pm

Hello,
I'm trying to update a row in a collection server-side and am using this code:

var XHRResponse = XHR.send("PUT", "URL_GOES_HERE", {
"headers": {
"X-Appery-Database-Id": dbId,
"X-Appery-Master-Key": masterKey,
"Content-Type": "application/json"
},
"parameters": {
"where": "{'userid':'g45g4g45g'}",
"operations":"{'$set':{'user_team':'sdfsdfsdfsdf'}}"
}
});

It doesn't seem to be working, how should the operations command be used?

Sat Nov 01, 2014 6:24 pm

Hi Anton,

Your command seems to be OK - we will test this additionally and we let you know.

Mon Nov 03, 2014 4:41 am

Hi Anton,

Here is worked code:

pre

var responseBody = {},
requestParams = {},
paramKeys = request.keys();

for (var key = 0; key < paramKeys.length; key++) {
requestParams[paramKeys[key]] = request.get(paramKeys[key]);
}

//Settings:
var dbId = "52fd3d06xxxxxxxx9917";
var collectionName = "dogs";
var itemId = "53ba2599e4b09f5c7d50390f";

var bodyObject = {
"operations": '{"$set":{"toggle":true}}',
"where": '{"name":"one"}'
};

var XHRResponse = XHR.send("PUT", "https://api.appery.io/rest/1/db/collections/" + collectionName + "/" + itemId + "", {
"headers": {
"X-Appery-Database-Id": dbId,
"Content-Type": "application/json"
},

"body": JSON.stringify(bodyObject)

});

if (XHRResponse.status != 200) {
responseBody.message = "message: " + XHRResponse.body + "\ncode: " + XHRResponse.status;
console.log(XHRResponse.body);
response.error(responseBody, "application/json");
} else {
console.log("Success: " + JSON.stringify(XHRResponse.body[0]));
response.success();
}

/pre

Regards.

Tue Nov 04, 2014 5:37 am

Thanks, it's not quite what was needed, but I found another answer by you on the forum that works wonderfully (updating row without getting _id value first), code copied below:

var responseBody = {},
requestParams = {},
paramKeys = request.keys();
for (var key = 0; key < paramKeys.length; key++) {
requestParams[paramKeys[key]] = request.get(paramKeys[key]);
}
var dbId = "53eae11fe4b0d1037ddcbeed";
var bodyObject = {
"where": {"name":"joe"},
"operations": {"$set":{"value":"42_1"}}
};
var XHRResponse = XHR.send("PUT", "https://api.appery.io/rest/1/db/colle...", {
"headers": {
"X-Appery-Database-Id": dbId,
"Content-Type": "application/json"
},
//"body": {
// "where": '{"name":"joe"}',
// "operations": '{"$set":{"value":"42"}}'
//}
"body": JSON.stringify(bodyObject)
});
console.log(XHRResponse);

Wed Nov 05, 2014 1:42 am

Hi Anton,

Glad you get it work.

Thanks for your update.

Regards.