{"dataset":{"id":11304240,"dataset_code":"GOLD","database_code":"LBMA","name":"Gold Price: London Fixing","description":"Gold Price: London Fixings, London Bullion Market Association (LBMA). Fixing levels are set per troy ounce.\nThe London Gold Fixing Companies set the prices for gold that are globally considered as the international standard for pricing of gold.\nThe Gold price in London is set twice a day by five LBMA Market Makers who comprise the London Gold Market Fixing Limited (LGMFL).\nThe process starts with the announcement from the Chairman of the LGMFL to the other members of the LBMA Market Makers, then relayed to the dealing rooms where customers can express their interest as buyers or sellers and also the quantity they wish to trade. The gold fixing price is then set by collating bids and offers until the supply and demand are matched. At this point the price is announced as the 'Fixed' price for gold and all business is conducted on the basis of that price.","refreshed_at":"2018-01-26T23:55:57.414Z","newest_available_date":"2018-01-26","oldest_available_date":"1968-01-02","column_names":["Date","EURO (PM)"],"frequency":"daily","type":"Time Series","premium":false,"limit":1,"transform":null,"column_index":6,"start_date":"1968-01-02","end_date":"2018-01-26","data":[["2018-01-26",1087.8]],"collapse":null,"order":null,"database_id":139}}
Maybe the wildcard * causes it to prepare an array.
Are you expecting several values there?
If not you could try $.dataset.data[0].[1]
This will give you the first data element and then the value afterwards.
But it would be better to mark this post as solution:
And not the one explaining how to mark a post as solved.
Other users may be confused when they are looking for a jsonpath solution and find a tutorial on how to solve a topic.