Different between JSON file and JSON URL in tFileInputJSON in parsing array values

Highlighted
Five Stars

Different between JSON file and JSON URL in tFileInputJSON in parsing array values

Hi,

 

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?

Five Stars

Re: Different between JSON file and JSON URL in tFileInputJSON in parsing array values

solved. I've entered wrong url

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 3

Read about some useful Context Variable ideas

Blog

Talend Studio Improvements for API Services

Taken a look at the Talend Studio improvements for API Services

Watch Now

Data Integration Success Stories

Take a look at some Data Integration success stories

Read

Why Companies Move to the Cloud: 7 Success Stories

Learn how and why companies are moving to the Cloud

Read Now