Description
In this course, you will learn how to handle reading and writing files and working with streams. We will also discuss the XMLPort object, which is used to import and export data via XML or Text files. This course also discusses the Query object, how to join and filter data from different tables, to export this data to XML or CSV, display the data in a chart, or use this data for an OData Web Service.
What are the goals for this course?
Work with the File Object
Work with the TempBlob Object
Understand what is a XMLPort
Understand XMLPort Properties and Triggers
Design and create XMLPorts
Design and create a Query
Access Queries from AL
What are the prerequisites to consume this course?
General knowledge of Microsoft Dynamics 365 Business Central
Some previous experience with development processes and concepts with Microsoft Dynamics NAV or Business Central
Module 01: Files
- Working with the File Object
- Working with the TempBlob Object
- Streaming
- File Management - Reading and Writing Files
- File Management - Working with Streams and the Tempblob Table
Module 02: XMLPorts
- What is an XMLPort?
- XMLPort Properties and Triggers
- Node Properties
- Designing XMLPorts
- Creating XMLPorts
- Working with Plain Text
- Using XMLPorts in AL Code
Module 03: Queries
- Query Design
- Aggregating and Ordering Data and Date Methods
- Creating a Query Example
- Accessing Queries from AL
- Accessing Queries from AL: Example
- Advanced Query Concepts
- Using Queries for Charts
- Dynamics 365