How can you implement multiple $expand in an API but not multilevel/cascading?

(0) Share

Report

Posted on by kenyo

Hello, I've built a customer API with two SubPageLinks to both the Bank Accounts and the Ship-To Addresses. Now i am trying to GET the customer and $expand both the bankAccount and the shipToAddress in one request.

in two requests it works:

{{BC-Instance}}/{{API-Suffix}}/{{Company}}/customers('10000')?$expand=shipToAddresses

{{BC-Instance}}/{{API-Suffix}}/{{Company}}/customers('10000')?$expand=bankAccounts

How is it possible to combine both expands in just one request?

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

YUN ZHU 93,874 Super User 2025 Season 2 on at

Like (1)

Report

RE: How can you implement multiple $expand in an API but not multilevel/cascading?

Hi, Sorry I haven't tested it, hope the following helps.

https://stackoverflow.com/questions/54560223/expand-multiple-fields-in-acumatica-rest-api-endpoint

Thanks.

ZHU

Was this reply helpful? Yes No
Nitin Verma 21,696 Moderator on at

Like (0)

Report

RE: How can you implement multiple $expand in an API but not multilevel/cascading?

Hi,

you can try like this

GET /companies({{companyId}})/salesOrders?$filter=orderDate ge 2019-05-01&$expand=paymentTerm,salesOrderLines($expand=account,item($expand=itemCategory))

Please refer the below link,

learn.microsoft.com/.../dynamics-rate-limits

Was this reply helpful? Yes No
kenyo on at

Like (1)

Report

RE: How can you implement multiple $expand in an API but not multilevel/cascading?

Thank you , yes that works after hours of looking for documentation i found the same answer in docs.oasis-open.org/.../odata-v4.01-csprd05-part1-protocol.html

and the expanded navigation properties are just comma separated

so in my case it is {{BC-Instance}}/{{API-Suffix}}/{{Company}}/contacts('KT000001')?$expand=bankAccounts,shipToAddresses,contactBlocks

Was this reply helpful? Yes No