topic Re: Build a STOCKS database with DATA IN JSON FORMAT via API in QlikView

Build a STOCKS database

jtandersen — Mon, 26 Jan 2026 21:26:37 GMT

Closing this

Re: Build a STOCKS database with DATA IN JSON FORMAT via API

Frank_Hartmann — Sat, 27 Feb 2021 11:12:58 GMT

Python is your friend. See attached files as a starting point. I created 3 Python Scripts, for each location one which are called at the beginning of the script (Please adapt the path according your environment). These scripts are extracting the data to the corresponding csv file and afterwards the csv files can be loaded in QV script.

Further details and requirements are here:

https://community.qlik.com/t5/Qlik-Sense-App-Development/How-to-load-local-JSON-file-into-Qlik-Sense/m-p/1770580#M59630

hope this helps

Re: Build a STOCKS database with DATA IN JSON FORMAT via API

jtandersen — Mon, 01 Mar 2021 22:19:58 GMT

Hi Frank

Thank you very much, very kind of you

I will test this and give you feedback

Kind regards

John

Re: Build a STOCKS database with DATA IN JSON FORMAT via API

jtandersen — Sun, 07 Mar 2021 21:48:28 GMT

Hi Frank

Thanks for the script

I have a questions

How can I combine my Excelsheet with all my stocks.
My Excelsheet could look like this

TICKER_SYMBOL, STOCK_NAME

Thanks

Regards

John

Re: Build a STOCKS database with DATA IN JSON FORMAT via API

jtandersen — Thu, 25 Mar 2021 14:42:05 GMT

Hi Frank

Hope you are well

can you (or anyone else) tell me how I can combine an Excelsheet with all my stocks and then import data into Qlik for all of them?

Thank you

Take care