API开放平台

# 附录六：aPaaS字段类型样式说明

# aPaaS字段类型传输样式说明

类型 编码 入参样式 出参样式
长整型 LONG "12233333" "12233333"
单行文本 TEXT "我是字符串" "我是字符串"
多行文本 LONG_TEXT "我是很多个字符" "我是很多个字符"
单选 SELECT_ONE value为string格式的选项编码，来源是字典表的从数据字典里可以看到选项名称和选项的编码 示例: "MPoIXtWn" 示例: {"label": "选项1", "code": "MPoIXtWn", "content":"其他选项的内容"} 选项为其他时：{"label": "其他", "code": "other", "content":"内容" }
多选 SELECT_MANY value为string格式的选项编码，来源是字典表的从数据字典里可以看到选项名称和选项的编码 示例: "m8FHASq1, m8FHASq2" [{label: "选项1", code: "m8FHASq1", status: "1"}, {label: "选项2", code: "m8FHASq2", status: "1"}] 其他选项格式: {label: "其他", code: "other", status: "1", "content":"桌子"}
数字 NUMBER "123" "123"
金额 CURRENCY "32.234" "32.234"
日期 DATE "2022-04-11" {"value":"2023-07-15", "format":"yyyy-mm-dd"}
时间 TIME "10:17" {"value":"10:17", "format":"HH:mm"}
日期时间 DATE_TIME "2022-04-11 10:17" {"value":"2022-04-11 10:17", "format":"yyyy-mm-dd HH:MM"}
手机号 PHONE {"code":86,"phone":"15877743961"} {"code":86,"phone":"15877743961"}
图片 IMAGE [{"path": "object_oqb9z__ckskuzw/202204/202204061605591_ece9243093774e319a1a1aaa75ab4847.gif","name": "bc2acc23bb184054a0b4def259154b9b.gif"}] [{"path": "object_psvry__cbj5mdo/202407/202407150902645_346e91ddb6434070884800eaeaa1df61.png", "name": "微信图片_20230602144549.png", "url": "http://image-test.waiqin365.com/9129969427416845945/object_psvry__cbj5mdo/202407/202407150902645_346e91ddb6434070884800eaeaa1df61.png"}]
附件 FILE_ATTACHMENT [{"path": "object_n2auo__cqhi7jg/202204061640867_d49941531a984b328df976a60344c262.txt","name": "空文件1.txt","fileSize": 19272}] [{"path": "object_psvry__cbj5mdo/202407/202407150902645_346e91ddb6434070884800eaeaa1df61.png", "name": "微信图片_20230602144549.png", "url": "http://image-test.waiqin365.com/9129969427416845945/object_psvry__cbj5mdo/202407/202407150902645_346e91ddb6434070884800eaeaa1df61.png"}]
邮箱 EMAIL "234242@qq.com" "234242@qq.com"
百分数 PERCENTILE "0.24"（非百分制,24% → 0.24） "0.24"（非百分制,24% → 0.24）
网址 URL "http://23234.com" "http://23234.com"
人员 EMPLOYEE "9040134250461624018"(员工id) {"id":"8999774590595176544", "name":"章三", "status":"1"}
自增编号 AUTO_NUMBER "2022-b01-生产" "2022-b01-生产"
部门 DEPARTMENT "5074316400153793027"(部门id) {"id":"8999774590595176544", "name":"章三", "status":"1"}
定位 LOCATION {"longitude": "118.78328167808446","latitude": "32.07708957524906","address": "南京市南京市323路"} 不支持该类型查询
关联关系 OBJECT_REFERENCE "6162401049250401348" {"id": "4626651864093641022", "name": "202312261552", "status": "1"}
主从关系 MASTER_DETAIL "2132131313150435345" {"id": "4626651864093641022", "name": "202312261552"}
字段引用 FIELD_REFERENCE 不支持 格式 和 引用的源字段格式 一致
条码扫描 BARCODE "343242442424" "343242442424"
计算字段 FORMULA 不支持 根据配置计算公式返回值返回。 如果是文本返回string，比如 "xaaa"，如果是数值，也返回 string , 比如 "123"。
布尔值 TRUE_OR_FALSE true {"label": "是", "code": "true"}
地区 AREA {"field_j9M4e__c":"86" , ---表示国家 "field_8GLIN__c":"320000", --表示省 "field_pjVRc__c":"320100", --表示市 "field_093bF__c":"320102", --表示区 "field_WlLcY__c":"320102005", --表示街道 "field_VVBLk__c":"江苏省南京市玄武区北京东路和平公园" --表示详细地址 "field_Gwoik__c": {"longitude": "118.78328167808446", "latitude": "32.07708957524906", "address": "南京市南京市323路"}} {"field_j9M4e__c":{"code":"86","name":"中国"} , ---表示国家 "field_8GLIN__c":{"code":"320000","name":"江苏省"} , --表示省 "field_pjVRc__c":{"code":"320100","name":"南京市"} , --表示市 "field_093bF__c":{"code":"320102","name":"玄武区"} , --表示区 "field_WlLcY__c":{"code":"320102005","name":"北京东路和平公园"} , --表示街道 "field_VVBLk__c":"江苏省南京市玄武区北京东路和平公园" --表示详细地址 --定位不支持}
统计字段 STATISTICS 不支持 返回值为 string格式，表示统计 出来的数值 举例 "100"
人员(多选) EMPLOYEE_MULTI "8999774590595176544,8999774590595176542" [{"id":"8999774590595176544", "name":"章三", "status":"1"}, {"id":"9885774590595173322", "name":"李四", "status":"1"}]
部门(多选) DEPARTMENT_MULTI "8999774590595176544,8999774590595176542" [{"id":"8999774590595176544", "name":"研发一组", "status":"1"}, {"id":"8999774590595176542", "name":"研发二组", "status":"1"}]
手写签名 WRITE_SIGN [{"path": "http://abc.test.waiqin365.com/9129969427416845945/object_oqb9z__ckskuzw/202204/202204061605591_ece9243093774e319a1a1aaa75ab4847.gif","name": "bc2acc23bb184054a0b4def259154b9b.jpeg"}] [{"path": "object_psvry__cbj5mdo/202407/202407150902645_346e91ddb6434070884800eaeaa1df61.png", "name": "微信图片_20230602144549.png", "url": "http://image-test.waiqin365.com/9129969427416845945/object_psvry__cbj5mdo/202407/202407150902645_346e91ddb6434070884800eaeaa1df61.png"}]
树形选择 TREE_SELECT value为string格式的选项编码，来源是字典表的从数据字典里可以看到选项名称和选项的编码 示例: "MPoIXtWn" {"label": "选项1", "code": "MPoIXtWn", "id":"5630210478204458693", "pid":"8630210478204458693", "status": "1"}
动态关联 DYNAMIC_ASSOCIATION {"object","sys_employee","dataId","1231313231231"} {"objectKey","sys_employee", "id","1231313231231", "name":"数据123", "status":"1"}
商品智能识别 GOODS_INTELLIGENT_IDENTIFY [{"path": "http://abc.test.waiqin365.com/9129969427416845945/object_oqb9z__ckskuzw/202204/202204061605591_ece9243093774e319a1a1aaa75ab4847.png","name": "bc2acc23bb184054a0b4def259154b9b.png"}] {"biz_id": "8832397008933909358", "all_path": [{"path": "object_psvry__cbj5mdo/202404/pic.jpg", "name": "test3 (3).jpg", "url": "https://image-test.waiqin365.com/9129969427416845945/object_psvry__cbj5mdo/202404/pic.jpg"}]}
小视频 SHORT_VIDEO [{"path": "http://abc.test.waiqin365.com/9129969427416845945/object_oqb9z__ckskuzw/202204/202204061605591_ece9243093774e319a1a1aaa75ab4847.mp4","name": "bc2acc23bb184054a0b4def259154b9b.mp4"}] [{"path": "object_psvry__cbj5mdo/202407/202407150902645_346e91ddb6434070884800eaeaa1df61.mp4", "name": "微信图片_20230602144549.png", "url": "http://image-test.waiqin365.com/9129969427416845945/object_psvry__cbj5mdo/202407/202407150902645_346e91ddb6434070884800eaeaa1df61.mp4"}]
富文本 RICH_TEXT "

