Mapping attribute on soap CONNECTOR

[RMohanty]

Hi,

I'm using the SOAP connector for one of my integrations with Saviynt. 

'ValidFrom' attribute is mapped to saviynt accounts table from 'StartDate' attribute from Response.

ACCOUNTS_IMPORT_JSON

{
"CONNECTION1": "clientnamewebservice","REQUESTXML1": "<soapenv:Envelope xmlns:soapenv=\"http://schemas.xmlsoap.org/soap/envelope/\" xmlns:soap=\"http://guidewire.com/ws/soapheaders/\" xmlns:user=\"http://guidewire.com/pc/com/acg/webservices/user/UserAPI\"><soapenv:Header><soap:gw_locale>en_US</soap:gw_locale><soap:gw_language>en_US</soap:gw_language><soap:authentication><soap:username>oig_admin</soap:username><soap:password>breU5bkyDjVn</soap:password></soap:authentication></soapenv:Header><soapenv:Body><user:searchByTimestampPidPattern><user:timestamp>2023-03-01 11:06:28 AM</user:timestamp><user:letter>p</user:letter></user:searchByTimestampPidPattern></soapenv:Body></soapenv:Envelope>",
"REQUESTPARAMS1": {"Content-Type": "text/xml;charset=UTF-8","SOAPAction": ""},"RESPONSEDATAPATH1": "Body.searchByTimestampPidPatternResponse.return.Users.Entry",
"ACCOUNTMAPPING1":"Name:UserName,accountID:UserName,CustomProperty21:Status,CustomProperty22:Telephone,VALIDFROM:StartDate,DisplayName:FirstName,CustomProperty23:LastName,CustomProperty24:LicenseStates",
"ENTITLEMENTMAPPING1": {
"Roles": "Roles.Entry"
}
}

I am getting error message like:

WARNING [quartzScheduler_Worker-7] groovy.sql.Sql.handleError Rolling back due to: Data truncation: Incorrect datetime value: '2021-09-13T00:00:00-04:00' for column 'VALIDFROM' at row 1\n","stream":"stderr","time":"2023-03-10T03:30:41.280721023Z"}"

How can we resolve this issue?

Thank You,

Richi Mohanty

[timchengappa]

Hello @RMohanty 

The 'Validfrom' attribute of the accounts table is of 'date' datatype and can only accept values in the format below...

YYYY-MM-DD HH:MM:SS
Eg: 2023-03-15 00:41:17

Alternatively, you can browse through other account attributes such as customproperty1, etc from the data analyzer which is of datatype 'Varchar' and map the target application's 'Start Date' to it 

[RMohanty]

Hi @timchengappa ,

Thank You for your suggestion.

When we try to map with Custom Property 1 it is getting updated, but we want to map it to ValidFrom. How can we format it into YYYY-MM-DD HH:MM:SS (DateTime format)?

Do we have any function to achieve this?

Thank You,

Richi

[timchengappa]

Hello @RMohanty 

We currently do not support any incoming data manipulations during accounts import.

Please free to log an enhancement idea in our ideas portal https://ideas.saviynt.com/ideas