Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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?

Labels (2)
1 Reply
Anonymous
Not applicable
Author

solved. I've entered wrong url