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?

All responses (3)

Answers (1)

Sort by

Verified answer

YUN ZHU 103,085 Super User 2026 Season 2 on at

Like (1)

Report
Copy link

Link copied!

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
Nitin Verma 21,812 Moderator on at

Like (0)

Report
Copy link

Link copied!

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
kenyo on at

Like (1)

Report
Copy link

Link copied!

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