Dataverse Web API nested expand values returned are null

(0) Share

Report

Posted on by AnthonyD

559

Hello,

I have a web api query that has a nested expand. The query runs but the nested expand has no values. The only values that are returned from the nested expand records are the guid and the Primary Name Column. I tried removing all selects from my query but this did not resolve the problem. Any ideas? My nested expand is build us as Microsoft documentation explains (Only difference is my query is only 2 expands deep and the tables are custom tables). See code below.

GET [Organization URI]/api/data/v9.1/tasks?$select=subject
&$expand=regardingobjectid_contact_task($select=fullname;
 $expand=parentcustomerid_account($select=name;
 $expand=createdby($select=fullname))) HTTP/1.1 
Accept: application/json 
OData-MaxVersion: 4.0 
OData-Version: 4.0

Best Regards,

Anthony

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

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

Like (0)

Report
Copy link

Link copied!

it's a known "bug" the fact that expand of expand returns null attributes. The alternative is to create a FetchXML query and execute the FetchXML by the Web API

Was this reply helpful? Yes No
AnthonyD 559 on at

Like (0)

Report
Copy link

Link copied!

Any news if they are planning to fix this or has this been like this for a while?

Was this reply helpful? Yes No
Guido Preite 1,490 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

I don't know if they consider it a bug or not in the first place, as you saw in the documentation there isn't (at least also to my knowledge) a place where they define that the expand of expand is possible, and if they consider as a bug I don't know their timeline to fix it.

Was this reply helpful? Yes No