- 管理端
- Workflow API
- 创建工作流
- 发送微信公众号模板消息
- 更新工作流
- 更新工作流日志
- 更新记录
- 更新并启用工作流
- trigger action
- 复制工作流
- 创建工作流日志
- 创建记 录
- activeWxRobotAction
- 激活发送微信小程序订阅消息节点
- 执行子流程节点
- activeStationMessageAction
- activeSendEmailAction
- 执行过滤器
- activeDingTalkRobotAction
- 激活代码执行节点动作流
- 阿里云发送消息
- 获取工作流的列表
- 获取工作流详情
- getWorkflowLog
- 获取使用了当前子流程的所有节点
- Get the execution logs for all workflows.
- 启用或关闭工作流
- 删除工作流
- User API
- Space API
- Page API
- create a page
- 复制页面到指定语言版本
- Batch add user groups that can view the page after getDingTalkAuthCode
- updateApp a page
- updateApp a Block
- 提交表单内容
- move a page
- 主要用于发布之后的微信分享回显
- create a Block
- Get all pages from the app
- get Record
- get a page
- get blocks
- Remove user groups that have visibility permission to the specified page
- delete a page
- delete a Block
- Integration API
- Env API
- Datasheet API
- 将同步表切换到指定环境PUT
- Copy dsPUT
- Update recordPOST
- Update the field in datasheetPOST
- Update the datasheetPOST
- Update the cellPOST
- Move the datasheetPOST
- Import Excel into a data sheetPOST
- Import Excel into a data sheet in append modePOST
- Gets all record contents for the specified field (de-duplicate)POST
- Retrieve one record from a specified data sourcePOST
- Retrieve a data sheetPOST
- Retrieve the schemas of multiple datasheetsPOST
- Export datasheet to excelPOST
- Get the number of rows in data sheetPOST
- Delete a recordPOST
- Delete a field in the datasheetPOST
- Create a sync data sheetPOST
- Create a recordPOST
- Create a Joined datasheetPOST
- Create a field in datasheetPOST
- Create a data sheetPOST
- Create a analytics datasheetPOST
- Analytics datasheet data previewGET
- 获取被同步表所在应用下所有环境下是否有该同步表GET
- Retrieve a specific record from a data sheetGET
- Deriving the actual data type based on a formulaGET
- Retrieve the schema of the datasheetGET
- Delete a data sheetDELETE
- 将同步表切换到指定环境
- App API
- 分享到邮箱
- 创建应用版本
- 创建应用断点
- Create an application
- 通过模板创建应用
- 创建分析配置
- 复制应用
- Update an application
- 更新应用同步block配置
- 更新应用状态，包含应用上线和离线
- 更新页面全局导航栏配置
- Update the domain of the application
- 更新应用断点
- Update an application
- 更新分析配置
- 切换到指定应用版本
- 更新版本预览状态
- 应用合并到线上版本并删除当前版本
- 查找引用
- 创建应用同步block
- 应用版本列表
- 模板组件列表
- Get all data sheets in the current application
- Get all data sheets in the current application
- 版本是否有更新
- 获取同步组件Block列表
- Get the binding status of a custom domain
- 获取使 用指定环境的应用
- Retrieve the basic information of an application
- 获取分析配置
- Create an application
- 应用断点列表
- 删除指定应用版本
- 批量删除同步block
- 删除应用同步block配置
- 删除应用断点
- Delete an application
- 删除分析配置
- View API
- Pay API
- Oss API
- Analysis API
- Wechat Open API
- Open API
- Pexels API
- Operation API
- Admin API
- Mini Program API
- 应用端
- 升级
- miniprogram
- loginPOST
- 未命名接口GET
- 未命名接口GET
Import Excel into a data sheet
POST
/lighthouse/admin/api/v1/ds/import
请求参数
Query 参数
Header 参数
Body 参数application/json
示例
{
"file": "string"
}请求示例代码
Shell
JavaScript
Java
Swift
Go
PHP
Python
HTTP
C
C#
Objective-C
Ruby
OCaml
Dart
R
请求示例请求示例
Shell
JavaScript
Java
Swift
curl --location --request POST '/lighthouse/admin/api/v1/ds/import?sheetName&envId' \
--header 'Lang: zh-CN' \
--header 'B-App-Id: {{B-App-Id}}' \
--header 'B-App-User-Id: {{B-App-User-Id}}' \
--header 'B-Origin-Domain: {{B-Origin-Domain}}' \
--header 'Cookie: {{Cookie}}' \
--header 'Content-Type: application/json' \
--data-raw '{
"file": "string"
}'返回响应
🟢200成功
*/*
Body
示例
{
"success": true,
"msg": "string",
"code": "string",
"content": [
{
"viewOptions": {
"dsId": "string",
"tableProps": [
{
"id": "string",
"width": 0,
"visible": true
}
],
"pagination": {
"pageSize": 0,
"currentPage": 0,
"custom": true
},
"joinConfig": {
"conditions": [
{
"joinedDsId": "string",
"joinType": "string",
"joinWhere": "string",
"joinConditions": [
{
"leftFieldId": "string",
"right": {
"type": "VARIABLE",
"fieldVariable": {
"dsId": "string",
"fieldId": "string"
},
"valueVariable": {
"value": {},
"type": "string"
},
"upstreamVariable": {
"nodeId": "string",
"fieldId": "string"
},
"fieldIdVariable": {
"fieldId": "string"
},
"systemVariable": {
"value": "TODAY",
"format": "string"
},
"userVariable": {
"fieldId": "string",
"format": "string"
},
"inputVariable": {
"blockId": "string",
"scope": "string"
},
"viewVariable": {
"fieldId": "string",
"format": "string"
},
"filterVariable": {
"blockId": "string",
"itemId": "string"
},
"argVariable": {
"nodeId": "string",
"argId": "string"
},
"selectDataSourceVariable": {
"dsId": "string",
"fieldId": "string",
"filter": {
"expression": {
"idVariable": {},
"operator": "string",
"paramList": [
{}
],
"where": "string",
"conditions": [
{}
]
}
},
"sorts": [
{
"id": "string",
"fieldId": "string",
"order": "ASC"
}
]
},
"pageLinkVariable": {
"value": {}
},
"formVariable": {
"fieldId": "string"
},
"resolvedVariable": {
"value": {},
"type": "string",
"innerType": "ARRAY"
},
"routePathVariable": {
"id": "string"
},
"routeQueryVariable": {
"id": "string"
},
"pageDataQueryVariable": {
"id": "string",
"itemId": "string"
},
"pageStateVariable": {
"id": "string"
},
"loopVariable": {
"value": "LOOP_TIMES"
}
},
"operator": "string"
}
],
"joinFields": [
{
"fieldId": "string",
"name": "string"
}
]
}
],
"primaryDsId": "string"
},
"analyticConfig": {
"edges": [
{
"id": "string",
"source": "string",
"target": "string",
"sourceHandle": "string",
"type": "string",
"success": true
}
],
"nodes": [
{
"id": "string",
"type": "DATA_INPUT",
"data": {
"empty": true,
"property1": {},
"property2": {}
},
"position": {
"x": 0,
"y": 0
}
}
]
},
"draftAnalyticConfig": {
"edges": [
{
"id": "string",
"source": "string",
"target": "string",
"sourceHandle": "string",
"type": "string",
"success": true
}
],
"nodes": [
{
"id": "string",
"type": "DATA_INPUT",
"data": {
"empty": true,
"property1": {},
"property2": {}
},
"position": {
"x": 0,
"y": 0
}
}
]
}
},
"name": "string",
"createdBy": "string",
"id": "string",
"appId": "string",
"appName": "string",
"schema": {
"property1": {
"dsId": "string",
"select": {
"sort": 0,
"multiple": true,
"options": [
{
"label": "string",
"color": "string",
"id": "string"
}
]
},
"singleSelect": {
"sort": 0,
"options": [
{
"label": "string",
"color": "string",
"id": "string"
}
]
},
"idConfig": {
"type": "CUSTOM",
"rules": [
{
"type": "DATE",
"length": 0,
"fixedCharacter": "string",
"dateFormat": "string"
}
]
},
"formula": {
"expression": "string"
},
"number": {
"accuracy": 0,
"prefix": "string",
"suffix": "string"
},
"date": {
"format": "string"
},
"person": {
"multiple": true
},
"join": {
"joinDsId": "string",
"joinFieldId": "string"
},
"id": "string",
"name": "string",
"dsName": "string",
"type": "string",
"innerType": "string"
},
"property2": {
"dsId": "string",
"select": {
"sort": 0,
"multiple": true,
"options": [
{
"label": "string",
"color": "string",
"id": "string"
}
]
},
"singleSelect": {
"sort": 0,
"options": [
{
"label": "string",
"color": "string",
"id": "string"
}
]
},
"idConfig": {
"type": "CUSTOM",
"rules": [
{
"type": "DATE",
"length": 0,
"fixedCharacter": "string",
"dateFormat": "string"
}
]
},
"formula": {
"expression": "string"
},
"number": {
"accuracy": 0,
"prefix": "string",
"suffix": "string"
},
"date": {
"format": "string"
},
"person": {
"multiple": true
},
"join": {
"joinDsId": "string",
"joinFieldId": "string"
},
"id": "string",
"name": "string",
"dsName": "string",
"type": "string",
"innerType": "string"
}
},
"type": 0,
"sync": true,
"syncAppId": "string",
"syncAppName": "string",
"syncDsId": "string",
"syncDsName": "string",
"syncEnvId": "string",
"syncEnvName": "string",
"primaryName": "string",
"envId": "string"
}
]
}修改于 2025-10-10 08:38:37