How can i execute the following code using pycurl

Question

curl https://api.smartsheet.com/1.1/sheets -H "Authorization: Bearer 26lhbngfsybdayabz6afrc6dcd" -H "Content-Type: application/json" -X POST -d @test.json

Answer 1

If you are new to coding, then don't use pycurl it is generally considered obsolete. Instead use requests which can be installed with pip install requests.

Here is how to do the equivalent with requests:

import requests

with open('test.json') as data:
    headers = {'Authorization': 'Bearer 26lhbngfsybdayabz6afrc6dcd'
               'Content-Type' : 'application/json'}
    r = requests.post('https://api.smartsheet.com/1.1/sheets', headers=headers, data=data)
print r.json

If you must use pycurl I suggest that you start reading here. Generally it would be done by this (untested) code:

import pycurl

with open('test.json') as json:
    data = json.read()

    c = pycurl.Curl()
    c.setopt(pycurl.URL, 'https://api.smartsheet.com/1.1/sheets')
    c.setopt(pycurl.POST, 1)
    c.setopt(pycurl.POSTFIELDS, data)
    c.setopt(pycurl.HTTPHEADER, ['Authorization: Bearer 26lhbngfsybdayabz6afrc6dcd',
                                 'Content-Type: application/json'])
    c.perform()

This shows that requests is far more elegant.