Business Central forum

Field Names For Tables

(1) Share

Report

Posted on by DS-15051354-0

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

Categories:

Integration with Dynamics 365 products

All responses (7)

Answers (0)

Suggested answer

YUN ZHU 70,681 Super User 2024 Season 2 on at

Like (0)

Report

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.

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-api-pagetype?wt.mc_id=DX-MVP-5004336

Hope this helps.

Thanks.

ZHU
DS-15051354-0 74 on at

Like (1)

Report

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 70,681 Super User 2024 Season 2 on at

Like (0)

Report

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

https://yzhums.com/20960/

Thanks.

ZHU
DS-15051354-0 74 on at

Like (1)

Report

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 70,681 Super User 2024 Season 2 on at

Like (1)

Report

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

https://yzhums.com/38428/

Thanks.

ZHU
Valentin Castravet 22,693 Super User 2024 Season 2 on at

Like (1)

Report

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.

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/
Suggested answer

gdrenteria 10,361 Most Valuable Professional on at

Like (0)

Report

Field Names For Tables

Hi

I hope this can help you and give you some hints

How to export all fields in all tables in Dynamics 365 Business Central | Dynamics 365 Lab (yzhums.com)

BR

GR