畅捷通T+和钉钉单据接口对接

对接系统:钉钉
钉钉(DingTalk)是阿里巴巴集团打造的企业级智能移动办公平台,是数字经济时代的企业组织协同办公和应用开发平台。钉钉将IM即时沟通、钉钉文档、钉闪会、钉盘、Teambition、OA审批、智能人事、钉工牌、工作台深度整合,打造简单、高效、安全、智能的数字化未来工作方式,助力企业的组织数字化和业务数字化,实现企业管理“人、财、物、事、产、供、销、存”的全链路数字化。
对接目标平台:畅捷通T+
“T+”是一款灵动、智慧、时尚的互联网管理软件,主要针对中小型工贸和商贸企业的财务业务一体化应用,融入了社交化、移动化、物联网、电子商务、互联网信息订阅等元素。产品全面适应最新2013《小企业会计准则》,为企业打造全新的生意模式、管理模式、工作模式。与传统管理软件相比,“T+”更强调企业管理向企业经营的转变、等级化管人向平等化用人理念的转变。
系统对接接口配置
通过轻易云系统数据集成平台:数据集成方案。选择开始创建数据集成方案菜单。在方案配置表单中选择对应的源业务系统:钉钉,然后选择对应的连接器。选择对应的topapi/processinstance/get作为数据对接来源。然后再写入目标平台配置目标系统为畅捷通T+,并且选择对应连接器(关于畅捷通T+的接口如何连接可以在轻易云数据集成社区论坛bbs.qeasy.cloud中找到相关信息)。选择好对应的/tplus/api/v2/doc/Create接口作为数据写入动作完成第一步的接口配置。

