Documentation Generator | M (Power Query)

Code Documentation Analysis

This code retrieves data from the Dynamics 365 Business Central API for the "Purchase_Order_Excel" table, performs transformations on the data, and returns a resulting table with selected and renamed columns.


Empty image or helper icon

Prompt

Create Documentation for this code let
  Source = Dynamics365BusinessCentral.ApiContentsWithOptions("Production", "Britten-Live", "WebServices", [UseReadOnlyReplica = true]),
  #"Navigation 1" = Source{[Name = "Purchase_Order_Excel", Signature = "table"]}[Data],
  #"Choose columns" = Table.SelectColumns(#"Navigation 1", {"Document_Type", "No", "TMG_Requestor", "Your_Reference"}),
  #"Renamed columns" = Table.RenameColumns(#"Choose columns", {{"TMG_Requestor", "Requestor"}, {"Document_Type", "Document Type"}, {"No", "Document No"}})
in
  #"Renamed columns"

Answer

Code Documentation

Purpose

The purpose of this code is to retrieve data from the Dynamics 365 Business Central API for the "Purchase_Order_Excel" table. The retrieved data is then transformed by selecting specific columns, renaming them, and returning the resulting table.

Class Signatures

There are no class signatures in this code.

Method Signatures

There are no method signatures in this code.

Inline Comments

There are no inline comments in this code.

Functionality

  1. The code calls the Dynamics365BusinessCentral.ApiContentsWithOptions function to retrieve the contents of the "Production" web service with the options "Britten-Live" and "WebServices". The UseReadOnlyReplica option is set to true. The result is assigned to the Source variable.

  2. The code navigates to the "Purchase_Order_Excel" table within the Source by using the #"[Name = "Purchase_Order_Excel", Signature = "table"]"[Data] syntax. The result is assigned to the #"Navigation 1" variable.

  3. The code selects specific columns ("Document_Type", "No", "TMG_Requestor", "Your_Reference") from the #"Navigation 1" table using the Table.SelectColumns function. The result is assigned to the #"Choose columns" variable.

  4. The code renames the columns in the #"Choose columns" table using the Table.RenameColumns function. The column names "TMG_Requestor", "Document_Type", and "No" are renamed to "Requestor", "Document Type", and "Document No" respectively. The result is assigned to the #"Renamed columns" variable.

  5. The code returns the #"Renamed columns" table as the output of the query.

Example Usage

There is no example usage for this code.

Create your Thread using our flexible tools, share it with friends and colleagues.

Your current query will become the main foundation for the thread, which you can expand with other tools presented on our platform. We will help you choose tools so that your thread is structured and logically built.

Description

The purpose of this code is to retrieve data from the Dynamics 365 Business Central API for the "Purchase_Order_Excel" table. The retrieved data is then transformed by selecting specific columns, renaming them, and returning the resulting table.

The code first calls the Dynamics365BusinessCentral.ApiContentsWithOptions function to retrieve the contents of the "Production" web service with the options "Britten-Live" and "WebServices". The UseReadOnlyReplica option is set to true and the result is assigned to the Source variable.

Next, the code navigates to the "Purchase_Order_Excel" table within the Source by using the #[Name = "Purchase_Order_Excel", Signature = "table"][Data] syntax, and assigns the result to the "Navigation 1" variable.

The code then selects specific columns ("Document_Type", "No", "TMG_Requestor", "Your_Reference") from the "Navigation 1" table using the Table.SelectColumns function. The result is assigned to the "Choose columns" variable.

Afterwards, the code renames the columns in the "Choose columns" table using the Table.RenameColumns function. The column names "TMG_Requestor", "Document_Type", and "No" are renamed to "Requestor", "Document Type", and "Document No" respectively. The result is assigned to the "Renamed columns" variable.

Finally, the code returns the "Renamed columns" table as the output of the query.

This code does not include any class signatures, method signatures, inline comments, or example usage.

More Documentation Generators
Apache Flink Documentation Generator Apache Flink Documentation GeneratorApache Pig Documentation Generator Apache Pig Documentation GeneratorAzure Data Factory Documentation Generator Azure Data Factory Documentation GeneratorC/C++ Documentation Generator C/C++ Documentation GeneratorCouchDB Documentation Generator CouchDB Documentation GeneratorDAX Documentation Generator DAX Documentation GeneratorExcel Documentation Generator Excel Documentation GeneratorFirebase Documentation Generator Firebase Documentation GeneratorGoogle BigQuery Documentation Generator Google BigQuery Documentation GeneratorGoogle Sheets Documentation Generator Google Sheets Documentation GeneratorGraphQL Documentation Generator GraphQL Documentation GeneratorHive Documentation Generator Hive Documentation GeneratorJava Documentation Generator Java Documentation GeneratorJavaScript Documentation Generator JavaScript Documentation GeneratorJulia Documentation Generator Julia Documentation GeneratorLua Documentation Generator Lua Documentation GeneratorM (Power Query) Documentation Generator M (Power Query) Documentation GeneratorMATLAB Documentation Generator MATLAB Documentation GeneratorMongoDB Documentation Generator MongoDB Documentation GeneratorOracle Documentation Generator Oracle Documentation GeneratorPostgreSQL Documentation Generator PostgreSQL Documentation GeneratorPower BI Documentation Generator Power BI Documentation GeneratorPython Documentation Generator Python Documentation GeneratorR Documentation Generator R Documentation GeneratorRedis Documentation Generator Redis Documentation GeneratorRegex Documentation Generator Regex Documentation GeneratorRuby Documentation Generator Ruby Documentation GeneratorSAS Documentation Generator SAS Documentation GeneratorScala Documentation Generator Scala Documentation GeneratorShell Documentation Generator Shell Documentation GeneratorSPSS Documentation Generator SPSS Documentation GeneratorSQL Documentation Generator SQL Documentation GeneratorSQLite Documentation Generator SQLite Documentation GeneratorStata Documentation Generator Stata Documentation GeneratorTableau Documentation Generator Tableau Documentation GeneratorVBA Documentation Generator VBA Documentation Generator