说明 / 示例
联行号
## 一、接口样例
圈住的为样例
## 二、方案：定时接口
{"data":{"accountId":"","accountNo":"","code":"测试","createDate":"2020-03-06 10:08:02","depth":2,"description":"","externalAttr":null,"externalAttrInfo":null,"externalSysAttr":null,"isLeaf":true,"languageInfo":{"zh_CN":"测试"},"maxDepth":null,"minDepth":null,"name":"测试","objectId":"4f509e735f4f11ea9d2f03f1fa0b1da7","parentCode":"","parentId":"0573ad13d2a311e9b0a293c796146d04","parentName":"","path":"10034,00005","position":5,"status":"ENABLE","taxId":"","taxNo":"","typeCode":"DIM_OPENING_ACCOUNT_NETWORK","typeId":"0573ad13d2a311e9b0a293c796146d04","typeName":"","updateDate":"2020-03-06 10:08:02"},"message":"","messageList":null,"messageType":"ERROR","success":true}
insert into t_custom_mapping (city_cod) select cty_cod from (select cty_cod from t_custom_res_bank_replica group by cty_cod ) ta where ta.cty_cod not in
(select city_cod from t_custom_mapping) and ta.cty_cod !='';