Question:
We're trying to setup workday connection in DEV v2021, connection is successful but job is failing with the below error message.
We followed workday connector guide 2.0 for creating a connection.
Error - Error parsing parameter HR_IMPORT_JSON -
Error parsing JSON
Connection Json used:
{
"authentications": {
"login": {
"authType": "basic",
"properties": {
"USERNAME": "User",
"PASSWORD": "",
"PASSWORD_TYPE": "PasswordText",
"REQUESTPARAMS": {
"CONTENT-TYPE": "text/xml;charset=UTF-8",
"Connection": "Keep-Alive",
"Keep-Alive": "timeout=600, max=1000"
}}}}}
IMPORT JSON
{
"CONNECTION1": "clientnamewebservice",
"REQUESTXML1": "<soap:Envelope xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:soap=\"http://schemas.xmlsoap.org/soap/envelope/\"> <soap:Body> <Login xmlns=\"http://www.clientname.com/\"> <username>${USERNAME}</username> <password>${PASSWORD}</password> </Login> </soap:Body> </soap:Envelope>",
"COOKIEOPTIONS1": "SAVEFROMRESPONSE",
"REQUESTPARAMS1": {
"Content-Type": "text/xml; charset=utf-8",
"SOAPAction": "<specify SOAP action>"
},
"RESPONSEDATAPATH1": "Body.LoginResponse",
"RESPONSEMAPPING1": {
"TOKEN": "LoginResult"
},
"CONNECTION2": "clientnamewebservice",
"REQUESTXML2": "<soap:Envelope xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:soap=\"http://schemas.xmlsoap.org/soap/envelope/\"> <soap:Body> <getUsersInAccount xmlns=\"http://www.clientname.com/\"> <token>${TOKEN}</token> <offset>0</offset> <limit>1000</limit> </getUsersInAccount> </soap:Body> </soap:Envelope>",
"COOKIEOPTIONS2": "SENDFROMSAVED",
"REQUESTPARAMS2": {
"Content-Type": "text/xml; charset=utf-8",
"SOAPAction": "<specify SOAP action>"
},
"RESPONSEDATAPATH2": "Body.getUsersInAccountResponse.getUsersInAccountResult.UserObject",
"RESPONSETOTALRESULTS2": "PAGINATE",
"USERMAPPING2": "USERNAME:username,EMAIL:email"
}
SUGGESTION: The connection name in Import JSON should be the same as defined in Connection json. Can you update the same and try.
Name defined in Connection is
{
"authentications": {
"login": {
and defined in Import is
"CONNECTION1": "clientnamewebservice",
"CONNECTION2": "clientnamewebservice",