We currently have a field from the HR Identity feed that indicates 'Last working Day', and would like to sync to AD (accountExpires) when this is updated.
Account custom attribute: "Expiry Date"
User custom attribute: "Last working day"
The account is populated by an AD collector, and the user by a database collector.
Both custom attributes are Date type.
Have setup the attribute sync as follows:
(using the transform in #1, and not in #2)
1: I have tried using the transform to convert the date to the required format:
though am still receving the following error message:
"Unparseable date: "04-MAY-17". Value of 'accountExpires should be in 'MM/dd/yy HH:mm a' format
The AFX connector (Active Directory) 'Update an Account' capability has
accountExpires as a parameter and is mapped to ${Account.Expiry.Date}
2: I have also tried converting the date in a SQL node on the Workflow:
Has removed the transform on the sync, and used the following query:
"Select distinct
to_char(usr.cus_attr_user_cad_1, 'MM/dd/yy HH12:mi am') as AFXCUSTOM_expiry_date_test
FROM t_master_enterprise_users usr join t_av_user_account_mappings map
on usr.id=map.user_id join t_av_accounts acc on map.account_id=acc.id
where account_id='${access_request_cri_acc_id}'
"
The AFX connector (AD) 'Update an account' capability has
accountExpires mapped to ${Expiry_Date_Test},
and mapped ${Account.Expiry_Date} to a random AD field since it is required.
I am still receiving error message:
Unparseable date: "${Expiry_Date_Test}". Value should be in ...... (as above)
Any ideas?
It might be not working because ${Expiry_Date_Test} has no value.
To correct way to refer AFXCUSTOM variables in the connector would be: ${Expiry.Date.Test} ('.' instead of '_')
000031515 - RSA Via L&G AFX fulfillment workflow switches to manual fulfillment when using workflow variables in the AFX connector
I suggest you make sure that the functionality is working as expected when using the Test Connector Capabilities feature.