Auto-sort using API

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)