?$expand= not working in API using GET statement in postman

(2) Share

Report

Posted on by BK-24061057-0

Hi Everyone,

I am using the standard Customer API and trying to expand the customerFinancialDetail using ?$expand. But getting an error as below.In webservices , page is published and using the Oauth link in postman.We get the below error in postman.

 "error": {
        "code": "BadRequest",
        "message": "Could not find a property named 'customerFinancialDetail' on type 'NAV.Customer'.  CorrelationId:  71406eae-2fb0-48fa-a274-cddfbab13b5b."
    }
 
Please find the URL 
 
https://api.businesscentral.dynamics.com/v2.0/tenantID/Sandbox/ODataV4/Company('companyname')/Customer?$expand=customerFinancialDetail
 
get the above error.
"error": {
        "code": "BadRequest",
        "message": "Could not find a property named 'customerFinancialDetail' on type 'NAV.Customer'.  CorrelationId:  71406eae-2fb0-48fa-a274-cddfbab13b5b."
    }

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (9)

Answers (3)

Verified answer

Mohana Yadav 61,003 Super User 2025 Season 2 on at

Like (3)

Report

AFAIK, it is not possible to use ?$expand with ODATA web services.

Please try with APIs

Was this reply helpful? Yes No
Suggested answer

Dynamics_Decoded_Gokul 463 on at

Like (2)

Report

Hi,

We faces this issue before we just tried this way it worked

Part page must have entityname and entitysetname it must be same to be given in sub page property with same entityname and setname

Note: this field is a case sensitive

part(additional; "<><><><><><>")

{

Multiplicity = ZeroOrOne;

EntityName = 'additionalInfoEntry';

EntitySetName = 'additionalsInfoEntries';

SubPageLink = "Registration ID" = field("Registration ID");

}

Was this reply helpful? Yes No
Verified answer

YUN ZHU 95,597 Super User 2025 Season 2 on at

Like (1)

Report

Hi, your endpoint is incorrect, please try the following.

https://api.businesscentral.dynamics.com/v2.0/c8558e71-6ad8-4fcd-9f29-3ca165b41bbe/Sandbox242/api/v2.0/companies(2c6ea79a-9223-ef11-8414-6045bdc8cdaf)/customers?$expand=customerFinancialDetail

Thanks.

ZHU

Was this reply helpful? Yes No
BK-24061057-0 on at

Like (1)

Report

Thanks YunZHu, for customer it worked.I tried with another URL for Salesinvoice as below,

https://api.businesscentral.dynamics.com/v2.0/6f12f387-6e87-41ea-a072-9d8cae6a48e8/SandboxDevelop/api/v2.0/companies(companyid)/salesInvoice

SalesInvoice for page 30012 is also created in webservices. but it throwed error as below

"message": "No HTTP resource was found that matches the request URI 'https://api.businesscentral.dynamics.com/v2.0/6f12f387-6e87-41ea-a072-9d8cae6a48e8/sandbox/api/v2.0/companies(companyid)/salesInvoice?tenant=msweua9310t86169638&aid=FIN'."

Can i know what the issue with URL is.

Is the process for customized page URL also different.

Was this reply helpful? Yes No
Verified answer

YUN ZHU 95,597 Super User 2025 Season 2 on at

Like (1)

Report

As Mohana mentioned, ?$expand= cannot be done with Web Services, my example uses the standard API.

For salesInvoice resource type:

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/api-reference/v2.0/resources/dynamics_salesinvoice?wt.mc_id=DX-MVP-5004336

https://api.businesscentral.dynamics.com/v2.0/c8558e71-6ad8-4fcd-9f29-3ca165b41bbe/Sandbox242/api/v2.0/companies(2c6ea79a-9223-ef11-8414-6045bdc8cdaf)/salesInvoices

Was this reply helpful? Yes No
BK-24061057-0 on at

Like (1)

Report

Hi Mohana\ Yun Zhu ..

Thanks for the update. Is there any link which you can share for API where the same can be achieved for customized pages.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,597 Super User 2025 Season 2 on at

Like (1)

Report

Hi, hope the following helps.

API page type

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-api-pagetype?wt.mc_id=DX-MVP-5004336

Here are a few examples, I hope they can give you some reference.

Dynamics 365 Business Central: How to use Standard/Custom API Bound Actions

https://yzhums.com/39196/

Dynamics 365 Business Central: Release a Sales Order with Power Automate

https://yzhums.com/34483/

Dynamics 365 Business Central: How to post document/journal via Power Automate

https://yzhums.com/37458/

Thanks

ZHU

Was this reply helpful? Yes No
BK-24061057-0 on at

Like (1)

Report

Hi Yun Zhu,

So to this standard API is it possible to add any new fields or any customized fields. If not what is the option to do so. Means how to create a sales order in a single API ( Header and lines) with new custom fields \ new standard fields.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,597 Super User 2025 Season 2 on at

Like (0)

Report

Hi, Unfortunately, this is not possible as of now. This is mentioned in several Microsoft documents.

More details:

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/api-reference/v2.0/?wt.mc_id=DX-MVP-5004336#extending-apis

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-api-pagetype?wt.mc_id=DX-MVP-5004336

This page type can't be extended by creating a page extension object. Instead, you must create a new API by adding a page object.

Thanks.

ZHU

Was this reply helpful? Yes No