从小满OKKICRM到金蝶云星辰V1通过接口集成数据

接通系统：小满OKKICRM

小满科技一直以“人工智能+大数据”为核心驱动力，并融入多年深耕CRM行业的经验，为外贸客户提供多场景的解决方案。凭借卓越的服务水准，小满科技先后斩获“年度最佳外贸SaaS服务商”、“2019杰出品牌形象奖”、“2020最佳企业服务平台”、“2020影响未来的产品GREAT100”、“2020最具商业价值品牌等诸多大奖，并于2020年8月获得阿里巴巴D轮融资，行业领先地位不断夯实。

对接目标系统:金蝶云星辰V1

金蝶云星辰是金蝶集团公司为小微型工商贸企业定制的一款集财务、进销存、订货商城和税务管理为一体的SAAS云平台，有标准版和专业版两个版本，标准版适用于小型企业(10-50人)业财一体化管理，专业版面向小型(10-100人)企业管理需求。金蝶云星辰聚焦小型企业在线经营和数字化管理，赋能小型企业拓客开源、智能管理和实时决策。

数据对接方案

在轻易云平台进行集成方案的配置时，为了实现快速搭建，轻易云平台还提供了现有的市场方案进行复制参考。用户可以在创建集成方案的时候在第四步选择引用市场方案，参考市场主流所进行的字段配置完成集成方案的自定义化快速配置，即便是第一次使用轻易云平台的用户也能轻松搭建属于自己的数据同步方案。向导式配置，让配置更加清晰，首先确定该方方案的对接内容，第二歩获取筛选数据源平台的数据，第三步数据源与写入目标形成映射关系配置。完成配置后一键启用

小满OKKICRM接口明细

调用接口：/v1/product/list
接口名称：产品库列表查询
方法：GET

请求参数

字段字段名称类型配置值 start_index第几页string1 count每页记录数string100 start_time时间查询范围-开始日期string{{LAST_SYNC_TIME datetime}} end_time时间查询范围-结束日期string{{CURRENT_TIME datetime}} removed默认值: 0，设置=1时查询已删除的数据列表string product_typeproduct_typeint_function 3* 1 info_api详情接口string/v1/product/info info_key详情主键stringproduct_no

响应参数

字段字段名称类型配置值 product_id产品IDstring product_no产品编号string name产品名称string group_id产品分类IDstring group_name产品分类名称string image产品图片地址string cost_with_tax含税成本object cost_with_tax.cost_currency货币string cost_with_tax.cost成本string cost_with_tax.cost_unit单位string cost_with_tax.fob离岸价object cost_with_tax.fob.price_currency货币string cost_with_tax.fob.price_min最小价格string cost_with_tax.fob.price_max最大价格string cost_with_tax.fob.price_unit单位string cost_with_tax.fob.minimum_order_quantity最小订货量object cost_with_tax.fob.minimum_order_quantity.quantity货量string cost_with_tax.fob.minimum_order_quantity.quantity_unit单位string

金蝶云星辰V1接口明细

调用接口：jdy/basedata/material_save
接口名称：商品新增
方法：POST

请求参数

