Can anybody point me in the direction of a tutorial about configuring a Business Central Data Exchange Definition for importing Json data? I’ve created ones in the past to handle CSV data, but not Json.
This requirement is to work in conjunction with a Currency Exchange Rate Services set-up.
Here’s the format I need to handle:-
{
"disclaimer": "Usage subject to terms: https://openexchangerates.org/terms",
"license": "https://openexchangerates.org/license",
"timestamp": 1692266400,
"base": "USD",
"rates":
{
"AED": 3.67305,
"AFN": 84.67614,
"ALL": 96.873903,
"CAD": 1.352029,
"EUR": 0.919645,
"USD": 1
}
}
I’m looking for a tutorial page that first shows a sample bit of Json data and then describes how to configure the various BC pages to handle it? For instance, what should the various Codeunits be set to in the Data Exchange Definition page? Also, how do you map the various nodes/tags in the incoming Json to the Line Definitions, Column Definitions & Field Mapping? Note, in my sample Json, the rates tag is an array of key/value pairs (Currency-Code & Rate). How is that configured?
There’s also Field Mapping in the Currency Exch. Rate Service page. Where should the settings be assigned? In the Currency Exch. Rate Service page, the Data Exchange Definition page, both, other?