ServiceNow REST API:获取列名列表

import requests

# ServiceNow REST API的基础URL
base_url = "https://your_instance.service-now.com/api/now/table/"

# 要获取列名列表的表名
table_name = "your_table_name"

# 构建API请求URL
url = base_url + table_name + "/sys_columns"

# 设置请求头，包括认证信息和数据格式
headers = {
    "Content-Type": "application/json",
    "Authorization": "Bearer your_access_token"
}

# 发送GET请求并获取响应
response = requests.get(url, headers=headers)

# 解析响应数据
if response.status_code == 200:
    column_list = response.json().get("result")
    for column in column_list:
        column_name = column.get("name")
        data_type = column.get("type")
        is_primary_key = column.get("primary_key")
        # 打印列名、数据类型和是否为主键
        print("Column Name: ", column_name)
        print("Data Type: ", data_type)
        print("Is Primary Key: ", is_primary_key)
else:
    print("Failed to retrieve column list. Status code:", response.status_code)