HOW TO CONVERT JSON INFOTABLE TO MSSQL TABLE

[Saiteja]

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;
}

[VladimirN]

 Hi,

There was a similar issue before:

• "Unable To Convert From org.mozilla.javascript.UniqueTag to INFOTABLE": https://community.ptc.com/t5/ThingWorx-Developers/Unable-To-Convert-From-org-mozilla-javascript-UniqueTag-to/td-p/514016 
• "Error - Unable To Convert From org.mozilla.javascript.Undefined to LOCATION": https://community.ptc.com/t5/ThingWorx-Developers/Error-Unable-To-Convert-From-org-mozilla-javascript-Undefined-to/td-p/512580 

[Saiteja · Accepted solution]

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;