Table Operation: Delete Record

# Library for communicating with websites and APIs
import requests

# Library for JSON operations
import json

# Server name and API key
BASE_URL = "【Server name】"  # e.g., http://server
API_KEY = "【API key】"

# Site ID to start the search from
START_SITE_ID = 【Site ID】

# Target site name and status to delete
TARGET_SITE_NAME = "【Site name】"
TARGET_STATUS = '["910"]'

# Share the session
session = requests.Session()
session.headers.update({"Content-Type": "application/json"})

# Common function for JSON POST requests
def post_json(url: str, payload: dict) -> dict:
    r = session.post(url, data=json.dumps(payload))
    if not r.ok:
        raise RuntimeError(f"HTTP {r.status_code} {url}\n{r.text}")
    return r.json()

# 1) Get the SiteId from the site name
getclosest_url = f"{BASE_URL}/api/items/{START_SITE_ID}/getclosestsiteid"
closest_payload = {
    "ApiVersion": 1.1,
    "ApiKey": API_KEY,
    "FindSiteNames": [TARGET_SITE_NAME],
}

closest_res = post_json(getclosest_url, closest_payload)
data_list = closest_res.get("Data", [])
if not data_list:
    print(f"{TARGET_SITE_NAME} Failed to get the site information")
    raise SystemExit()

site_id = data_list[0].get("SiteId")

if not isinstance(site_id, int) or site_id <= 0:
    print(f"{TARGET_SITE_NAME} Invalid site ID: {site_id}")
    raise SystemExit()

print(f"Got the target site ID: {site_id}")

# 2) Get the records with Status=910 (multiple records)
get_url = f"{BASE_URL}/api/items/{site_id}/get"
get_payload = {
    "ApiVersion": 1.1,
    "ApiKey": API_KEY,
    "View": {
        "ColumnFilterHash": {
            "Status": TARGET_STATUS,
        }
    },
}

get_res = post_json(get_url, get_payload)

rows = []
if isinstance(get_res, dict):
    rows = (get_res.get("Response", {}) or {}).get("Data", []) or []
elif isinstance(get_res, list):
    rows = get_res

if not rows:
    print("No data to delete")
    raise SystemExit()

# 3) Delete the retrieved records one by one
for row in rows:
    record_id = row.get("ResultId") or row.get("Id")
    if not record_id:
        continue

    delete_url = f"{BASE_URL}/api/items/{record_id}/delete"
    delete_payload = {
        "ApiVersion": 1.1,
        "ApiKey": API_KEY,
    }

    try:
        post_json(delete_url, delete_payload)
        print(f"Deleted: Id={record_id}")
    except Exception as e:
        print(f"Failed to delete: Id={record_id}")
        print(e)