Auto-sort using API

Hazika Reshi

I understand that as of now it is not possible to auto-sort columns in Smartsheet. But is there an API code that can be used to sort columns alphabetically?

kskarz

Hi @Hazika Reshi

You can sort columns using API:

https://smartsheet.redoc.ly/tag/rows#operation/rows-sort

If you have a webhook in place you can have a auto-sort as soon as the data is saved in the sheet.

Laurie Mason

Kskarz,

I found an Python script on another thread that should work, but I keep getting an error message (below). Any suggestions?

Error sorting sheet. Status code: 405

"errorCode" : 1122,

"message" : "Requested URL does not support this method: PUT",

Here is the script I used:

import requests

import json

# Smartsheet API access token

access_token = {'YOUR API TOKEN HERE'}

# Smartsheet sheet ID

sheet_id = {'YOUR SHEET ID HERE'}

# Define the endpoint for the API

url = f'https://api.smartsheet.com/2.0/sheets/{sheet_id}/sort'

# Define the headers

headers = {

  'Authorization': f'Bearer {access_token}',

  'Content-Type': 'application/json'

}

# Define the sorting criteria

sort_criteria = [

  {

    "columnId": {YOUR COLUMN ID HERE},

    "direction": "ASC" # or "DESC" for descending

  }

]

# Define the payload

payload = {

  "sortSpecifiers": sort_criteria

}

# Send the request to Smartsheet API

response = requests.put(url, headers=headers, data=json.dumps(payload))

# Check if the request was successful

if response.status_code == 200:

  print("Sheet sorted successfully.")

else:

  print(f"Error sorting sheet. Status code: {response.status_code}")

  print(response.text)

Laurie Mason

@kskarz

I figured out that you must use the post method instead instead of put. However, I am now getting a an error messages on the line below saying the payload "Object of type set is not JSON serializable".

response = requests.putpost(url, headers=headers, data=json.dumps(payload))

Do you have any ideas that could help?

Hazika Reshi

https://community.smartsheet.com/discussion/comment/416395#Comment_416395

Hi Kskarz,

Thank you so much for this.

I just wanted to follow up with a few things.

i do not have a webhook in place. how would i go about getting one to smartsheets?

Also, once i do have a webhook in place, how would i go about integrating the code from the link for it to actually work?

I realize the questions are a bit broad, but I am just looking for a general direction to go about doing this

Thanks so much!

SSFeatures

Hi @Hazika Reshi and @Laurie Mason, I built a browser extension (SSFeatures) that lets you sort automatically directly within Smartsheet, without needing to use any APIs.

With SSFeatures, you'll find this "Sort Automatically" button that you can click to enable automatic sorting.

I hope this helps!