Insert records on success event

Mon Feb 17, 2014 5:33 am

I've tried to invoke a create service in Javascript but it failed. Following is my code:

precodevar response = JSON.parse(localStorage.getItem("json_response"));
for (var i=0; i<response.data.length; i++) {
var createQuery2 = '{"hash"::' + response.data.hash + '"}';
var createQuery = '{"hash": "' + response.data.hash +
'","title": "'+ response.data.title +
'","ext": "'+ response.data.ext +
'","permalink": "'+ response.data.permalink +
'","views": "'+ response.data.views +
'","datetime": "'+ response.data.datetime +
'","date": "'+ response.data.date +
'","size": "'+ response.data.size +
'","created": "'+ response.data.created +
'","width": "'+ response.data[i].width +
'","animated": "'+ response.data[i].animated +
'","height": "'+ response.data[i].height +
'","source": "'+ response.data[i].source +
'","description": "'+ response.data[i].description +
'","subreddit": "'+ response.data[i].subreddit +
'","author": "'+ response.data[i].author +
'","score": "'+ response.data[i].score +
'","ups": "'+ response.data[i].ups +
'","downs": "'+ response.data[i].downs +
'","points": "'+ response.data[i].points +
'"}';
console.log(createQuery2);
create_data.execute({"data":JSON.stringify(createQuery2)});
create_data.execute({"data":JSON.stringify(createQuery)});
}
/code/pre
Please help me with the code. createQuery2 is just for debugging.

Mon Feb 17, 2014 8:13 am

Hi Ralph,

Do you want to write it to database? If yes, you should pass not the 'data' parameter but all the field you have in collection.

Mon Feb 17, 2014 8:43 am

Hi Katya,

Yes, I want to write into database. What if some of the fields are null? What should I input?

Mon Feb 17, 2014 8:44 am

Also, if I put a variable in execute script, the editor will indicate I have error.

e.g: create_data.execute({createQuery});

Mon Feb 17, 2014 9:01 am

One more question, do we need the data format to be the same as in the collection?

Mon Feb 17, 2014 10:39 am

Ralph,

You set parameters incorrectly. Take a look at here please: https://getsatisfaction.com/apperyio/...

Mon Feb 17, 2014 11:05 am

Hi Katya,

I tried with following code, but failed:

precodefor (var i=0; i<response.data.length; i++) {
var createQuery2 = '{"hash":' + response.data.hash + '"}';
var createQuery = '{"hash": "' + response.data.hash +
'","title": "'+ response.data.title +
'","ext": "'+ response.data.ext +
'","permalink": "'+ response.data.permalink +
'","views": '+ response.data.views +
',"datetime": "'+ response.data.datetime +
'","date": "'+ response.data.date +
'","size": '+ response.data.size +
',"created": '+ response.data.created +
',"width": '+ response.data[i].width +
',"animated": "'+ response.data[i].animated +
'","height": '+ response.data[i].height +
',"source": "'+ response.data[i].source +
'","description": "'+ response.data[i].description +
'","subreddit": "'+ response.data[i].subreddit +
'","author": "'+ response.data[i].author +
'","score": '+ response.data[i].score +
',"ups": '+ response.data[i].ups +
',"downs": '+ response.data[i].downs +
',"points": '+ response.data[i].points +
'}';
console.log(createQuery);
create_data.execute({
data: createQuery
});
}/code/pre

Console shows createQuery as below:
precode
{"hash": "EdV9edq","title": "Strawberries [2560x1440]","ext": ".jpg","permalink": "/r/wallpapers/comments/1xshj3/strawberries_2560x1440/","views": 3160,"datetime": "2014-02-13 09:29:12","date": "2014-02-13","size": 227120,"created": 1392283752,"width": 2560,"animated": "0","height": 1440,"source": "null","description": "null","subreddit": "wallpapers","author": "TheFinnishCyborg","score": 1308,"ups": 1,"downs": 0,"points": 1} /code/pre

Mon Feb 17, 2014 7:08 pm

Hello!
[quote:]do we need the data format to be the same as in the collection?[/quote] yes. If there is string, you have to pass string; if there is date, you have to pass date and so on. Please pay attention on fields names, they are case sensitive.

What error did you get from service?

Tue Feb 18, 2014 12:43 am

Hi, I tried JSON.stringify() but still can not import data into database. There is no error shown. There are blank records in my database after I run the script. My script is (after adjusted with JSON.stringify):

precode
var response = JSON.parse(localStorage.getItem("json_response"));
for (var i=0; i<response.data.length; i++) {
var createQuery2 = '{"hash":' + response.data.hash + '"}';
var createQuery = '{"hash": "' + response.data.hash +
'","title": "'+ response.data.title +
'","ext": "'+ response.data.ext +
'","permalink": "'+ response.data.permalink +
'","views": '+ response.data.views +
',"datetime": "'+ response.data.datetime +
'","date": "'+ response.data.date +
'","size": '+ response.data.size +
',"created": '+ response.data.created +
',"width": '+ response.data[i].width +
',"animated": "'+ response.data[i].animated +
'","height": '+ response.data[i].height +
',"source": "'+ response.data[i].source +
'","description": "'+ response.data[i].description +
'","subreddit": "'+ response.data[i].subreddit +
'","author": "'+ response.data[i].author +
'","score": '+ response.data[i].score +
',"ups": '+ response.data[i].ups +
',"downs": '+ response.data[i].downs +
',"points": '+ response.data[i].points +
'}';
console.log(JSON.stringify(createQuery));
create_data.execute({
data: JSON.stringify(createQuery)
});
}
/code/pre

Tue Feb 18, 2014 12:53 am

Thank you all of you. I found the solution. I should use following code instead of joining each item manually.
precodevar createQuery = response.data/code/pre