Does anyone know of a way to have a transform return NULL vs “empty string”? The specific use case is a calculation of an identity attribute that needs to be set to NULL in certain conditions. Similar to reading a NULL, or empty string, from a source where the identity attribute doesn’t show at al…

Hey @edmarks , Let me expand on this, because the solution I suggested may still work for you but would require some adjustment. You can use this firstValid transform workaround in tandem with the static transform. As you can see in my previous solution, I employed the use of only the firstValid tra…

Could you use a conditional to return null? Conditional | SailPoint Developer Community Output different values depending on simple conditional logic. Maybe something like this: { "attributes": { "expression": "foo eq bar", "positiveCondition": fo…

Tried that, but it didn’t seem to work. Examples and results shown below for reference: { "id": "990b8c62-967b-4b4a-8e88-60b376bc88f6", "name": "Identity_MiddleNameNewTest", "type": "conditional", "attributes": { "expression": "foo eq foo", "positiveCondition": "foo…

Ok, so maybe the conditional operator does some null checking to make sure nulls aren’t aggregated. The next option would be to use the static transform with some velocity scripting. Something like this. { "attributes": { "workerType": { "attributes": { "sourceName": "HR Source"…

If a transform happens to return null, then it throws an Exception… { "id": "a410048e-XXXXXXXXXXXX-169cafd41864", "name": "Test Transform", "type": "static", "attributes": { "value": "#set($foo = null)$foo" }, "internal": false } [image]

Hi You can use first value Tranform along with static transform Example: { "name": "Testing", "type": "static", "attributes": { "workerType": { "attributes": { "values": [ { "attributes": { …

I am having this same issue. Transforms don’t seem to like returning blank values.

Hey @edmarks , One solution as another mentioned is to use a STRING null rather than an empty string. That way, attributes with empty values are not displayed in the Identity Details page and at least say something like “NULL,” “EMPTY,” “N/A,” or whatever else you may see fit. However, to prevent th…

This helps clarify there isn’t a solution if using the static transform as we’re doing in this case.

Transform to return NULL

Identity Security Cloud (ISC) ISC Discussion and Questions

edmarks (Ed Marks) February 22, 2024, 3:59pm 7

This definitely returns the STRING VALUE of “NULL”, but not the desired NULL value that is desired.

Transform - Find Users' Last Activity Date (find latest date in array)

Topic		Replies	Views
Conditional Transform Fails When Attribute Is Null or Empty ISC Discussion and Questions identity-security-cloud	6	253	September 8, 2025
Transform to check value ISC Discussion and Questions transforms , identity-security-cloud	5	161	September 9, 2025
To check whether the attribute has value or not ISC Discussion and Questions transforms	2	1163	November 8, 2022
Transform error ISC Discussion and Questions transforms , identity-security-cloud	3	131	May 3, 2025
Help with empty values in transform ISC Discussion and Questions transforms , identity-security-cloud	4	81	October 18, 2025

Transform to return NULL

Related topics