extracting data from uri

users
#1

Hi. I am working on a calc sheet and need to insert data from an url:

https://finance.google.com/finance/info?client=ig&q=NASDAQ%3AAAPL

I guess it generates a csv output (in the browser it is like:
// [ { "id": "22144" ,"t" : "AAPL" ,"e" : "NASDAQ" ,"l" : "99.92" ,"l_fix" : "99.92" ,"l_cur" : "99.92" ,"s": "0" ,"ltt":"12:13PM EDT" ,"lt" : "Jul 18, 12:13PM EDT" ,"lt_dts" : "2016-07-18T12:13:44Z" ,"c" : "+1.14" ,"c_fix" : "1.14" ,"cp" : "1.15" ,"cp_fix" : "1.15" ,"ccol" : "chg" ,"pcls_fix" : "98.78" } ]). I would need to isolate the number with 'l' label and insert it into a cell.

I also tried menu -> link external data -> url; it opens the page, sees the table, but doesn't show it in the dialog box (with the checkbox 'update every x seconds' .... bug??).

Thanks if you can help.

Paolo

#2

Je la 18/07/2016 18:20, Paolo Debortoli skribis :

Hi. I am working on a calc sheet and need to insert data from an url: https://finance.google.com/finance/info?client=ig&q=NASDAQ%3AAAPL I guess it generates a csv output (in the browser it is like: // [ { "id": "22144" ,"t" : "AAPL" ,"e" : "NASDAQ" ,"l" : "99.92" ,"l_fix" : "99.92" ,"l_cur" : "99.92" ,"s": "0" ,"ltt":"12:13PM EDT" ,"lt" : "Jul 18, 12:13PM EDT" ,"lt_dts" : "2016-07-18T12:13:44Z" ,"c" : "+1.14" ,"c_fix" : "1.14" ,"cp" : "1.15" ,"cp_fix" : "1.15" ,"ccol" : "chg" ,"pcls_fix" : "98.78" } ]). I would need to isolate the number with 'l' label and insert it into a cell. I also tried menu -> link external data -> url; it opens the page, sees the table, but doesn't show it in the dialog box (with the checkbox 'update every x seconds' .... bug??). Thanks if you can help. Paolo

If the structure is always the same locate the 15th ", cut keeping the right part, locate the next, cut keeping the left part.
The formula for the whole operation occupy a cell, next to the one which shall receive the data...

#3

Right, I saw it now. I guess it has been 80% my mistake, because the documentation says HTML files (at the end I completed the project using an html data source and it works fine).

However, I saw there is also a possibility of insert data in a json format (I did something, I don't know how). Data can be read in some cases and some way, but not used properly. I reported it as a bug, maybe it is not exactly, but the matter could be of some interest. Let's see.

Thanks for your advice.

Paolo

Hi. I am working on a calc sheet and need to insert data from an url:

The data you see is in JSON format
https://en.wikipedia.org/wiki/JSON

someone tried to make an extension for it 2 years ago, but it seems to
be not released right now:
http://extensions.libreoffice.org/extension-center?path=%2FLibreOffice-Extensions-and-Templates%2Fextension-center&portal_type=PSCProject&SearchableText=json