Creating a JSONPATH Query Talend <p>I am using CurrencyLayer to convert the following format in Talend. This is what the format looks like:</p> <pre><code>{ "success":true, "terms":"https:\/\/currencylayer.com\/terms", "privacy":"https:\/\/currencylayer.com\/privacy", "timestamp":1456950010, "source":"GBP", "quotes":{ "GBPUSD":1.406921, "GBPCAD":1.889923 } } { "success":true, "terms":"https:\/\/currencylayer.com\/terms", "privacy":"https:\/\/currencylayer.com\/privacy", "timestamp":1456950010, "source":"EUR", "quotes":{ "EURUSD":1.08665, "EURCAD":1.459701 } } { "success":true, "terms":"https:\/\/currencylayer.com\/terms", "privacy":"https:\/\/currencylayer.com\/privacy", "timestamp":1456950010, "source":"USD", "quotes":{ "USDCAD":1.343305 } } { "success":true, "terms":"https:\/\/currencylayer.com\/terms", "privacy":"https:\/\/currencylayer.com\/privacy", "timestamp":1456950010, "source":"CAD", "quotes":{ "CADUSD":0.744433 } } </code></pre> <p>Each will be a seperate API call. </p> <p>My database format looks like the following: CurrFrom, CurrTo, Rate, Date.</p> <p>Within Talend, I have created the FileInput using this URl and I can parse the timestamp, source. But how would I get the USD, CAD, and their respective rates and how would that be mapped to input into the database itself. </p> <p>help would be appreciated. </p>