接口名称t100.oapi.work.team.list.data.query.get接口说明查询班组列表资料程序代号wssp00029输入参数说明参数代号型态是否必填参数说明范例值requestkeystring是检核编码(MD5)109c3c41a1441e702b909ed3de58e4b1typestring是Request类型(sync,async)固定传入synchostprodstring是发起方产品名称OAPIverstring是发起方产品版本1.0ipstring是发起方IP位置10.40.71.91idstring否发起方产品识别码,提供同一产品多台主机辨别之用acctstring是登入帐号固定传入tiptoptimestampstring是时间戳记格式:yyyyMMddHHmmssSSS20151211123204361timezonestring否发起方时区(-12~+14)+8langstring是语言别(zh_TW,zh_CN,en,vi)zh_CNserviceprodstring是接收方产品名称T100namestring是服务名称t100.oapi.work.team.list.data.query.getsrvverstring否接收方产品版本1.0ipstring否接收方IP位置10.20.86.223idstring否接收方产品识别码,提供同一产品多台主机辨别之用topprddatakeyEntIdstring是企业编号99CompanyIdstring否营运据点DSCTCsequencenumeric否条件顺序1field_namestring否字段名称ooge001参数代号型态是否必填参数说明范例值ERP字段enterprise_nostring否企业编号若无传值则预设值g_enterprise99oogeentsite_nostring否营运中心DSCTCis_digiwin_productstring是是否为鼎捷产品(Y,N)Ydata_timedate否异动时间格式:yyyyMMddHHmmss20230621000000key_conditionstring否前次最后一笔资料的Key条件ENT=99ANDKEY1='001'use_has_nextboolean是是否启用分页机制true:启用分页false:不启用分页truepage_sizenumeric否每页条数/分包的请求笔数使用说明:当启用分页机制时,代表每页条数。取值范围:大于零的整数,默认值50;最大值500。当不启用分页机制时,代表分包的请求笔数,如果值为NULL或0,则不做分包机制10page_nonumeric否页码2team_nostring是班组编号支持模糊查询(输入不完整编号可查)00ooge001team_namestring否班组名称支持模糊查询(输入不完整名称可查)车间ooge002date_sstring否开始日期格式:yyyyMMdd20230601oogemoddt/oogecrtdtdate_estring否结束日期格式:yyyyMMdd20230630oogemoddt/oogecrtdtconditions—否条件集合(单身节点,支持多数组)sequencenumeric否条件顺序1bracketstring否括号类型(、((、)、))(field_namestring否字段名称ooge001valuestring否字段值001operatorstring否操作符>、>=、=、<、<=、like、in、<>=logicalstring否搜寻组间的关系AND、ORANDorders—否排序设置(单头节点,支持多数组)field_namestring是字段名称ooge001order_typestring是排序类型asc:升序desc:降幂ascRequest范例Content-Type:application/json;charset=utf-8digi-protocol:rawdigi-type:syncdigi-key:4f6c908a9067e73291e24048a6a0455adigi-host:{"prod":"OAPI","ip":"10.20.88.30","lang":"zh_CN","timestamp":"20161018132542116","acct":"tiptop"}digi-service:{"prod":"T100","name":"t100.oapi.work.team.list.data.query.get","ip":"10.20.88.75","id":"topprod"}digi-datakey:{"EntId":"企业编号","CompanyId":"营运据点","sequence":"条件顺序","field_name":"字段名称"}{"std_data":{"parameter":{"enterprise_no":"企业编号","site_no":"营运据点","is_digiwin_product":"是否为鼎捷产品","data_time":"异动时间","key_condition":"前次最后一笔资料的Key条件","use_has_next":"是否启用分页机制","page_size":"每页条数/分包的请求笔数","page_no":"页码","team_no":"班组编号","team_name":"班组名称","date_s":"开始日期","date_e":"结束日期","conditions":[{"sequence":"条件顺序","bracket":"括号类型","field_name":"字段名称","value":"字段值","operator":"操作符","logical":"搜寻组间的关系"}],"orders":[{"field_name":"字段名称","order_type":"排序类型"}]}}}成功返回参数说明参数代号型态是否必填参数说明范例值ERP字段srvverstring是服务版本1.0srvcodestring是服务执行结果状态代码000:服务按照正常流程,并产生预期的结果(Basicflow)100:服务未按照正常流程执行,例如发生信息检核不通过等情况,导致无法完成预期的结果000datakeyteam_nostring是班组编号001ooge001参数代号型态是否必填参数说明范例值ERP字段statuscodestring是错误码0:正确0<>0:FAIL(原因代码)sql_codestring否失败时数据库回传代码0descriptionstring是错误问题描述执行成功!data_timedate是异动时间格式:yyyyMMddHHmmss20230621000000key_conditionstring是前次最后一笔资料的Key条件ENT=99ANDKEY1='001'total_resultsnumeric总数25has_nextboolean是否有下一页true:是false:否trueteam—是班组数据(单身节点,支持多数组)team_nostring是班组编号001ooge001team_namestring否班组名称一车间ooge002statusstring否状态码Y:审核/有效N:未审核/无效Yoogestusmodify_nostring否资料修改者TEST123oogemodidcreate_datedate否资料创建日格式:yyyy-mm-ddhh:mm:ss2023-06-2110:39:37oogecrtdtResponse范例Content-Type:application/json;charset=utf-8digi-code:019digi-message:RUFJIFJlc3BvbnNlOuW5s+WPsOWbnuimhuWQjOatpee1kOaenA==digi-reqid:b2d33bc6-8e8c-406e-bb5c-655721a85d3fdigi-protocol:rawdigi-srvver:1.0digi-srvcode:000digi-datakey:{"team_no":"班组编号"}{"std_data":{"execution":{"code":"错误码","sql_code":"数据库回传代码","description":"错误问题描述"},"parameter":{"data_time":"异动时间","key_condition":"前次最后一笔资料的Key条件","total_results":"总数","has_next":"存在下一页","team_attr":{"cnt":"当前回传资料笔数","tt_cnt":"应回传的资料总笔数"},"team":[{"team_no":"班组编号","team_name":"班组名称","status":"状态码","modify_no":"资料修改者","create_date":"资料创建日"}]}}}失败返回参数说明参数代号型态是否必填参数说明范例值ERP字段srvverstring是服务版本1.0srvcodestring是服务执行结果状态代码000:服务按照正常流程,并产生预期的结果(Basicflow)100:服务未按照正常流程执行,例如发生信息检核不通过等情况,导致无法完成预期的结果000参数代号型态是否必填参数说明范例值ERP字段statuscodestring是错误码0:正确<>0:FAIL(原因代码)anm-03078sql_codestring否失败时数据库回传代码0descriptionstring是错误问题描述[T100_message]查询无数据!Response范例Content-Type:application/json;charset=utf-8digi-code:019digi-message:RUFJIFJlc3BvbnNlOuW5s+WPsOWbnuimhuWQjOatpee1kOaenA==digi-reqid:b2d33bc6-8e8c-406e-bb5c-655721a85d3fdigi-protocol:rawdigi-srvver:1.0digi-srvcode:100{"std_data":{"execution":{"code":"错误码","sql_code":"数据库回传代码","description":"错误问题描述"}}}