钉钉接口明细
- 调用接口:topapi/processinstance/get
- 接口名称:获取审批实例详情
- 方法:POST
请求参数
字段字段名称类型配置值
process_code审批流的唯一码stringPROC-2C467269-0ED9-4F1F-9AC5-D957EB4C4620
start_time审批实例开始时间。Unix时间戳,单位毫秒。string{{LAST_SYNC_TIME}}000
end_time审批实例结束时间,Unix时间戳,单位毫秒string{{CURRENT_TIME}}000
size分页参数,每页大小,最多传20。string20
cursor分页查询的游标,最开始传0,后续传返回参数中的next_cursor值。string
响应参数
字段字段名称类型配置值
费用归属项目费用归属项目string
报销类别报销类别string
TextNote_7L0ZKXODKW40TextNote_7L0ZKXODKW40string
行政报销类型行政报销类型string
项目报销类型项目报销类型string
报销明细报销明细array
报销明细.费用发生日期费用发生日期string
报销明细.报销金额(元)报销金额(元)string
报销明细.费用明细费用明细string
报销明细.项目费用明细项目费用明细array
报销明细.项目费用明细.componentNamecomponentNamestring
报销明细.项目费用明细.componentTypecomponentTypestring
报销明细.项目费用明细.propspropsstring
报销明细.项目费用明细.总金额总金额string
报销明细.项目费用明细.关联审批单关联审批单string
报销明细.项目费用明细.TextNote-KDE5B2G3TextNote-KDE5B2G3string
报销明细.项目费用明细.电子发票电子发票string
报销明细.项目费用明细.收款账号收款账号string
报销明细.项目费用明细.公司帐号付款(如需公司帐号付款请选择)公司帐号付款(如需公司帐号付款请选择)string
报销明细.项目费用明细.报销凭证拍照上传报销凭证拍照上传string
报销明细.项目费用明细.附件附件string
报销明细.项目费用明细.ididstring
报销明细.项目费用明细.titletitlestring
报销明细.项目费用明细.extendextendobject
报销明细.项目费用明细.extend.create_timecreate_timestring
报销明细.项目费用明细.extend.finish_timefinish_timestring
报销明细.项目费用明细.extend.originator_useridoriginator_useridstring
报销明细.项目费用明细.extend.originator_dept_idoriginator_dept_idstring
报销明细.项目费用明细.extend.statusstatusstring
报销明细.项目费用明细.extend.resultresultstring
报销明细.项目费用明细.extend.business_idbusiness_idstring
报销明细.项目费用明细.extend.originator_dept_nameoriginator_dept_namestring
报销明细.项目费用明细.extend.biz_actionbiz_actionstring
畅捷通T+接口明细
- 调用接口:/tplus/api/v2/doc/Create
- 接口名称:凭证创建
- 方法:POST
请求参数
字段字段名称类型配置值
ExternalCode外部编码string{{extend.business_id}}
DocType凭证字string记
VoucherDate制单日期string{{extend.finish_time}}
EntrysEntrysarray
Entrys.borrow-1借方-1object
Entrys.borrow-1.Summary-1借方摘要string{{付款事由}}
Entrys.borrow-1.Account-1借方科目档案string
findCollection find code from ba4f5050-ccff-3eeb-85d7-0ea7d18570e0 where name={{支付类别2.0.款项类别}}
Entrys.borrow-1.ExchangeRate-1借方汇率string1
Entrys.borrow-1.Currency-1借方货币stringRMB
Entrys.borrow-1.AmountDr-1借方本币string{{支付类别2.0.金额(元)}}
Entrys.borrow-1.AuxInfos-1借方辅助核算项array
Entrys.borrow-1.AuxInfos-1.AuxAccCustomer-1客户(往来单位)string_findCollection find Code from c4e7df2e-d13e-3ea3-a1a6-94df6a778df5 where Name={{支付类别2.0.单位名称}}
Entrys.borrow-1.borrow-2借方-2object
Entrys.borrow-1.borrow-2.Summary-2借方摘要string{{付款事由}}
Entrys.borrow-1.borrow-2.Account-2借方科目档案string
findCollection find code from ba4f5050-ccff-3eeb-85d7-0ea7d18570e0 where name={{支付类别2.1.款项类别}}
Entrys.borrow-1.borrow-2.ExchangeRate-2借方汇率string1
Entrys.borrow-1.borrow-2.Currency-2借方货币stringRMB
Entrys.borrow-1.borrow-2.AmountDr-2借方本币string{{支付类别2.1.金额(元)}}
Entrys.borrow-1.borrow-2.AuxInfos-2借方辅助核算项array
Entrys.borrow-1.borrow-2.AuxInfos-2.AuxAccCustomer-3客户(往来单位)string_findCollection find Code from c4e7df2e-d13e-3ea3-a1a6-94df6a778df5 where Name={{支付类别2.1.单位名称}}
Entrys.borrow-1.borrow-2.borrow-3借方-3object
Entrys.borrow-1.borrow-2.borrow-3.Summary-3借方摘要string{{付款事由}}
Entrys.borrow-1.borrow-2.borrow-3.Account-3借方科目档案string
findCollection find code from ba4f5050-ccff-3eeb-85d7-0ea7d18570e0 where name={{支付类别2.2.款项类别}}
Entrys.borrow-1.borrow-2.borrow-3.ExchangeRate-3借方汇率string1
Entrys.borrow-1.borrow-2.borrow-3.Currency-3借方货币stringRMB
Entrys.borrow-1.borrow-2.borrow-3.AmountDr-3借方本币string{{支付类别2.2.金额(元)}}
Entrys.borrow-1.borrow-2.borrow-3.AuxInfos-3借方辅助核算项array
Entrys.borrow-1.borrow-2.borrow-3.AuxInfos-3.AuxAccCustomer-3客户(往来单位)string_findCollection find Code from c4e7df2e-d13e-3ea3-a1a6-94df6a778df5 where Name={{支付类别2.2.单位名称}}
Entrys.borrow-1.borrow-2.borrow-3.borrow-4借方-4object
Entrys.borrow-1.borrow-2.borrow-3.borrow-4.Summary-4借方摘要string{{付款事由}}
Entrys.borrow-1.borrow-2.borrow-3.borrow-4.Account-4借方科目档案string
findCollection find code from ba4f5050-ccff-3eeb-85d7-0ea7d18570e0 where name={{支付类别2.3.款项类别}}
Entrys.borrow-1.borrow-2.borrow-3.borrow-4.ExchangeRate-4借方汇率string1
Entrys.borrow-1.borrow-2.borrow-3.borrow-4.Currency-4借方货币stringRMB
Entrys.borrow-1.borrow-2.borrow-3.borrow-4.AmountDr-4借方本币string{{支付类别2.3.金额(元)}}
Entrys.borrow-1.borrow-2.borrow-3.borrow-4.AuxInfos-4借方辅助核算项array
Entrys.borrow-1.borrow-2.borrow-3.borrow-4.AuxInfos-4.AuxAccCustomer-4客户(往来单位)string_findCollection find Code from c4e7df2e-d13e-3ea3-a1a6-94df6a778df5 where Name={{支付类别2.3.单位名称}}
Entrys.borrow-1.borrow-2.borrow-3.borrow-4.borrow-5借方-5object
Entrys.borrow-1.borrow-2.borrow-3.borrow-4.borrow-5.Summary-5借方摘要string{{付款事由}}
Entrys.borrow-1.borrow-2.borrow-3.borrow-4.borrow-5.Account-5借方科目档案string
findCollection find code from ba4f5050-ccff-3eeb-85d7-0ea7d18570e0 where name={{支付类别2.4.款项类别}}
Entrys.borrow-1.borrow-2.borrow-3.borrow-4.borrow-5.ExchangeRate-5借方汇率string1
Entrys.borrow-1.borrow-2.borrow-3.borrow-4.borrow-5.Currency-5借方货币stringRMB
Entrys.borrow-1.borrow-2.borrow-3.borrow-4.borrow-5.AmountDr-5借方本币string{{支付类别2.4.金额(元)}}
Entrys.borrow-1.borrow-2.borrow-3.borrow-4.borrow-5.AuxInfos-5借方辅助核算项array
Entrys.borrow-1.borrow-2.borrow-3.borrow-4.borrow-5.AuxInfos-5.AuxAccCustomer-5客户(往来单位)string_findCollection find Code from c4e7df2e-d13e-3ea3-a1a6-94df6a778df5 where Name={{支付类别2.4.单位名称}}
Entrys.borrow-1.borrow-2.borrow-3.borrow-4.borrow-5.borrow-6借方-1object
Entrys.borrow-1.borrow-2.borrow-3.borrow-4.borrow-5.borrow-6.Summary-6借方摘要string{{付款事由}}
Entrys.borrow-1.borrow-2.borrow-3.borrow-4.borrow-5.borrow-6.Account-6借方科目档案string
findCollection find code from ba4f5050-ccff-3eeb-85d7-0ea7d18570e0 where name={{支付类别2.5.款项类别}}
Entrys.borrow-1.borrow-2.borrow-3.borrow-4.borrow-5.borrow-6.ExchangeRate-6借方汇率string1
Entrys.borrow-1.borrow-2.borrow-3.borrow-4.borrow-5.borrow-6.Currency-6借方货币stringRMB
Entrys.borrow-1.borrow-2.borrow-3.borrow-4.borrow-5.borrow-6.AmountDr-6借方本币string{{支付类别2.5.金额(元)}}
Entrys.borrow-1.borrow-2.borrow-3.borrow-4.borrow-5.borrow-6.AuxInfos-6借方辅助核算项array
Entrys.borrow-1.borrow-2.borrow-3.borrow-4.borrow-5.borrow-6.AuxInfos-6.AuxAccCustomer-6客户(往来单位)string_findCollection find Code from c4e7df2e-d13e-3ea3-a1a6-94df6a778df5 where Name={{支付类别2.5.单位名称}}
Entrys.borrow-1.borrow-2.borrow-3.borrow-4.borrow-5.borrow-6.loan-1贷方-1object
Entrys.borrow-1.borrow-2.borrow-3.borrow-4.borrow-5.borrow-6.loan-1.Summary-1贷方摘要string{{付款事由}}
Entrys.borrow-1.borrow-2.borrow-3.borrow-4.borrow-5.borrow-6.loan-1.Account-1贷方科目档案string_findCollection find code from ba4f5050-ccff-3eeb-85d7-0ea7d18570e0 where name={{付款账号}}
Entrys.borrow-1.borrow-2.borrow-3.borrow-4.borrow-5.borrow-6.loan-1.ExchangeRate-2贷方汇率string1
Entrys.borrow-1.borrow-2.borrow-3.borrow-4.borrow-5.borrow-6.loan-1.Currency-2贷方货币stringRMB
Entrys.borrow-1.borrow-2.borrow-3.borrow-4.borrow-5.borrow-6.loan-1.AmountCr-2贷方本币string{{金额2(元)}}
Entrys.borrow-1.borrow-2.borrow-3.borrow-4.borrow-5.borrow-6.loan-1.AuxInfos-2贷方辅助核算项array
Entrys.borrow-1.borrow-2.borrow-3.borrow-4.borrow-5.borrow-6.loan-1.AuxInfos-2.AuxAccCustomer-2客户(往来单位)string
Entrys.dataKeydataKeystringdto
Entrys.accountStrategyId科目基础资料查询方案stringba4f5050-ccff-3eeb-85d7-0ea7d18570e0
数据对接价值
全面支持数据集成操作可视化、拖拽流式开发,无代码完成多套异构系统集成,降低使用门槛,提升交付速度。特别是在面向钉钉、畅捷通T+间API接口集成时,通过对API的设计、创建、测试、部署、集成、管理、运维、下线等全生命周期管理,帮助企业洞察运营状况,进一步优化流程,提高企业商业价值。基于Web图形界面,通过拖拽、连接、配置完成流程设计,数据整合和集成,高效打通业务系统,通过面向运营的统计报表,直观查看API各项指标,实现对全局和项目层级双维度的监控管理。再通过轻易云数据集成中台通过统一门户注册管理,将业务以API的方式对外开放,实现业务创新、能力输出。


