cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - When posting, your subject should be specific and summarize your question. Here are some additional tips on asking a great question. X

HOW TO CONVERT JSON INFOTABLE TO MSSQL TABLE

Saiteja
7-Bedrock

HOW TO CONVERT JSON INFOTABLE TO MSSQL TABLE

The error message I receive is: unable to convert from org.Mozilla.javascript,uniqueTag to info table.
var json=me.jsondata_JS();
//result = JSON;


for (let i=0;i<json.lenght;i++){
var con=me.jstsql({

id: json[i].id /* INTEGER */,
email: json[i].email /* STRING */,
first_name: json[i].first_name /* STRING */,
last_name: json[i].last_name /* STRING */,
avatar: json[i].avatar /* STRING */

});
result = con;
}

 

ACCEPTED SOLUTION

Accepted Solutions

Answer

 

let con;
let C=me.jsondata_JS();
//result = json;

for ( let i=0;i<=C.length;i++ ){
con=me.jstsql({

id:C[i].id,
email: C[i].email ,
first_name: C[i].first_name,
last_name: C[i].last_name,
avatar: C[i].avatar
});
}
result = con;

 

View solution in original post

2 REPLIES 2
VladimirN
24-Ruby II
(To:Saiteja)

 Hi,

 

There was a similar issue before:

Answer

 

let con;
let C=me.jsondata_JS();
//result = json;

for ( let i=0;i<=C.length;i++ ){
con=me.jstsql({

id:C[i].id,
email: C[i].email ,
first_name: C[i].first_name,
last_name: C[i].last_name,
avatar: C[i].avatar
});
}
result = con;

 

Announcements


Top Tags