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?
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Read about some useful Context Variable ideas