Smartsheet APIs allow its licensed users to access and modify the Smartsheet data and also various accounts of their organization periodically. However, unlike other APIs, Smartsheet API saves your time and money and makes the entire process of creating software flawlessly.

Moreover, if you are new to this process and don’t know anything about modifying the Smartsheet data, we can help you. Hence, here is how you can modify Smartsheet data through their APIs.

Add rows

With this, you can insert a single or more than one row into the sheet specified in the URL. Also, for inserting the rows in any position other than the default, you need to use location-specific attributes.

Further, to add rows, you need to implement the following code:

Headers

Authorization: Bearer ll352u9jujauoqz4gstvsae05

Content-Type: application/json

Parameters

AllowPartialSuccess: when specified with a value of true, this function allows partial success for the bulk operation.

OverrideValidation: If you want to value a cell outside of the validation limits, you need to use overrideValidation. However, you should mention strict with false value to avoid value type checking.

Request Body

Moreover, the request body may contain the following attributes. However, all the attributed are optional if ‘required’ is not mentioned.

  • One or more location-specifier attributes
  • expanded
  • format
  • cells – if it is specified, there should be an array of cell objects. And, each object should limit to the following attributes:
    – columnId (required)
    – also, either formula or value (the formula is number for the cell, and you need to define a cross-sheet reference for cross-sheet formulas.)
    – moreover, if you specify the value, you can either specify hyperlink with one of the attributes reportId, sheetId, URL, or linkInFromCell with all the attributes columnId, rowId and sheeted. But both hyperlink and linkInFromCell are optional.
    – strict
    – format
    – also, image – if you specify the image, make sure to update alternate text, where altText = string.
    – overrideValidation
  • locked – if you want to lock the row, mention true and false if you want to unlock the row.

Update rows

Headers

Authorization: Bearer ll352u9jujauoqz4gstvsae05
Content-Type: application/json

Parameters

AllowPartialSuccess: also, when specified with a value of true, the string allows partial success for this bulk operation.

OverrideValidation: Moreover, if you want to value a cell outside of the validation limits, you need to use overrideValidation. However, you should mention strict with false value to avoid value type checking.

Request body

Use the following attributes for request body:

  • id (required)
  • One or more than one location-specifier attributes
  • expanded
  • format
  • cells – if it is specified, there should be an array of cell objects. Also, each object should limit to the following attributes:

– column (required)
– moreover, either formula or value (the formula is number for the cell, and you need to define a cross-sheet reference for cross-sheet formulas.)
– also, if you specify the value, you can either specify hyperlink with one of the attributes reportId, sheetId, URL, or linkInFromCell with all the                                     attributes columnId, rowId and sheeted. But both hyperlink and linkInFromCell are optional.
– strict
– format
– image – if the image is specified, you need to mention ALT text = string
– overrideValidation

  • locked – Hence, true for locking the row and false for unlocking the row.

Add column

Headers

Authorization: Bearer ll352u9jujauoqz4gstvsae05
Content-Type: application/json

Request Body

The request body for the adding the column may contain the following attributes:

  • title
  • type
  • index (zero-based)
  • auto Number Format
  • description
  • locked
  • options
  • symbol
  • system Column Type
  • validation
  • also, the width

Update column

Headers

Authorization: Bearer ll352u9jujauoqz4gstvsae05
Content-Type: application/json

Request body

Moreover, the request body for the updating the column may contain the following attributes:

  • index
  • auto Number Format
  • contact Options – set column type to CONTACT_LIST
  • description
  • format
  • hidden
  • locked
  • options
  • symbol
  • systemColumnType
  • title
  • type
  • validation
  • width

Conclusion

Therefore, if you need any more help with Smartsheet and APIs, get in touch with us. Also, we at the dynamic duo can provide you with technical expertise. Also, it will be regarding Smartsheet API for the flawless working of your organization.