I frequently use this code for other tables and it works just fine but for some reason it's not working for one particular table.
This is for the same account that has created the database and has full access
I can even see this record in the form so i know access rights is not a problem
Have confirmed the row guid and column name and even tried with other column names like jg_name but it's simply not working and returning null
const result=
await Xrm.WebApi.retrieveRecord("jg_tdslowerdeductioncertificate", "137a85ca-dadd-ed11-8846-000d3a0a6cc7", "?$select=jg_tdsrate");
displayDebugMessage(result);
displayDebugMessage("tds certificate table returned the value "+result.jg_tdsrate);
displayDebugMessage(result) is showing blank
displayDebugMessage("tds certificate table returned the value "+result.jg_tdsrate); is resulting in a jg_tdsrate is undefined error
I have tried for hours and I'm baffled why the record is not being returned