ACactiontech
SqlManage

获取管控sql列表

get sql manage list

get/v1/projects/{project_name}/sql_manages

Request

  • Base URL
    /sqle (relative, and the document was published on a file host, not at the API’s origin)
  • URL
    /sqle/v1/projects/{project_name}/sql_manages
  • Auth
    API key in header Authorization

Path parameters

project_namestring required

project name

Query parameters

fuzzy_search_sql_fingerprintstring

fuzzy search sql fingerprint

filter_assigneestring

assignee

filter_instance_namestring

instance name

filter_source'audit_plan' | 'sql_audit_record'

source

filter_audit_level'normal' | 'notice' | 'warn' | 'error'

audit level

filter_last_audit_start_time_fromstring

last audit start time from

filter_last_audit_start_time_tostring

last audit start time to

filter_status'unhandled' | 'solved' | 'ignored' | 'manual_audited'

status

filter_rule_namestring

rule name

filter_db_typestring

db type

fuzzy_search_endpointstring

fuzzy search endpoint

fuzzy_search_schema_namestring

fuzzy search schema name

sort_field'first_appear_timestamp' | 'last_receive_timestamp' | 'fp_count'

sort field

sort_order'asc' | 'desc'

sort order

page_indexinteger required

page index

page_sizeinteger required

size of per page

Response

OK

codeinteger
messagestring
sql_manage_bad_numinteger
sql_manage_optimized_numinteger
sql_manage_total_numinteger

Example response

{
  "data": [
    {
      "audit_result": [
        {
          "level": "warn",
          "message": "避免使用不必要的内置函数md5()"
        }
      ]
    }
  ],
  "message": "ok"
}

Changes

No recorded changes to this operation across all 75 revisions of this API.