Qeasy Cloud
Get Started

MongoDB 执行查询操作 API

Platform
MongoDB
Type
SQL
Effect
QUERY
API Version
1.0
Adapter
\Adapter\MongoDB\MongoDBQueryAdapter
Auth Mode
OTHER
Updated At
2023-01-31

执行查询操作

SQLfind
Factory
{
  "operation": {
    "method": "none"
  }
}

Request Parameters

No.FieldNameTypeDefaultRequiredDescription
1main_params主参数objectRequired主参数
1.1query查询条件objectOptional子对象包含 : 字段 :{ 操作符,值}
1.1.1date示例-订单日期objectOptional查询参数示例
1.1.1.1operation查询操作示例string$gtOptional输入操作符
1.1.1.2value查询值示例string2023-1-1Optional查询值示例
1.1.2id关联字段示例-订单idobjectOptional关联字段示例
1.1.2.1operation操作stringOptional对所属字段的操作
1.1.2.2valuestringOptional查询值示例
1.2projections检索的字段stringid,number,dateOptional用逗号隔开
1.3skip跳行intOptional分页使用
1.4limit每页行数intOptional每次查询行数
2extend_params_1扩展明细表objectOptional查询字表使用的参数 extend_params_* 序号区分
2.1query查询条件objectOptional字表的查询条件设置
2.1.1orderId主表关联字段-订单idobjectOptional在查询子表时需要主表提供的关联字段
2.1.1.1operation操作string$gtOptional操作示例
2.1.1.2value值示例-主表订单idstring:idOptional值示例-主表订单id
2.2relation关系stringarrayOptional1:1返回单个对象;1:N返回数组

Response Parameters

No parameter reference available

The 执行查询操作 API (find) of MongoDB is curated by the API asset management module of the Qeasy Cloud data integration platform and kept in sync with MongoDB version updates.

Need to integrate this API?

Qeasy ships with prebuilt adaptation for this API — contact us to start configuring data integration.