How can we store variable values into a custom table after submitting an order guide request.

[Aswathy3]

Hi All,

 We are planning to integrate SNOW to SailPoint for On boarding and Off boarding process.

Sailpoint team suggested to store the details in a custom table.

How can we store variable values into a custom table after submitting request.

Is there any document which is related to snow to Sailpoint integration?

Can anyone please help me on this?

Thanks

Aswathy

[AnveshKumar M]

Hi @Aswathy3 

The variables and their answers are stored in sc_item_option_mtom table.

You can create a business rule on sc_request table and define the conditions such that it will be triggered if the request is the order guide of your requirement.

Then in the BR query the sc_item_option_mtom table for the variable values and copy them to your target custom tables.

Please mark my answer helpful and accept as solution if it helped 👍✅

[Aswathy3]

Hi Anvesh,

I m not much clear about the second step.

Can you please brief that?

Thanks

Aswathy