Tutorial
By calling http://api.fixer.io/latest?base=SGD, the following will be returned.
JSON Data
{
"base": "SGD",
"date": "2015-12-21",
"rates": {
"AUD": 0.99092,
"BGN": 1.2777,
"BRL": 2.8235
}
}
In JSON, curly bracket denotes an object. Square bracket denotes an array.
Because there's no array that we can iterate through, therefore, this is the only way of configuring it. Only one record will be created for this case.
If your JSON URL returns the following,
JSON Data
{
"base": "SGD",
"date": "2015-12-21",
"rates": [
{ "currency" : "AUD",
"rate" : 0.99092
},
{ "currency" : "BGN",
"rate" : 1.2777
},
{ "currency" : "BRL",
"rate" : 2.8235
}
]
}
Then you can configure as follow and make use of the "Base JSON Object Name for Multirow Data" where it will iterate through the array and create multiple records.
