cycle through all users in database

Sat Aug 01, 2015 4:48 am

Speedway. Shared.

Sat Aug 01, 2015 8:49 pm

And please specify the service name that you're testing?

Sat Aug 01, 2015 8:56 pm

get_user

Sat Aug 01, 2015 9:07 pm

Thanks, Jack. We testing it.

Mon Aug 03, 2015 3:13 am

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.

Mon Aug 03, 2015 3:26 am

That solved my problem. Thank you.

Tue Aug 04, 2015 9:12 am

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&#46;execute({body : {where : {user_id : users[i]&#46;userId}, operations : {$set : {events_available : true} } } }); */ 

 updateUsers&#46;execute({ 
     data: 
     { 
         "events_available" : true,  
         "where" : {"user_id" : users[i]&#46;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.

Tue Aug 04, 2015 11:59 pm

I am not really sure where I should use quotes or not

Wed Aug 12, 2015 1:57 pm

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&#46;execute({body : {where : {user_id : users[i]&#46;userId}, operations : {$set : {events_available : true} } } }); */ 

 /* updateUsers&#46;execute({ 
     data: 
     { 
         "events_available" : true,  
         "where" : {"user_id" : users[i]&#46;userId} 
     }, 
     headers: 
     { 
         "X-Appery-Session-Token": sessionToken, 
         "X-Appery-Database-Id": databaseId, 
         "Content-Type": "application/json" 
     } 
 }); */ 

 updateUsers&#46;execute({ 
     body: 
     { 
         where : {"user_id" : users[i]&#46;userId}, 
         operations : {$set : {"events_available" : true}} 
     }, 
     headers: 
     { 
         "X-Appery-Session-Token": sessionToken, 
         "X-Appery-Database-Id": databaseId, 
         "Content-Type": "application/json" 
     } 
 });

}/pre

output is:

Thu Aug 13, 2015 11:47 am

Replied via regular email.