cycle through all users in database
Speedway. Shared.
Catch up wih the Appery.io community on our forum. Here you'll find information on the lastest questions and issues Appery.io developers are discussing.
https://forum.appery.io/
Speedway. Shared.
And please specify the service name that you're testing?
get_user
Thanks, Jack. We testing it.
Hi Jack,
You use " X-Appery-Database-Id" parameter in headers.
But correct is: "X-Appery-Database-Id"
You need to delete whitespace in the beginning on the this parameter name.
Regards.
That solved my problem. Thank you.
Hello, I have tried the following javascript:
pre
/* loop through users */
var users = Apperyio.storage.users.get();
var arrayLength = users.length;
var databaseId = ThePlough_settings.database_id;
console.log('database id = ',databaseId);
var sessionToken = Apperyio.storage.sessionToken.get();
console.log('session token = ', sessionToken);
for (i = 0; i < arrayLength; i++) {
console.log(users.userId);
Code: Select all
/* updateUsers.execute({body : {where : {user_id : users[i].userId}, operations : {$set : {events_available : true} } } }); */
updateUsers.execute({
data:
{
"events_available" : true,
"where" : {"user_id" : users[i].userId}
},
headers:
{
"X-Appery-Session-Token": sessionToken,
"X-Appery-Database-Id": databaseId,
"Content-Type": "application/json"
}
});
}
/pre
I am getting the following output in networking tab:
pre
GENERAL
Remote Address:54.221.205.233:443
Request URL:https://api.appery.io/rest/1/db/users/
Request Method:PUT
Status Code:405 Method Not Allowed
RESPONSE HEADERS
Access-Control-Allow-Credentials:true
Access-Control-Allow-Origin:http://appery.io
Connection:keep-alive
Content-Type:application/json
Date:Tue, 04 Aug 2015 08:55:47 GMT
Server:nginx
Transfer-Encoding:chunked
REQUEST HEADERS
Accept:application/json, text/javascript, /; q=0.01
Accept-Encoding:gzip, deflate, sdch
Accept-Language:en-GB,en-US;q=0.8,en;q=0.6
Connection:keep-alive
Content-Length:72
Content-Type:application/json
Host:api.appery.io
Origin:http://appery.io
Referer:http://appery.io/app/view/e1041392-556e-4f5d-93af-c73ab11d735a/EventsAdministration.html
User-Agent:Mozilla/5.0 (Windows NT 6.3; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/44.0.2403.125 Safari/537.36
X-Appery-Database-Id:55757b65e4b0c5383ba566bf
X-Appery-Session-Token:ccf1f621-79b3-4472-8b4e-b09fa6239acc
REQUEST PAYLOAD
{"events_available":true,"where":{"user_id":"55758504e4b0b40eb7813c50"}}
/pre
I have run out of ideas. I wish that the documentation had more examples. It is not very clear.
I am not really sure where I should use quotes or not
This was my last attempt:
pre/* loop through users */
var users = Apperyio.storage.users.get();
var arrayLength = users.length;
var databaseId = ThePlough_settings.database_id;
console.log('database id = ',databaseId);
var sessionToken = Apperyio.storage.sessionToken.get();
console.log('session token = ', sessionToken);
for (i = 0; i < arrayLength; i++) {
console.log(users.userId);
Code: Select all
/* updateUsers.execute({body : {where : {user_id : users[i].userId}, operations : {$set : {events_available : true} } } }); */
/* updateUsers.execute({
data:
{
"events_available" : true,
"where" : {"user_id" : users[i].userId}
},
headers:
{
"X-Appery-Session-Token": sessionToken,
"X-Appery-Database-Id": databaseId,
"Content-Type": "application/json"
}
}); */
updateUsers.execute({
body:
{
where : {"user_id" : users[i].userId},
operations : {$set : {"events_available" : true}}
},
headers:
{
"X-Appery-Session-Token": sessionToken,
"X-Appery-Database-Id": databaseId,
"Content-Type": "application/json"
}
});
}/pre
output is:
Replied via regular email.