Skip to main content

Notifications

Announcements

No record found.

Business Central forum
Suggested answer

Field Names For Tables

Posted on by 72
I'm developing a new App. to add transactions (Sales and Journals) by API.
 
I need to know table field names for various  tables. 
 
Is there a way to lookup field names for tables just using BC UI.
 
How would I do this?
 
Thanks.
Keith
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 63,857 Super User on at
    Field Names For Tables
    Yes, if you want to add new fields, you must create a new API page.
    This is clearly documented in the MS Docs.
     
    Hope this helps.
    Thanks.
    ZHU
  • DS-15051354-0 Profile Picture
    DS-15051354-0 72 on at
    Field Names For Tables
    I just want to verify what you are explaining.
     
    Yes I am using the API.
     
    Are you saying I can only add the following 12 fields using the following API and can't at this time add more fields?
     
    POST https://{businesscentralPrefix}/api/v2.0/companies({id})/journals({id})/journalLines
    Content-type: application/json
    {
        "id": "0a077d18-45e3-ea11-bb43-000d3a2feca1",
        "journalId": "dd1b6a90-44e3-ea11-bb43-000d3a2feca1",
        "lineNumber": 10000,
        "accountType": "G/L Account",
        "accountId": "00000000-0000-0000-0000-000000000000",
        "accountNumber": "",
        "postingDate": "2018-12-31",
        "documentNumber": "",
        "externalDocumentNumber": "",
        "amount": 0,
        "description": "",
        "comment": ""
    }
     
    thanks
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 63,857 Super User on at
    Field Names For Tables
    Hi, If you are using Web Services (Odata), just add the fields directly to the page.
    If you are using the API, unfortunately, it is not possible to extend the standard API at this time.
    More details: Dynamics 365 Business Central: Can we extend standard APIs? – Download Standard Source Code for APIs
     
     
    Thanks.
    ZHU
     
  • DS-15051354-0 Profile Picture
    DS-15051354-0 72 on at
    Field Names For Tables
    Thanks for your help in getting to Tables and then to fields, it was a big help.
     
    So now I need to add a couple fields in Table=81 (journal) to my
    Template of fields to create a journal line. via an API.
     
    Question how to add a field from a table (81) to my batch Template?
     
    When I had tried a few different names to see if in Template I get an error 
     
    property does not exist on type 'Microsoft.NAV.journalLine!.
     
    So I guess I need to modify Microsoft.NAV.journalLine. How do I do that.
     
    Documentation is a bit vague on this subject.
     
    Thanks Keith
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 63,857 Super User on at
    Field Names For Tables
    Hi, If it is standard APIs, it is recommended to view the code of standard APIs, because its caption is a bit special.
    How to export all page field caption in Dynamics 365 Business Central (table 2000000202 “All Control Fields”) – Comparing Table Field Caption and Page Field Caption
     
     
    Thanks.
    ZHU
  • Valentin Castravet Profile Picture
    Valentin Castravet 6,854 Super User on at
    Field Names For Tables
    You can use the Page Inspection Pane to view all fields for a specific page/table. To do this, go to your page and click ctrl+alt+f1 on the keyboard or select Settings ->Help & Support ->Inspect pages and data.
     
     
     
     
  • Suggested answer
    gdrenteria Profile Picture
    gdrenteria 4,883 Super User on at
    Field Names For Tables

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,696 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,490 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans