Hello experts,

We are using an custom ui and and trying to fetch the values stored in an attribute using the rest api v2.0 calls but the response returned is blank. Please find the details below.

Created an Attribute -ABC

Attr type - General, Data type - Text, Multivalue, Presentation - Multi Select,

AttrValues tab - Check Sql query and upated the below query

select role_check from hps where opco_code in (select searchvalue from idmv_value_basic where attranme = 'MX_FS_COMPANY_CODE_ID AND MSKEY = %USERMSKEY%)

The above query return only one value either 1/0/null. When trued to check in std UI, the value is correctly displaying

When tried to use the below REST aPI calls it is always returning blank values.

RESTAPI syntax -

/idmrestapi/v2/service/TASK_ATTRIBUTES(ATTRIBUTE_NAME='ABC',TASK_GUID=guid'47A4B7B8-20F9-4A10-B564-B58A453092A5')/ALLOWED_VALUES HTTP/1.1

/idmrestapi/v2/service/TASK_ATTRIBUTES?TASK_GUID=guid'47A4B7B8-20F9-4A10-B564-B58A453092A5'$expand=ALLOWED_VALUES

Can you please let me know how to fetch the details

Regards,

DP