REST API of Database view, fetching variables and catalog task fields

[Prabhat4]

Hello Developers,

I've crated a Database view and created a table api of the table created. After applying sysparm_fields, i'm fetching variables on the catalog task and other task fields. The Road block is whenever variable is reference type then in response i'm getting sys_id as value, instead of sys_id we need the display value.  I know we can do this via scripted REST API, However we want to do it via database view only, If any help can be done then that would be great.

I'm attaching screenshots of both the outputs that is from scripted rest and database view table api.

[Ahmmed Ali]

Also verify if the table which the field op_value is referring has defined a field as Display field. i.e field has the check box "Display" set it field's dictionary. 

We can get the name by dot walk also as it is reference field. But by seeing the example response you provided, It seems like other reference type fields are having value as Display name only (assignment group, assigned to). But only OP_Value field has set as sys_id.

So need to resolve the issue in that perspective. 

Let me know if I misunderstood anything above.

Thanks,

Ali

[Prabhat4]

Hi Ahmmed,

I've done this, it didn't worked. If i'm using dot walking then that fields itself is not coming in response.

Value column in Options table is string type and i've set the display to true in dictionary as well, again didn't worked. sysparam_dispaly_value is already true.

Assignment group and Assigned to are coming from catalog task table. so these are different fields.

THanks,

[Ahmmed Ali]

Hello Prabhat,

The database view is on what all tables and can you post your sample rest API here?

Thanks,

Ali