- Export sheets and rows as pandas dataframe and series respectively. #22
Install the package with pandas as extras:pip install simple-smartsheet[pandas]
- Add multi picklist support #28
- Do not crash when deleting many rows #25
- All crud methods directly on the
Sheet
object were removed, useSheetCrud
methods instead, e.g.smartsheet.sheets.add_rows
- Add a more specific constraint to marshmallow dependency (Fix #18)
- Fetch more than 100 rows in a report (Fix #19)
- Add exception
SmartsheetObjectNotFound
- Do not crash when an unknown field is encountered from API request
- Add new summary attributes to sheet and report schema #17 introduced by this feature https://help.smartsheet.com/learning-track/smartsheet-intermediate/sheet-summary
- Fix several bugs in some asyncio coroutines which were not awaited
- Add a number of integration tests against Smartsheet Developer sandbox
- [Deprecated] SheetCrud methods
add_row
,add_rows
,update_row
,update_rows
,delete_row
,delete_rows
as well as their async counterparts now havesheet_id: int
as a first argument instead ofsheet: Sheet
object. Deprecation warning is raised if you passSheet
object as the first argument.sort_rows
still usessheet
object as the first argument. - [Backwards incompatible] Result object now converts the received object data into an object itself. It is accessible via
result.obj
or propertyresult.result
which points to the same attribute. This is important in some cases, e.g. new sheet creation:result = smartsheet.sheets.create(new_sheet_skeleton)
.result.obj
will contain a newSheet
, whileresult.obj.id
will have an ID of a new sheet.
- Add asyncio support, check readme and
examples/async.py
for more details - [Deprecated] All methods on Sheet object, which do API call, like
add_rows
,update_rows
,delete_rows
,sort_rows
, they are now available undersmartsheet.sheets
and the first argument is sheet object
- Add support for Report objects
- [Backwards incompatible] Change the way indexes are handled,
build_index
method should be used on Sheet or Report objects - Unchecked checkboxes return False instead of None (#12)
- Add exceptions SmartsheetHTTPClientError and SmartsheetHTTPServerError
- Change models.extra.AutoNumberFormat to support absent arguments #7
- Handle invalid values in dates and datetimes columns #9
- Fix contactOptions in ColumnSchema #4
- Change default sorting order to ascending #3
- Add
sort_rows
method for Sheet object
- Add support for date fields
- Add
make_cell
andmake_cells
methods for Sheet object - Add
as_list
method for Sheet object
- Add marshmallow Schema to handle column options and tags #1
- Add
as_dict
method for Row object - Add custom index support and querying based on it
- Change metadata for the package on PyPi
- First release