Dynamics Community Forum Thread Details

Odata query response

I am using the below ODATA query to expand the products from salesorderdetails but the query is returning null for all the fields even though the data in present in dynamics.

ODATA query: /salesorders?$expand=order_details($expand=productid,salesorderid),customerid_account

Below is the response after expanding productid.

Response:

    <productid>
      <validtodate>null</validtodate>
      <importsequencenumber>null</importsequencenumber>
      <productstructure>null</productstructure>
      <productid>122c98ac-b17d-ea11-a811-000d3af3ac9d</productid>
      <_parentproductid_value>null</_parentproductid_value>
      <_createdbyexternalparty_value>null</_createdbyexternalparty_value>
      <producttypecode>null</producttypecode>
      <statuscode>null</statuscode>
      <msdyn_purchasename>null</msdyn_purchasename>
      <iskit>null</iskit>
      <price>null</price>
      <entityimage_url>null</entityimage_url>
      <stockvolume>null</stockvolume>
      <currentcost>null</currentcost>
      <_modifiedonbehalfby_value>null</_modifiedonbehalfby_value>
      <standardcost>null</standardcost>
      <quantityonhand>null</quantityonhand>
      <timezoneruleversionnumber>null</timezoneruleversionnumber>
      <IsReferencedQueryCall>true</IsReferencedQueryCall>
      <new_bvitemid>null</new_bvitemid>
      <quantitydecimal>null</quantitydecimal>
      <_defaultuomid_value>null</_defaultuomid_value>
      <_defaultuomscheduleid_value>null</_defaultuomscheduleid_value>
      <_modifiedbyexternalparty_value>null</_modifiedbyexternalparty_value>
      <modifiedon>null</modifiedon>
      <size>null</size>
      <dmtimportstate>null</dmtimportstate>
      <validfromdate>null</validfromdate>
      <productnumber>null</productnumber>
      <_msdyn_defaultvendor_value>null</_msdyn_defaultvendor_value>
      <entityimage>null</entityimage>
      <name>null</name>
      <_msdyn_transactioncategory_value>null</_msdyn_transactioncategory_value>
      <vendorname>null</vendorname>
      <new_dbms_quickbooks_id>null</new_dbms_quickbooks_id>
      <hierarchypath>null</hierarchypath>
      <price_base>null</price_base>
      <exchangerate>null</exchangerate>
      <entityimage_timestamp>null</entityimage_timestamp>
      <_subjectid_value>null</_subjectid_value>
      <utcconversiontimezonecode>null</utcconversiontimezonecode>
      <description>null</description>
      <statecode>null</statecode>
      <_pricelevelid_value>null</_pricelevelid_value>
      <msdyn_fieldserviceproducttype>null</msdyn_fieldserviceproducttype>
      <isstockitem>null</isstockitem>
      <_createdby_value>null</_createdby_value>
      <standardcost_base>null</standardcost_base>
      <overriddencreatedon>null</overriddencreatedon>
      <msdyn_converttocustomerasset>null</msdyn_converttocustomerasset>
      <producturl>null</producturl>
      <stockweight>null</stockweight>
      <entityimageid>null</entityimageid>
      <_organizationid_value>null</_organizationid_value>
      <_createdonbehalfby_value>null</_createdonbehalfby_value>
      <vendorpartnumber>null</vendorpartnumber>
      <__DisplayName__>Alum Channel 6 x 2 x 9/32</__DisplayName__>
      <msdyn_taxable>null</msdyn_taxable>
      <vendorid>null</vendorid>
      <_transactioncurrencyid_value>null</_transactioncurrencyid_value>
      <traversedpath>null</traversedpath>
      <versionnumber>null</versionnumber>
      <createdon>null</createdon>
      <_modifiedby_value>null</_modifiedby_value>
      <suppliername>null</suppliername>
      <processid>null</processid>
      <currentcost_base>null</currentcost_base>
      <msdyn_upccode>null</msdyn_upccode>
      <isreparented>null</isreparented>
      <stageid>null</stageid>
    </productid>

Quick Links