gistfile1.txt

import requests
import json

def reimport(id):
    r = requests.get("{}/config/{}".format(sheets_api, id)).json()
    data = r['data']
    print str('loaded: ' + str(data))
    requests.delete("{}/config/{}".format(sheets_api, id))
    partitionkeys = data['partitionkeys']
    default = data['default']
    readonly = data['readonly']

    data = {'server':data['server'],
            'description':data['description'],
            'schemaname':data['schemaname'],
            'tablename':data['tablename'],
            'database':data['database'],
            'disabled' : False,
            'source':'mssql',
            'type':'sql',
            'schedule':'0 0 * * 5',
            'execute':data['execute'],
            'owner':data['owner']}
    requests.post("{}/config/".format(sheets_api), data=data)
    requests.post("{}/config/{}".format(sheets_api, id), data={'partitionkeys' : partitionkeys, 'readonly' : readonly, 'default' :default })
    return requests.get("{}/config/{}".format(sheets_api, id))

sheets_api = 'http://sheets.s03.filex.com/'
id = 'c84d8a23-8d47-5c02-ac65-b6eb45410cd1'


#['47394612-6e16-595f-bf9f-d29d7e266b4d','13925ad9-acd8-5e55-9358-b2497e2ee509']
r = reimport(id)


print str(r.json())