python api proxy issue

gamattoon

I am new to this.  Trying to write a basic python script that uses the smartsheet api.  It runs fine from my home desktop, via python for windows.  However, when I run it at work on my laptop, I am encountering the '[WinError 10061] No connection could be made because the target machine actively refused it' error.  I am assuming this is proxy related.  I tried adding a proxies value, with same result.  Can someone tell me how to overcome this error?  See my latest attempt below:

import smartsheet

proxies = {

    'http://user:pw@proxy.net:9119',

    'https://user:pw@proxy.net:9119'

    }

smartsheet = smartsheet.Smartsheet(access_token='blablabla',proxies=proxies)

action = smartsheet.Sheets.get_columns(sheetidhere, include_all=True)

columns = action.data

for col in columns:

    print(col.id)

    print(col.title)

    print('')

 

 

dAVE Inden

Looking at your example it appears the proxies object isn't set correctly. It only has values with no attributes

Setting a proxy for the Python SDK is discussed in the Advanced.md file here:

https://github.com/smartsheet-platform/smartsheet-python-sdk/blob/master/ADVANCED.md#http-proxy

Try updating your proxies declaration to look like this:

proxies = { 'https': 'https://user:pw@proxy.net:9119' }

That should hopefully work to allow you to connect to the Smartsheet API via the Python SDK on your company laptop.