How to fetch one attribute of JSON value in customproperty of AD account

[shilpab]

Hi,

In AD account on target, there is one attribute whose value is JSON.

We want to fetch JSON value in custom property, but we are getting exception as 

Data truncation exception: Data too long.

How to resolve this error? 

If we want to fetch only one attribute from JSON and map to custom property , is it possible ?

[SB]

The data truncation you are receiving is due to the size of the Saviynt attribute you have mapped the AD attribute to.  

Can you update the mapping and map your AD attribute to another Saviynt's attribute with a larger data type. You can ideally use columns CUSTOMPROPERTY51-56 as they are longtext type. 

You can also view the data type of the columns on your env from Data analyzer.

Admin>Admin Function>Data Analyzer>Expand accounts table and hover over the i icon