Answered

XRM.WebAPI.retrieveRecord not returning row although it is present

(0) Share

Report

Posted on by Rutu01

305

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

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Guido Preite 1,488 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

the code is simple and if the field value it's not null it should be return.

You can try with my tool Dataverse REST Builder (https://github.com/GuidoPreite/DRB) it generates the correct syntax (it doesn't use the await and the Xrm.WebApi can be only executed using the Managed Solution, but it will be always generated) and check there what's going on, if also inside my tool the value is null, then it's not a syntax problem.

Was this reply helpful? Yes No
Rutu01 305 on at

Like (0)

Report
Copy link

Link copied!

I tried returning all the rows 1 top 1 row etc but it keeps returning null. Perhaps there is some bug with some table and it's taken up two days already so i'm just going to delete the table and retry another time with a fresh table.

Was this reply helpful? Yes No