Nested Date Transform Types

[npilley (Nathan Pilley)]

Hello,
We have an interesting scenario where the date coming over from our data source is getting transformed by the JDBC connection from “yyyy-mm-dd hh:mm:ss” to “mm/dd/yyyy hs UTC”. I know we can use a date format type transform to convert it back into the appropriate format within SailPoint. However, here is the kicker, that attribute also may include a specific future-date that we are currently setting to blank using an if/else statement within a Static transform type. Is there a way to nest both a static and date format transform type into one transform?

So essentially, when this date comes in we first need to format to the appropriate format, then we also want to blank it out if it equals “5/31/5555”. Any assistance or guidance on how to best accomplish this would be greatly appreciated! Current transform attached.

Thanks,
Nate

[ethompson (Edward Thompson)]

Something like the following (change the inputFormat/outputFormat to match what you want):

{
    "name": "Date Format",
    "type": "static",
    "attributes": {
        "termdate": {
            "type": "dateFormat",
            "attributes": {
                "input": {
                    "type": "accountAttribute",
                    "attributes": {
                        "sourceName": "DateSpring",
                        "attributeName": "TermDate"
                    }
                },
                "inputFormat": "EPOCH_TIME_JAVA",
                "outputFormat": "ISO8601"
            }
        },
        "value": "#if($termdate == '5/31/5555')#{else}$termDate#end"
    }
}

Note: You do not need to create “blankval”, you can just leave the value empty between the if condition and #{else}.