字段字段名称类型配置值 number商品编码string{{product_no}} name商品名称string{{name}} baseunitid_id计量单位idstringfindCollection find id from 73a0290e-d0a1-3986-ad70-e310c13fd0e8 where number={{unit}} checktype商品类型string_function case '{{product_type}}' when '2' then '1' when '1' then '1' when '3' then '2' else '3' end parent_id商品类别idstringfindCollection find id from 258d3d84-637b-30c7-b585-1e1dad9f2337 where name={{group_id}} model规格型号string{{model}} priceentity商品价格array priceentity.price_unitid_id单位string_findCollection find id from 73a0290e-d0a1-3986-ad70-e310c13fd0e8 where number={{unit}} priceentity.price_minsalesprice最低销售价string{{fob.price_min}} priceentity.gross_weight毛重string{{package_gross_weight}} priceentity.volume体积string{{package_volume}} priceentity.remark备注string{{product_remark}} priceentity.issubpart可为子件stringtrue priceentity.isasstattr是否启用辅助属性stringfunction case when '{{product_type}}'='2' then 'true' else 'false' end priceentity.bomentity套装属性arraysub_product_sku_items priceentity.bomentity.materialid_number物料编码string{{sub_product_sku_items.product_no}} priceentity.bomentity.price价格string{{sub_product_sku_items.cost_with_tax.cost}} priceentity.bomentity.bomaux_numberSKU编码string_function case '{{sub_product_sku_items.product_type}}' when '1' then '' else '{{sub_product_sku_items.sku_code}}' end priceentity.bomentity.qty数量string{{sub_product_sku_items.count}} priceentity.bomentity.bomaux_id单位idstringfindCollection find id from 73a0290e-d0a1-3986-ad70-e310c13fd0e8 where number={{sub_product_sku_items.unit}} priceentity.bomentity.rate税率string priceentity.bomentity.amount金额string_function {{sub_product_sku_items.cost_with_tax.cost}}*{{sub_product_sku_items.count}} priceentity.bomentity.unitid_id单位1idstringfindCollection find id from 73a0290e-d0a1-3986-ad70-e310c13fd0e8 where number={{sub_product_sku_items.unit}} priceentity.bomentity.costamountcostamountstring priceentity.bomentity.materialid_baseunitid_idmaterialid_baseunitid_idstring priceentity.bomentity.isfreeisfreestring_function case '{{sub_product_sku_items.cost_with_tax.cost}}' when '0.0000' then 'true' else 'false' end priceentity.bomentity.isreplaceisreplacestringfalse priceentity.bomentity.seqseqstring2 priceentity.bomentity.bomauxid1_parent_idbomauxid1_parent_idstring1 priceentity.bomentity.bomauxid1_groupid_numberbomauxid1_groupid_numberstring01 priceentity.bomentity.bomauxid1_number属性编码stringfunction case when '{{sub_product_sku_items.属性组1}}'='' then '' else 'findCollection find number from f23aef21-bbe9-34bc-93d9-49d70daf120d where name={{sub_product_sku_items.属性组1}} endFind' end priceentity.bomentity.bomaux_auxid1_number属性值编码string_function case when '{{sub_product_sku_items.属性组1}}'='' then '' else '_findCollection find number from f23aef21-bbe9-34bc-93d9-49d70daf120d where name={{sub_product_sku_items.属性组1}} endFind' end priceentity.bomentity.bomaux_auxid1_id属性值idstring_function case when '{{sub_product_sku_items.属性组1}}'='' then '' else '_findCollection find id from f23aef21-bbe9-34bc-93d9-49d70daf120d where name={{sub_product_sku_items.属性组1}} endFind' end priceentity.bomentity.bomauxid1_id属性值idstring_function case when '{{sub_product_sku_items.属性组1}}'='' then '' else '_findCollection find id from f23aef21-bbe9-34bc-93d9-49d70daf120d where name={{sub_product_sku_items.属性组1}} endFind' end priceentity.bomentity.bomauxid1_parent_numberbomauxid1_parent_numberstring01 priceentity.bomentity.bomauxid1_groupid_idbomauxid1_groupid_idstring1 priceentity.bomentity.bomauxid2_parent_idbomauxid2_parent_idstring2 priceentity.bomentity.bomauxid2_groupid_numberbomauxid2_groupid_numberstring02 priceentity.bomentity.bomauxid2_number属性编码string_function case when '{{sub_product_sku_items.属性组2}}'='' then '' else '_findCollection find number from f23aef21-bbe9-34bc-93d9-49d70daf120d where name={{sub_product_sku_items.属性组2}} endFind' end priceentity.bomentity.bomaux_auxid2_number属性值编码string_function case when '{{sub_product_sku_items.属性组2}}'='' then '' else '_findCollection find number from f23aef21-bbe9-34bc-93d9-49d70daf120d where name={{sub_product_sku_items.属性组2}} endFind' end priceentity.bomentity.bomaux_auxid2_id属性值idstring_function case when '{{sub_product_sku_items.属性组2}}'='' then '' else '_findCollection find id from f23aef21-bbe9-34bc-93d9-49d70daf120d where name={{sub_product_sku_items.属性组2}} endFind' end priceentity.bomentity.bomauxid2_id属性值idstring_function case when '{{sub_product_sku_items.属性组2}}'='' then '' else '_findCollection find id from f23aef21-bbe9-34bc-93d9-49d70daf120d where name={{sub_product_sku_items.属性组2}} endFind' end priceentity.bomentity.bomauxid2_parent_numberbomauxid2_parent_numberstring02 priceentity.bomentity.bomauxid2_groupid_idbomauxid2_groupid_idstring2 priceentity.bomentity.bomauxid3_parent_idbomauxid3_parent_idstring3 priceentity.bomentity.bomauxid3_groupid_numberbomauxid3_groupid_numberstring03 priceentity.bomentity.bomauxid3_number属性编码string_function case when '{{sub_product_sku_items.属性组3}}'='' then '' else '_findCollection find number from f23aef21-bbe9-34bc-93d9-49d70daf120d where name={{sub_product_sku_items.属性组3}} endFind' end priceentity.bomentity.bomaux_auxid3_number属性值编码string_function case when '{{sub_product_sku_items.属性组3}}'='' then '' else '_findCollection find number from f23aef21-bbe9-34bc-93d9-49d70daf120d where name={{sub_product_sku_items.属性组3}} endFind' end priceentity.bomentity.bomaux_auxid3_id属性值idstring_function case when '{{sub_product_sku_items.属性组3}}'='' then '' else '_findCollection find id from f23aef21-bbe9-34bc-93d9-49d70daf120d where name={{sub_product_sku_items.属性组3}} endFind' end priceentity.bomentity.bomauxid3_id属性值idstring_function case when '{{sub_product_sku_items.属性组3}}'='' then '' else '_findCollection find id from f23aef21-bbe9-34bc-93d9-49d70daf120d where name={{sub_product_sku_items.属性组3}} endFind' end priceentity.bomentity.bomauxid3_parent_numberbomauxid3_parent_numberstring04 priceentity.bomentity.bomauxid3_groupid_idbomauxid3_groupid_idstring4 priceentity.bomentity.bomauxid4_parent_idbomauxid4_parent_idstring4 priceentity.bomentity.bomauxid4_groupid_numberbomauxid4_groupid_numberstring04 priceentity.bomentity.bomauxid4_number属性编码string_function case when '{{sub_product_sku_items.属性组4}}'='' then '' else '_findCollection find number from f23aef21-bbe9-34bc-93d9-49d70daf120d where name={{sub_product_sku_items.属性组4}} endFind' end priceentity.bomentity.bomaux_auxid4_number属性值编码string_function case when '{{sub_product_sku_items.属性组4}}'='' then '' else '_findCollection find number from f23aef21-bbe9-34bc-93d9-49d70daf120d where name={{sub_product_sku_items.属性组4}} endFind' end priceentity.bomentity.bomaux_auxid4_id属性值idstring_function case when '{{sub_product_sku_items.属性组4}}'='' then '' else '_findCollection find id from f23aef21-bbe9-34bc-93d9-49d70daf120d where name={{sub_product_sku_items.属性组4}} endFind' end priceentity.bomentity.bomauxid4_id属性值idstring_function case when '{{sub_product_sku_items.属性组4}}'='' then '' else '_findCollection find id from f23aef21-bbe9-34bc-93d9-49d70daf120d where name={{sub_product_sku_items.属性组4}} endFind' end priceentity.bomentity.bomauxid4_parent_numberbomauxid4_parent_numberstring05 priceentity.bomentity.bomauxid4_groupid_idbomauxid4_groupid_idstring5 priceentity.bomentity.bomauxid5_parent_idbomauxid5_parent_idstring5 priceentity.bomentity.bomauxid5_groupid_numberbomauxid5_groupid_numberstring05 priceentity.bomentity.bomauxid5_number属性编码string_function case when '{{sub_product_sku_items.属性组5}}'='' then '' else '_findCollection find number from f23aef21-bbe9-34bc-93d9-49d70daf120d where name={{sub_product_sku_items.属性组5}} endFind' end priceentity.bomentity.bomaux_auxid5_number属性值编码string_function case when '{{sub_product_sku_items.属性组5}}'='' then '' else '_findCollection find number from f23aef21-bbe9-34bc-93d9-49d70daf120d where name={{sub_product_sku_items.属性组5}} endFind' end priceentity.bomentity.bomaux_auxid5_id属性值idstring_function case when '{{sub_product_sku_items.属性组5}}'='' then '' else '_findCollection find id from f23aef21-bbe9-34bc-93d9-49d70daf120d where name={{sub_product_sku_items.属性组5}} endFind' end priceentity.bomentity.bomauxid5_id属性值idstring_function case when '{{sub_product_sku_items.属性组5}}'='' then '' else '_findCollection find id from f23aef21-bbe9-34bc-93d9-49d70daf120d where name={{sub_product_sku_items.属性组5}} _endFind' end priceentity.bomentity.bomauxid5_parent_numberbomauxid5_parent_numberstring05 priceentity.bomentity.bomauxid5_groupid_idbomauxid5_groupid_idstring5 priceentity.bomentity.materialid_idmaterialid_idstring1514377262059799552 priceentity.bomentity.weight_unit_id重量单位string1540583584643964928 priceentity.bomentity.volume_unit_id体积单位string1540583333623259136

系统数据对接

从API服务总线层面解决企业烟囱式业务系统集成现状相互连接企业各业务系统，实现流程端到端打通，复用已有的业务系统能力，让集成架构、服务关系更清晰使用统一的API管理平台，对API进行显性化、可视化，使所有API服务成为企业的数字资产，提升API利用率，发挥业务系统价值，实现企业IT资产的可插拔、可复用、可组成。

从小满OKKICRM到金蝶云星辰V1通过接口集成数据