获取数据库列表

获取数据库列表接口

使用GET发起请求，请求地址为/api/v1/stl/sqlContents

  1. GET /api/v1/stl/sqlContents HTTP/1.1

请求 URI

参数名 类型 必填 说明
queryString 字符串 是 SQL 语句
apiKey 字符串 否 API 密钥，请参考身份认证

/api/v1/stl/sqlContents的其他参数与<stl:sqlContents>标签一致。

返回

名称 类型 说明
200 OK 对象列表 返回数据库对象列表
401 Unauthorized Error 认证错误
400 BadRequest Error 参数错误

示例

请求示例

  1. GET /api/v1/stl/sqlContents?queryString=SELECT * FROM siteserver_Site
  2. X-SS-API-KEY: 7cd22002-27a7-4c5d-ba4d-a1c108a20eaf

返回示例

  1. {
  2.     "value": [
  3.         {
  4.             "id": 1116,
  5.             "siteName": "我的站点",
  6.             "siteDir": "test2",
  7.             "tableName": "model_Content",
  8.             "isRoot": "False",
  9.             "parentId": 0,
  10.             "taxis": 7,
  11.             "settingsXml": "charset=utf-8&configexporttype=ContentExcel&configexportperiods=0&configexportdisplayattributes=Id,Title,LinkUrl,AddDate,Hits,GroupNameCollection,Tags,FreeReadings,FullReadingPrice,PaidReadings,PaperPrice,SubTitle,ImageUrl,VideoUrl,FileUrl,Content,Summary,Author,Source&configexportischecked=All&apiurl=/api&homeurl=/home&ismultideployment=False&iscreatedoubleclick=True&siteurl=/Magazine&outersiteurl=/Magazine&innersiteurl=/Magazine&outerapiurl=/api&innerapiurl=/api&pagesize=3&configselectimagecurrenturl=upload/images&configuploadimageistitleimage=False&configuploadimagetitleimagewidth=152&configuploadimagetitleimageheight=109&configuploadimageistitleimagelesssizenotthumb=False&configuploadimageisshowimageintexteditor=False&configuploadimageislinktooriginal=False&configuploadimageissmallimage=False&configuploadimagesmallimagewidth=500&configuploadimagesmallimageheight=&configuploadimageissmallimagelesssizenotthumb=False&isseparatedweb=False&separatedweburl=http://web.chinacampus.org&issaveimageintexteditor=True&isautopageintexteditor=False&autopagewordnum=1500&iscontenttitlebreakline=False&lisautocheckkeywords=False&ischeckcontentlevel=False"
  12.         },
  13.         {
  14.             "id": 1288,
  15.             "siteName": "cc",
  16.             "siteDir": "cc",
  17.             "tableName": "model_Content",
  18.             "isRoot": "False",
  19.             "parentId": 1219,
  20.             "taxis": 9,
  21.             "settingsXml": "ischeckcontentlevel=False&charset=utf-8"
  22.         },
  23.         {
  24.             "id": 1292,
  25.             "siteName": "test11",
  26.             "siteDir": "test11",
  27.             "tableName": "model_Content",
  28.             "isRoot": "False",
  29.             "parentId": 0,
  30.             "taxis": 10,
  31.             "settingsXml": "charset=utf-8&configuploadimageistitleimage=True&configuploadimagetitleimagewidth=300&configuploadimagetitleimageheight=&configuploadimageistitleimagelesssizenotthumb=False&configuploadimageisshowimageintexteditor=True&configuploadimageislinktooriginal=False&configuploadimageissmallimage=True&configuploadimagesmallimagewidth=500&configuploadimagesmallimageheight=&configuploadimageissmallimagelesssizenotthumb=False&mingzi=SiteServer&gongsi=CMS&apiurl=/api&homeurl=/home&ismultideployment=False&iscreatedoubleclick=False&outerurl=&innerurl=&isseparatedweb=False"
  32.         }
  33.     ]
  34. }