0
Answered

how to map Date to Timestamp from Adapter to Locker

Huu Tran 1 year ago in UNIFYBroker/Plus • updated by Curtis Lusmore 1 year ago 3

An vice versa? Is there any built in transformation or is has to be done by powershell task?

Affected Versions:
Fixed by Version:

Answer

Answer
Answered

Hi Huu,

There is currently no way to do this directly. As you suggest, you could use a PowerShell task in the Synchronization stage to apply the mapping, or alternatively you could use a Time Offset Transformation in the adapter to generate a Timestamp field. We may look at easier ways to accomplish type conversions in the future, but it would more likely be by converting the type in an adapter transformation.

Out of curiosity, what is the use case?

Answer
Answered

Hi Huu,

There is currently no way to do this directly. As you suggest, you could use a PowerShell task in the Synchronization stage to apply the mapping, or alternatively you could use a Time Offset Transformation in the adapter to generate a Timestamp field. We may look at easier ways to accomplish type conversions in the future, but it would more likely be by converting the type in an adapter transformation.

Out of curiosity, what is the use case?

TerminationDate in Chris21 to accountExpires in AD

Okay. In this case, we quite often see a Time Offset Transformation used anyway to also specify the hour of the day that the account should expire.