Hi All, I am working on a lookup transform and wanted to understand that if the values passed in the table can be passed through any other way on the runtime instead of passing them manually like key-value pair. For Example in the lookup table i am passing key value as: Userid( XXYZ) : yes I nee…

Can you explain your requirement in detail please?

Hello Kapil, You can use Poweshell Script to Update SailPoint Lookup Transform: Step 1: Define Variables $tenant = “ your-tenant.api.identitynow.com ” $clientId = “your-client-id” $clientSecret = “your-client-secret” $transformId = “your-transform-id” Step 2: Get Access Token $tokenBody = @{ …

Hi @chellanikaps3 In SailPoint Identity Security Cloud, the Lookup Transform table is static and cannot be dynamically populated at runtime through scripts or APIs. The values must be configured manually in the transform definition. If you need dynamic values such as UserID, it is better to fetch t…

The way a lookup transform works is that you pass in a value, and that value is checked against the defined table. If the value exists in the table, the corresponding response value is returned; otherwise, the default case is returned. You’d have to define the values to search for as well as the res…

Thanks Pankaj for the prompt response, this will update the lookup table values from csv or database column as well ?

Thanks for the update. Can we user a rule transform for this purpose.

For the lookup transform to be executed, you need to provide the key-value pair in the input and set a default value. So I have a requirement where the input values to the transform can be passed through automation instead of manually. For example : I have 100 input key- value pair and the defaul…

Thanks Jaya for the response. Below is the requirement For the lookup transform to be executed, you need to provide the key-value pair in the input and set a default value. So I have a requirement where the input values to the transform can be passed through automation instead of manually. For ex…

[image] Kapil C: I need to insert these input values through automation from a csv file or some DB tables. You might want to take a look at this, to brainstorm: [image] Custom entities "Non-Identites" in ISC (Location/Site/Building/Facilities) - supported approach ISC …

[image] Kapil C: I need to insert these input values through automation from a csv file or some DB tables. Is this going to be one time effort or do you want to update the transform regularly by reading the CSV? like daily or once every few hours? If you are thinking of reading from CSV in r…

Lookup transform table values

Identity Security Cloud (ISC) ISC Discussion and Questions

David_Norris (Terry Yau) March 12, 2026, 7:43pm 10

You might want to take a look at this, to brainstorm:

…and yes, you can update the lookup transform via API (e.g. PowerShell SDK)…but you’ll need somewhere to store the script, the DB credential, the PAT and run the script.

Create Transform API:

Update Transform API:

Topic		Replies	Views
Looking for help on Lookup table via API ISC Discussion and Questions identity-security-cloud , provisioning	6	82	May 6, 2025
Lookup transform table options ISC Discussion and Questions transforms , identity-security-cloud	2	136	November 16, 2024
Identity Security Cloud - Transform Table - Multiple Keys with the same value ISC Discussion and Questions transforms , identity-security-cloud	8	327	July 15, 2024
Nested lookup transform issue ISC Discussion and Questions transforms , identity-security-cloud	3	277	September 6, 2025
Lookup Transform - Default Value ISC Discussion and Questions transforms , identity-security-cloud	11	382	January 4, 2025

Lookup transform table values

Related topics