Hello All,
I tried to read through the JSON provider PP command the following URL :
But it does not work.
When I tried on https://jsonpath.com though it works:
My intuition is that the row data from the URL starts with a [ . Could that be the problem and if yes how could I get rid of this bracket ?
Thanks
The trailing comma needs to go, and you need to fill in the path to the quote itself (Path to Close) as well.
Thanks, I suppressed the trailing coma and add the value but still it does not work.
There is something to do with the URL link where read in PP ?
Any idea ?
Upon to List Paths in JSON it should be obj[0].price[*].dateTime and obj[0].price[*].value. But this is not save as I’m not familiar with JSON at all 
It would probably work, but Bloomberg sends a web page with a CAPTCHA instead of the data.
Maybe if you wait a few hours and don’t retrieve it too often …
https://tools.morningstar.co.uk/api/rest.svc/timeseries_price/t92wz0sj7c?currencyId=GBP&idtype=Morningstar&frequency=daily&outputType=JSON&startDate=2020-12-31&id=F00000ZB0M]2]0]FOGBR$$ALL
{ "TimeSeries": { "Security": [ { "HistoryDetail": [ {"EndDate": "2020-12-31", "Value": "3.418" }, {"EndDate": "2021-01-04", "Value": "3.454" }, {"EndDate": "2021-01-05", "Value": "3.464" }, {"EndDate": "2021-01-06", "Value": "3.465" }, {"EndDate": "2021-01-07", "Value": "3.522" }, {"EndDate": "2021-01-08", "Value": "3.626" }, {"EndDate": "2021-01-11", "Value": "3.697" }, {"EndDate": "2021-01-12", "Value": "3.632" }, {"EndDate": "2021-01-13", "Value": "3.649" }, {"EndDate": "2021-01-14", "Value": "3.675" }, {"EndDate": "2021-01-15", "Value": "3.673" }, {"EndDate": "2021-01-18", "Value": "3.691" }, {"EndDate": "2021-01-19", "Value": "3.703" }, {"EndDate": "2021-01-20", "Value": "3.718" }, {"EndDate": "2021-01-21", "Value": "3.776" }, {"EndDate": "2021-01-22", "Value": "3.763" }, {"EndDate": "2021-01-25", "Value": "3.8" }, {"EndDate": "2021-01-26", "Value": "3.826" }, {"EndDate": "2021-01-27", "Value": "3.759" }, {"EndDate": "2021-01-28", "Value": "3.637" }, {"EndDate": "2021-01-29", "Value": "3.68" }, {"EndDate": "2021-02-01", "Value": "3.701" }, {"EndDate": "2021-02-02", "Value": "3.766" }, {"EndDate": "2021-02-03", "Value": "3.813" }, {"EndDate": "2021-02-04", "Value": "3.803" }, {"EndDate": "2021-02-05", "Value": "3.812" }, {"EndDate": "2021-02-08", "Value": "3.838" }, {"EndDate": "2021-02-09", "Value": "3.865" }, {"EndDate": "2021-02-10", "Value": "3.841" }, {"EndDate": "2021-02-11", "Value": "3.83" }, {"EndDate": "2021-02-12", "Value": "3.873" }, {"EndDate": "2021-02-15", "Value": "3.896" }, {"EndDate": "2021-02-16", "Value": "3.923" }, {"EndDate": "2021-02-17", "Value": "3.853" }, {"EndDate": "2021-02-18", "Value": "3.816" }, {"EndDate": "2021-02-19", "Value": "3.768" }, {"EndDate": "2021-02-22", "Value": "3.785" }, {"EndDate": "2021-02-23", "Value": "3.631" }, {"EndDate": "2021-02-24", "Value": "3.577" }, {"EndDate": "2021-02-25", "Value": "3.594" }, {"EndDate": "2021-02-26", "Value": "3.536" }, {"EndDate": "2021-03-01", "Value": "3.583" }, {"EndDate": "2021-03-02", "Value": "3.633" }, {"EndDate": "2021-03-03", "Value": "3.568" }, {"EndDate": "2021-03-04", "Value": "3.427" }, {"EndDate": "2021-03-05", "Value": "3.356" }, {"EndDate": "2021-03-08", "Value": "3.339" }, {"EndDate": "2021-03-09", "Value": "3.282" }, {"EndDate": "2021-03-10", "Value": "3.362" }, {"EndDate": "2021-03-11", "Value": "3.381" }, {"EndDate": "2021-03-12", "Value": "3.459" }, {"EndDate": "2021-03-15", "Value": "3.43" }, {"EndDate": "2021-03-16", "Value": "3.506" }, {"EndDate": "2021-03-17", "Value": "3.468" }, {"EndDate": "2021-03-18", "Value": "3.459" }, {"EndDate": "2021-03-19", "Value": "3.385" }, {"EndDate": "2021-03-22", "Value": "3.429" }, {"EndDate": "2021-03-23", "Value": "3.483" }, {"EndDate": "2021-03-24", "Value": "3.451" }, {"EndDate": "2021-03-25", "Value": "3.383" }, {"EndDate": "2021-03-26", "Value": "3.369" }, {"EndDate": "2021-03-29", "Value": "3.385" }, {"EndDate": "2021-03-30", "Value": "3.351" }, {"EndDate": "2021-03-31", "Value": "3.353" }, {"EndDate": "2021-04-01", "Value": "3.463" }, {"EndDate": "2021-04-06", "Value": "3.486" }, {"EndDate": "2021-04-07", "Value": "3.524" }, {"EndDate": "2021-04-08", "Value": "3.535" }, {"EndDate": "2021-04-09", "Value": "3.586" }, {"EndDate": "2021-04-12", "Value": "3.579" }, {"EndDate": "2021-04-13", "Value": "3.587" }, {"EndDate": "2021-04-14", "Value": "3.65" }, {"EndDate": "2021-04-15", "Value": "3.643" }, {"EndDate": "2021-04-16", "Value": "3.68" }, {"EndDate": "2021-04-19", "Value": "3.661" }, {"EndDate": "2021-04-20", "Value": "3.557" }, {"EndDate": "2021-04-21", "Value": "3.534" }, {"EndDate": "2021-04-22", "Value": "3.627" }, {"EndDate": "2021-04-23", "Value": "3.63" }, {"EndDate": "2021-04-26", "Value": "3.654" }, {"EndDate": "2021-04-27", "Value": "3.715" }, {"EndDate": "2021-04-28", "Value": "3.691" }, {"EndDate": "2021-04-29", "Value": "3.681" }, {"EndDate": "2021-04-30", "Value": "3.612" }, {"EndDate": "2021-05-04", "Value": "3.58" }, {"EndDate": "2021-05-05", "Value": "3.532" }, {"EndDate": "2021-05-06", "Value": "3.509" }, {"EndDate": "2021-05-07", "Value": "3.458" }, {"EndDate": "2021-05-10", "Value": "3.445" }, {"EndDate": "2021-05-11", "Value": "3.31" }, {"EndDate": "2021-05-12", "Value": "3.315" }, {"EndDate": "2021-05-13", "Value": "3.241" }, {"EndDate": "2021-05-14", "Value": "3.249" }, {"EndDate": "2021-05-17", "Value": "3.29" }, {"EndDate": "2021-05-18", "Value": "3.28" }, {"EndDate": "2021-05-19", "Value": "3.277" }, {"EndDate": "2021-05-20", "Value": "3.28" }, {"EndDate": "2021-05-21", "Value": "3.343" }, {"EndDate": "2021-05-24", "Value": "3.362" }, {"EndDate": "2021-05-25", "Value": "3.418" }, {"EndDate": "2021-05-26", "Value": "3.431" }, {"EndDate": "2021-05-27", "Value": "3.445" }, {"EndDate": "2021-05-28", "Value": "3.464" }, {"EndDate": "2021-06-01", "Value": "3.502" }, {"EndDate": "2021-06-02", "Value": "3.495" }, {"EndDate": "2021-06-03", "Value": "3.494" }, {"EndDate": "2021-06-04", "Value": "3.459" }, {"EndDate": "2021-06-07", "Value": "3.51" }, {"EndDate": "2021-06-08", "Value": "3.556" }, {"EndDate": "2021-06-09", "Value": "3.533" }, {"EndDate": "2021-06-10", "Value": "3.571" }, {"EndDate": "2021-06-11", "Value": "3.591" }, {"EndDate": "2021-06-14", "Value": "3.633" }, {"EndDate": "2021-06-15", "Value": "3.626" }, {"EndDate": "2021-06-16", "Value": "3.586" }, {"EndDate": "2021-06-17", "Value": "3.584" }, {"EndDate": "2021-06-18", "Value": "3.657" }, {"EndDate": "2021-06-21", "Value": "3.633" }, {"EndDate": "2021-06-22", "Value": "3.653" }, {"EndDate": "2021-06-23", "Value": "3.687" }, {"EndDate": "2021-06-24", "Value": "3.698" }, {"EndDate": "2021-06-25", "Value": "3.746" }, {"EndDate": "2021-06-28", "Value": "3.729" }, {"EndDate": "2021-06-29", "Value": "3.788" }, {"EndDate": "2021-06-30", "Value": "3.806" }, {"EndDate": "2021-07-01", "Value": "3.816" }, {"EndDate": "2021-07-02", "Value": "3.803" }, {"EndDate": "2021-07-05", "Value": "3.786" }, {"EndDate": "2021-07-06", "Value": "3.783" }, {"EndDate": "2021-07-07", "Value": "3.812" }, {"EndDate": "2021-07-08", "Value": "3.758" }, {"EndDate": "2021-07-09", "Value": "3.756" }, {"EndDate": "2021-07-12", "Value": "3.77" }, {"EndDate": "2021-07-13", "Value": "3.795" }, {"EndDate": "2021-07-14", "Value": "3.78" }, {"EndDate": "2021-07-15", "Value": "3.75" }, {"EndDate": "2021-07-16", "Value": "3.749" }, {"EndDate": "2021-07-19", "Value": "3.798" }, {"EndDate": "2021-07-20", "Value": "3.845" }, {"EndDate": "2021-07-21", "Value": "3.924" }, {"EndDate": "2021-07-22", "Value": "3.945" }, {"EndDate": "2021-07-23", "Value": "3.963" }, {"EndDate": "2021-07-26", "Value": "3.995" }, {"EndDate": "2021-07-27", "Value": "3.938" }, {"EndDate": "2021-07-28", "Value": "3.888" }, {"EndDate": "2021-07-29", "Value": "3.936" }, {"EndDate": "2021-07-30", "Value": "3.928" }, {"EndDate": "2021-08-02", "Value": "3.976" }, {"EndDate": "2021-08-03", "Value": "3.993" }, {"EndDate": "2021-08-04", "Value": "4.054" }, {"EndDate": "2021-08-05", "Value": "4.128" }, {"EndDate": "2021-08-06", "Value": "4.154" }, {"EndDate": "2021-08-09", "Value": "4.135" }, {"EndDate": "2021-08-10", "Value": "4.234" }, {"EndDate": "2021-08-11", "Value": "4.211" }, {"EndDate": "2021-08-12", "Value": "4.111" }, {"EndDate": "2021-08-13", "Value": "4.136" }, {"EndDate": "2021-08-16", "Value": "4.122" }, {"EndDate": "2021-08-17", "Value": "4.101" }, {"EndDate": "2021-08-18", "Value": "4.132" }, {"EndDate": "2021-08-19", "Value": "4.122" }, {"EndDate": "2021-08-20", "Value": "4.093" }, {"EndDate": "2021-08-23", "Value": "4.142" }, {"EndDate": "2021-08-24", "Value": "4.208" }, {"EndDate": "2021-08-25", "Value": "4.217" }, {"EndDate": "2021-08-26", "Value": "4.225" }, {"EndDate": "2021-08-27", "Value": "4.206" }, {"EndDate": "2021-08-31", "Value": "4.234" }, {"EndDate": "2021-09-01", "Value": "4.232" }, {"EndDate": "2021-09-02", "Value": "4.264" }, {"EndDate": "2021-09-03", "Value": "4.282" }, {"EndDate": "2021-09-06", "Value": "4.317" }, {"EndDate": "2021-09-07", "Value": "4.313" }, {"EndDate": "2021-09-08", "Value": "4.314" }, {"EndDate": "2021-09-09", "Value": "4.259" }, {"EndDate": "2021-09-10", "Value": "4.292" } ], "Id": "F00000ZB0M" } ] }}
https://www.bloomberg.com/markets2/api/history/WASRIRD%3ALX/PX_LAST?timeframe=6_MONTH&period=daily&volumePeriod=daily
[{"ticker":"WASRIRD:LX","previousClosingPriceOneTradingDayAgo":null,"openPrice":null,"range":null,"price":[{"dateTime":"2021-03-16","value":115.96},{"dateTime":"2021-03-23","value":115.28},{"dateTime":"2021-03-30","value":116.8},{"dateTime":"2021-04-06","value":118.13},{"dateTime":"2021-04-13","value":118.04},{"dateTime":"2021-04-20","value":117.59},{"dateTime":"2021-04-27","value":118.69},{"dateTime":"2021-05-04","value":117.26},{"dateTime":"2021-05-11","value":116.86},{"dateTime":"2021-05-18","value":117.3},{"dateTime":"2021-05-25","value":118.05},{"dateTime":"2021-06-01","value":118.75},{"dateTime":"2021-06-08","value":119.77},{"dateTime":"2021-06-15","value":120.71},{"dateTime":"2021-06-22","value":121.63},{"dateTime":"2021-06-29","value":122.83},{"dateTime":"2021-07-06","value":122.9},{"dateTime":"2021-07-13","value":124.18},{"dateTime":"2021-07-20","value":122.02},{"dateTime":"2021-07-27","value":122.34},{"dateTime":"2021-08-03","value":124.1},{"dateTime":"2021-08-10","value":126.13},{"dateTime":"2021-08-17","value":125.81},{"dateTime":"2021-08-24","value":126.7},{"dateTime":"2021-08-31","value":126.95},{"dateTime":"2021-09-07","value":127.26}],"volume":[]}]
The first example (morningstar) is valid JSON.
Is the second example (bloomberg) valid JSON? Look at the outer square brackets.
I agree with you ProgFriese. There should be a way to remove this square brackets maybe through an instruction path in the URL feed ?
Would you have any hint how to proceed to remove them ?
Well, yes – it’s a single-element array, isn’t it? Replacing $ with $[0] or $[*] might do it, if that’s the problem; but as I said, Bloomberg quickly stopped delivering the JSON at all for me.