News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Get multiple customers...

Small and medium business | Business Central, N...

Answered

Get multiple customers in a single API call in Business central

(0) Share

Report

Report

Posted on by Community member

72

Hello,

Is there any way where I can get multiple customers data in a single call via API in a business central?

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

YUN ZHU 75,848 Super User 2024 Season 2 on at

Like (0)

Report

Get multiple customers in a single API call in Business central

Hi, if you do not specify a system ID or filter, all customers will be obtained by default.

For example, https://api.businesscentral.dynamics.com/v2.0/c8558e71-6ad8-4fcd-9f29-3ca165b41bbe/Sandbox223/api/v2.0/companies(554f4f15-9c8e-ee11-be3e-6045bde96b9a)/customers

If you mean a different environment, as far as I know this can't be done.

Hope this helps.

Thanks.

ZHU
Suggested answer

gdrenteria 13,057 Most Valuable Professional on at

Like (0)

Report

Get multiple customers in a single API call in Business central

Hi

You have to use the filter option in URL, like this: /customers?$filter=startswith(displayName, 'A')

Check out this:

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-connect-apps-filtering

https://www.odata.org/documentation/odata-version-3-0/url-conventions/ (5.1.2. Filter System Query Option)

Best Regards

Gerardo

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,711 Super User 2024 Season 2

#2

Martin Dráb 230,458 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans