Date format with Identity collection from SAP SF using REST

[JacobusJenneken]

Hi,

I'm using the new REST collector framework to configure an Identity Collection from SAP SuccessFactors. I have a challenge with the format of a date attribute at the moment:

The startdate of a user is returned in a JSON Date format: "/Date(1267401600000)". How can this be transformed in a date-time string like "12-03-2020 14:00:00" ? 

Thanks,

Koos

[PradeepKadambar · Accepted solution]

I don't think the REST collectors have transformation capabilities on the parsed values unfortunately. I think this needs to be a core capability of the collectors.

Example: if you are collecting active status of an account, most web services will return true or false and IGL needs it to be transformed to 0 or 1

[JamiePryer]

so you would need to use a post-processor to make that date format readable if you wanted to use it?

[MHelmy]

Yes and even then you won't be able to use that in with things like Attribute Change rules that rely on the collector detecting the attribute change (not post processing).

[SunilMishra]

Hi Pradeep ,

Could you ,please help us to built transform process for Identity Collector ,because if we make changes in post process or attribute it will be override by the Identity collector i.e. Is_terminate .

[PradeepKadambar]

Sunil Mishra‌ I suggest that you contact your RSA rep to engage professional services. What you are referring to could have implications on collections integrity and efficiency and need to be thought through.

[IanStaines]

Here is the correct URL for this RSA Ideas posting.  Please ensure you upvote.

https://community.rsa.com/t5/rsa-identity-governance/generic-rest-collectors-must-support-data-formatting/idi-p/576486RSA SecurID PASSCODE Request