I've got an issue to extract values from JSON array. I used tFileInputJSON component as the JSON input and set 'read by' to JsonPath without loop and tick the 'Use URL' checkbox. The URL I insert is "https://financialmodellingprep.com/api/v3/historical-price-full/msft" . Based on the JSON from the URL, I can only extract and parse the 'symbol' value. For 'historical' value, the output shown as in the picture. But then, I try to copy the JSON and make it into .json file format. I try to do the same thing with 'historical', and the result appear accordingly. May I know what is happening between the URL and file?
Watch the recorded webinar!
Read about some useful Context Variable ideas
Taken a look at the Talend Studio improvements for API Services
Take a look at some Data Integration success stories
Learn how and why companies are moving to the Cloud