阿斯顿发阿萨德<img src=\"http://image-test.waiqin365.com/8958085892090750662/bbs/202204/20220407163636_c5a5c10c6aa046ff8dffa41154654a10.jpg">

"
模板对象关联关系 OBJ_REF_TMPL "4626651864093641022" {"id": "4626651864093641022"， "name": "章三小卖部", "status": "1", "objectKey": "bas_cm_dealer", "objectName": "经销商"}
模板对象关联引用 FIELD_REF_TMPL 不需要传值 同配置的源字段
OCR识别 OCR_RECOGNITION [{"path": "object_oqb9z__ckskuzw/202204/202204061605591_ece9243093774e319a1a1aaa75ab4847.gif","name": "bc2acc23bb184054a0b4def259154b9b.gif"}] [{"path": "object_psvry__cbj5mdo/202407/202407150902645_346e91ddb6434070884800eaeaa1df61.png", "name": "微信图片_20230602144549.png", "url": "http://image-test.waiqin365.com/9129969427416845945/object_psvry__cbj5mdo/202407/202407150902645_346e91ddb6434070884800eaeaa1df61.png"}]
业务类型 BUSINESS_TYPE "busitype_laEnXq__c" {"code": "busitype_laEnXq__c", "id": "6104351327745702856", "label": "全字段展示业务类型", "status": "1"}
商品(单选) GOODS "4626651864093641022" {"id": "4626651864093641022", "name": "202312261552", "status": "1"}
商品(多选) GOODS_MULTI "4626651864093641022,8999774590595176542" [{"id": "4626651864093641022", "name": "202312261552", "status": "1"}, {"id": "8999774590595176542", "name": "20231223324", "status": "1"}]
关联关系(多选) OBJECT_REFERENCE_MULTI "8999774590595176544,8999774590595176542" [{"id": "8999774590595176544", "name": "202312261552", "status": "1"}, {"id": "8999774590595176542", "name": "20231223324", "status": "1"}]

← 接口调试工具 →