Question

JSONDecodeError while running calling "download_dashboard_pdf.py" for exporting dashboard to pdf


Hi everyone, if anyone of you familiar with the looker API for noodlanding dashboard as pdf. I am facing some issue while passing filters in the code. Can you help me out.

I wants to add some filters on dashboard which are like below image.
 

But while parsing those filter values as argument in the API giving error. Any one knows how to avoid/resolve this error. Or what is the correct format to pass the filter values.

I am parsing the argument as below which is mentioned in the github API doc. 

example :$ python download_dashboard_pdf.py "A Test Dashboard" '{"filter1": "value1, value2", "filter2": "value3"}'

actual code I am passing :  $ python download_dashboard_pdf.py "A Test Dashboard" ‘{“Account name “: “AFB”}’

 


3 replies

Hello @manishkamble19 ,

 

Yes, I could help you with that, add the following two lines to the code before defining filters:

filter_dict = {"Filter 1": "Value 1", "Filter 2": "Value 2"}
json_object = json.dumps(filter_dict)

Then define filters as:

filters = json.loads(json_object)

 

This should resolve your error, hope this helps!

Thanks @Ranjit 1312  this solution works fine but one thing I have notice this is hard coded within code. But my requirement is to set this as argument while passing values at start of running script. And I want to apply only single filter.

If I pass this as argument which you have suggested its showing me following error.

passing only dashboard name as a argument is works fine but once I added filter {Account Name : AFB} its giving me below error.
 

@Ranjit 1312 do you know how to resolve this issue.

 

Were you finally able to download dashboard as pdf? I cud download but the corrupted one.. please help with the code if the download pdf worked for you. TIA

Reply