Skip to main content
S
Saiteja7-Bedrock
7-Bedrock
July 29, 2022
Solved

HOW TO CONVERT JSON INFOTABLE TO MSSQL TABLE

  • July 29, 2022
  • 1 reply
  • 1135 views

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

 

Best answer by Saiteja

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;

 

1 reply

V
24-Ruby III
VladimirN24-Ruby III
24-Ruby III
July 29, 2022

 Hi,

 

There was a similar issue before:

    S
    Saiteja7-BedrockAuthorAnswer
    7-Bedrock
    August 2, 2022

    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;

     

    Terms & ConditionsAccessibility statement