Error while creating account DB Connector

[savuser17]

Hello,

I am getting the following error while trying to create account through DB Connector.

Error while creating account - 6308225-Error parsing JSON

Here is the code. It has multiple commands separated by semicolon:

{
"createaccountqry": [
"INSERT INTO table1 (USER_ID,EMP_TYPE_CD, USER_FULL_NM, USER_EMAIL_AD_TX, MGR_EMAIL_AD_TX) VALUES ('${user.systemUserName}', 'E', '${user.displayname}', '${user.email}', '${usermanager.email}')";
INSERT INTO table2 (USER_ID, TRAV_PRTR_TYPE_CD) VALUES('${user.systemUserName}', '004');
INSERT INTO table3 (USER_ID, GRP_ID) VALUES ('${user.systemUserName}', '1');
INSERT INTO table3 (USER_ID, GRP_ID) VALUES ('${user.systemUserName}', '13');
INSERT INTO table4 (USER_ID, TRAV_RGN_ID) VALUES ('${user.systemUserName}', '***');
INSERT INTO table4 (USER_ID, TRAV_RGN_ID) VALUES ('${user.systemUserName}', 'AFR');
INSERT INTO table4 (USER_ID, TRAV_RGN_ID) VALUES ('${user.systemUserName}', 'APA');
INSERT INTO table4 (USER_ID, TRAV_RGN_ID) VALUES ('${user.systemUserName}', 'EUR');
INSERT INTO table4 (USER_ID, TRAV_RGN_ID) VALUES ('${user.systemUserName}', 'LAC');
INSERT INTO table4 (USER_ID, TRAV_RGN_ID) VALUES ('${user.systemUserName}', 'USC');
INSERT INTO table4 (USER_ID, TRAV_RGN_ID) VALUES ('${user.systemUserName}', 'MDE');
INSERT INTO table5 (USER_ID, PRODUCT_ID) VALUES('${user.systemUserName}', 3);
INSERT INTO table6 (USER_ID, TOP_LVL_CORP_ID,INCL_EXCL_CD) VALUES ('${user.systemUserName}', '${requestAccessAttributes.get('Client')}', 'I');
]
}

Does it look like anything off with the json? Syntactically it passed muster in json validator but error persists.

Any help is appreciated. 

Thanks,

Seemran Biswal

[pmahalle]

HI @savuser17 ,

Can you try below JSON and check once:

{
"createaccountqry": [
"INSERT INTO table1 (USER_ID,EMP_TYPE_CD, USER_FULL_NM, USER_EMAIL_AD_TX, MGR_EMAIL_AD_TX) VALUES ('${user.systemUserName}', 'E', '${user.displayname}', '${user.email}', '${usermanager.email}');",
"INSERT INTO table2 (USER_ID, TRAV_PRTR_TYPE_CD) VALUES('${user.systemUserName}', '004');",
"INSERT INTO table3 (USER_ID, GRP_ID) VALUES ('${user.systemUserName}', '1');",
"INSERT INTO table3 (USER_ID, GRP_ID) VALUES ('${user.systemUserName}', '13');",
"INSERT INTO table4 (USER_ID, TRAV_RGN_ID) VALUES ('${user.systemUserName}', '***');",
"INSERT INTO table4 (USER_ID, TRAV_RGN_ID) VALUES ('${user.systemUserName}', 'AFR');",
"INSERT INTO table4 (USER_ID, TRAV_RGN_ID) VALUES ('${user.systemUserName}', 'APA');",
"INSERT INTO table4 (USER_ID, TRAV_RGN_ID) VALUES ('${user.systemUserName}', 'EUR');",
"INSERT INTO table4 (USER_ID, TRAV_RGN_ID) VALUES ('${user.systemUserName}', 'LAC');",
"INSERT INTO table4 (USER_ID, TRAV_RGN_ID) VALUES ('${user.systemUserName}', 'USC');",
"INSERT INTO table4 (USER_ID, TRAV_RGN_ID) VALUES ('${user.systemUserName}', 'MDE');",
"INSERT INTO table5 (USER_ID, PRODUCT_ID) VALUES('${user.systemUserName}', 3);",
"INSERT INTO table6 (USER_ID, TOP_LVL_CORP_ID,INCL_EXCL_CD) VALUES ('${user.systemUserName}', '${requestAccessAttributes.get('Client')}', 'I');"
]
}

[Vedanth-BK]

Hi @savuser17 

Could you please try with the below 

{
  "createaccountqry": [
    "INSERT INTO table1 (USER_ID,EMP_TYPE_CD, USER_FULL_NM, USER_EMAIL_AD_TX, MGR_EMAIL_AD_TX) VALUES ('${user.systemUserName}', 'E', '${user.displayname}', '${user.email}', '${usermanager.email}');",
    "INSERT INTO table2 (USER_ID, TRAV_PRTR_TYPE_CD) VALUES('${user.systemUserName}', '004');",
    "INSERT INTO table3 (USER_ID, GRP_ID) VALUES ('${user.systemUserName}', '1');",
    "INSERT INTO table3 (USER_ID, GRP_ID) VALUES ('${user.systemUserName}', '13');",
    "INSERT INTO table4 (USER_ID, TRAV_RGN_ID) VALUES ('${user.systemUserName}', '***');",
    "INSERT INTO table4 (USER_ID, TRAV_RGN_ID) VALUES ('${user.systemUserName}', 'AFR');",
    "INSERT INTO table4 (USER_ID, TRAV_RGN_ID) VALUES ('${user.systemUserName}', 'APA');",
    "INSERT INTO table4 (USER_ID, TRAV_RGN_ID) VALUES ('${user.systemUserName}', 'EUR');",
    "INSERT INTO table4 (USER_ID, TRAV_RGN_ID) VALUES ('${user.systemUserName}', 'LAC');",
    "INSERT INTO table4 (USER_ID, TRAV_RGN_ID) VALUES ('${user.systemUserName}', 'USC');",
    "INSERT INTO table4 (USER_ID, TRAV_RGN_ID) VALUES ('${user.systemUserName}', 'MDE');",
    "INSERT INTO table5 (USER_ID, PRODUCT_ID) VALUES('${user.systemUserName}', 3);",
    "INSERT INTO table6 (USER_ID, TOP_LVL_CORP_ID,INCL_EXCL_CD) VALUES ('${user.systemUserName}', '${requestAccessAttributes.get('Client')}', 'I');"
  ]
}

[AmitM]

Hi @savuser17 ,

You can use https://jsonlint.com/ to validate your JSON formats. You are not using double qoutes properly. Both Vedanth and pmahalle queries might work if no logical mistake.

Thanks,

Amit

If this answers your query, Please ACCEPT SOLUTION and give KUDOS.