3
Accessing and Combining Data
Given that M is a language used for retrieving and transforming data, it is natural that the M language has a large number of built-in functions devoted to retrieving data from various systems such as files, folders, databases, web pages, and standardized data structures and protocols such as eXtensible Markup Language (XML), JavaScript Object Notation (JSON), and the Open Data Protocol (OData).
In fact, M includes over 100 standard data retrieval functions and provides the ability to write extensions to retrieve data from additional sources such as custom business systems like an in-house-developed customer relationship management (CRM) system or warehouse management system (WMS). Creating such extensions is covered ...
Get The Definitive Guide to Power Query (M) now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
