Hi All,
Is it possible to get all the tables and their fields in D365FO , is there any Microsoft document available or do we need to write a code to get all the tables and fields.
Please advise us.
Regards,
Akbar
Here's the Power Query that worked for me (for your scenario replace "yourdomain.yourenvironment.dynamics.com/data" with your URL and {"table1", "table2", "table3"} with the actual list of tables prepared in advance in Excel):
let
Source = OData.Feed("yourdomain.yourenvironment.dynamics.com/data"),
GetAllTables = (tableList) =>
let
GetTableColumns = (tableName) =>
try
let
tableData = Source{[Name=tableName, Signature="table"]}[Data],
columnNamesList = Table.ColumnNames(tableData),
concatenatedColumnNames = Text.Combine(columnNamesList, ", "),
resultTable = #table({"Table", "Columns"}, {{tableName, concatenatedColumnNames}})
in
resultTable
otherwise
#table({"Table", "Columns"}, {}),
allTables = List.Accumulate(tableList, #table({"Table", "Columns"}, {}), (state, current) => Table.Combine({state, GetTableColumns(current)}))
in
allTables,
TableList = {"table1", "table2", "table3"}, // Add your table names here
Result = GetAllTables(TableList)
in
Result
Hi Akbarpasha,
From D365FO UI, You can install extension for Table Browser caller for chrome, then you have access to tables lists and you can find their fields via Table browser.
Hello
It is not recommended getting all columns from all tables as it will make your project bulky and slow but still if you want to retrieve all the data from DB, following article might help you.
stackoverflow.com/.../how-can-i-get-all-data-in-all-tables-and-rows-in-a-sql-server-database
There are several options. You can look into SqlDictionary table. You can use the new metadata API, or the old API (DictTable etc.). You can also look directly to database, but note that it looks differently than in AOT (e.g. because how table inheritence is implemented).
By the way, what is the business problem that you're trying to solve by listing all tables and fields?
Hi Judy,
Do you have any idea about the code to get the tables and fields list.
Your help will be really appreciated.
Regards,
Akbar
Thank you Judy,
We need the list of table and their fields, do we need to write any code to get all in one result.
Regards,
Akbar
Hi Akbarpasha,
You may refer to the link which contains the documentation available for the System classes. But it is not a complete list of the System table members.You can find a complete list of tables and their members in the Application Explorer.
#1
André Arnaud de Cal...
293,280
Super User 2025 Season 1
#2
Martin Dráb
232,046
Most Valuable Professional
#3
nmaenpaa
101,156
Moderator
Share
Report
All responses (
Answers (