Entity collection as OData action parameter

Data entities in F&O can be exposed through OData protocol. You can also add OData actions by creating methods in X++ and decorating them with SysODataCollectionAttribute. You can see an example in MssLeaveRequestDateEntity.getDirects(): [ SysODataActionAttribute(’getDirects’, false), SysODataCollectionAttribute(’return’, Types::Record, ‘MssLeaveRequestDateEntity’) ] public static List getDirects( str reportingPersonnelNumber, date fromDate, date toDate, LeaveRequestApprovalStatus leaveRequestStatus) { List list …

Continue reading ‘Entity collection as OData action parameter’ »

Happy New Year 2024

Happy New Year! (To everyone who follows Gregorian calendar :)). Let me look a bit at what I did in 2023 and what I expect in 2024. I keep working for a large end-user company. I do a lot of different things there (X++, Azure Functions, code reviews, Powershell, DevOps processes and so on), but …

Continue reading ‘Happy New Year 2024’ »

Query/QueryRun with temporary tables (AX/F&O)

I noticed that some developers believe that Query* classes can’t be used to query temporary tables. It is possible; it just requires an extra step that isn’t needed with regular tables. When working with temporary tables, each buffer (variable) of the same table can refer to a different set of temporary data. Therefore using the …

Continue reading ‘Query/QueryRun with temporary tables (AX/F&O)’ »

Public preview of the new F&O dev experience

Something that was talked about for a long time is getting closer to reality. F&O development will no longer require those huge VMs with SQL Server and everything. Instead, you’ll just install some VS extensions, connect to Dataverse, download F&O code and metadata and start developing. The runtime (web server, database) will be in cloud, …

Continue reading ‘Public preview of the new F&O dev experience’ »

Monitoring and telemetry in F&O

Applications Insights in an Azure service for monitoring of applications. Many Azure Services support it out of the box – you just connect, say, an Azure Function to Application Insights and it’ll automatically start collecting information about performance, failed requests and so on. Using Application Insights API from D365FO is possible and several people in …

Continue reading ‘Monitoring and telemetry in F&O’ »