Jan-11-2021, 04:57 PM
Hi there. I am new to python and I'm attempting to use the capiq-python api to create a dataframe. I'm hoping that someone with a Capital IQ account would be able to debug the issue below. (Note that USERNAME and PASSWORD in the code below is in place of my actual username and password
When I run this code script (I've run it in R using the Reticulate package)
When I run this code script (I've run it in R using the Reticulate package)
from capiq.capiq_client import CapIQClient ciq_client = CapIQClient("USERNAME", "PASSWORD") data = ciq_client.gdshe(['WMT:', "ibm:"],['IQ_CLOSEPRICE'], ['close_price'], start_date='11/12/2010',end_date='11/18/2010') data_content = json.loads(data)I get the following error
Error in py_run_file_impl(file, local, convert) : JSONDecodeError: Expecting value: line 1 column 1 (char 0)Any ideas on how to debug this? TIA!