web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Business Central forum / Not Seeing Certain Fie...
Business Central forum

Not Seeing Certain Fields on Customer table when using API

(0) ShareShare
ReportReport
Posted on by John Adali 5

Hello,

I am new to Business Central and need some help using the API. I am trying to retrieve the following fields on the Customer table (with the intention to update them) using the API.

  • Salesperson Code
  • Training Certificate Date
  • Training Completed

BC1.jpg

However, when I use Postman to call the API I do not see these fields in the response returned:

BC2.jpg

I am using an HTTP GET to call into the API: api.businesscentral.dynamics.com/.../&lt;<guid>>/sandbox/api/v1.0/companies(<<guid>>)/customers?$filter=number eq '54321'

What am I missing here? How do I call the API to access these fields for a single Customer record? Any help is greatly appreciated.

Thanks,

John

Categories:
Other
  • Suggested answer
    I Gusti Made Ari Profile Picture
    I Gusti Made Ari 3,608 on at

    The fields that you are looking for is not part of standard API, you need to do customization if need to add

    You can refer on below at properties section :

    docs.microsoft.com/.../dynamics_customer

  • Suggested answer
    Stefano Demiliani Profile Picture
    Stefano Demiliani 37,172 Most Valuable Professional on at

    It's never recommended to customize standard API pages. APIs are born with the intent to have a "fixed contract". You should create your own API page that uses the Customer table instead (with your custom namespace, version etc).

    P.S. You've also OData that supports REST calls and where you can simply publish the Customer page.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard > Business Central

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans