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

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 3

Read about some useful Context Variable ideas

Blog