In this video, I show how to use openrates.io as a source for exchange rates. And as a bonus, watch me go crazy in error handling on a HttpClient call process.
Since I am very lazy and I didn’t find any AL code generator I decided to develop it on my own. My app gets a JSON file as input and, for each entity present, it automatically generates three files :
1) the AL table ;
2) the AL page ;
3) the AL API page ;
There are two objects we use in all JSON interfaces. We use the TempBlob table and our custom JSON Interface Codeunit.
JSON interface uses the same concept as a web service. The endpoint is defined by the Codeunit Name and the caller always supplies a form of request data (JSON) and expects a response data (JSON).
These interface calls therefore are only internal to the Business Central (NAV) server and are very fast. All the data is handled in memory only.