SAP B1 Service layer $select option doesn't work for some user defined tables

[former_member500538]

Hi,

We are using service layer. We don't want to select all columns so we are using $select query option. For some tables, this option doesn't work. What can be the reason for this condition?

This is my query: $select=U_L_ITEMCODE,U_L_RELATEDITEM

This is the answer:

{

"Code": null,

"Name": null,

"U_L_ITEMCODE": "CSP-67228",

"U_L_RELATEDITEM": "CSP-35256",

"U_L_RELATIONTYPE": null

}

Actually, code, name and relation type fields are not null. But since we don't select those columns they returns as null

Thanks

Haktan

[ANKIT_CHAUHAN]

Hi Haktan Cinkilic ,

It appears that you are having the same scenario as mentioned in SAP Note 2722485. The issue is supposed to be fixed in the upcoming patches.

Kindly keep checking the mentioned SAP Note about the fix.

Kind regards,

ANKIT CHAUHAN

SAP Business One Support