7.0.103 json转义问题（顺丰接口）

凯神Jump

本帖最后由周冬景于 2021-12-17 18:43 编辑

各位好，我有这样一个场景

通过调用顺丰接口，顺丰返回了如下信息，我想使用导入json数据到表格，但是无法解析对应的字段，经给咨询他人得知应该是转义问题，还请各位帮忙解答一下，谢谢
我想解析的字段为4个：

acceptAddress
acceptTime
remark
opCode

{"apiErrorMsg":"","apiResponseID":"00017DC7F8A1063FAC6764A1F9D4203F","apiResultCode":"A1000","apiResultData":"{\"success\":true,\"errorCode\":\"S0000\",\"errorMsg\":null,\"msgData\":{\"routeResps\":[{\"mailNo\":\"SF1341707552245\",\"routes\":[{\"acceptAddress\":\"上海市\",\"acceptTime\":\"2021-12-16 19:08:39\",\"remark\":\"顺丰速运已收取快件\",\"opCode\":\"54\"},{\"acceptAddress\":\"上海市\",\"acceptTime\":\"2021-12-16 19:25:52\",\"remark\":\"顺丰速运已收取快件\",\"opCode\":\"43\"},{\"acceptAddress\":\"上海市\",\"acceptTime\":\"2021-12-16 20:09:09\",\"remark\":\"快件在【罗泾速运营业部】完成分拣,准备发往【上海华新中转场】\",\"opCode\":\"30\"},{\"acceptAddress\":\"上海市\",\"acceptTime\":\"2021-12-16 21:11:19\",\"remark\":\"快件已发车\",\"opCode\":\"36\"},{\"acceptAddress\":\"上海市\",\"acceptTime\":\"2021-12-16 22:18:21\",\"remark\":\"快件到达【上海华新中转场】\",\"opCode\":\"31\"},{\"acceptAddress\":\"上海市\",\"acceptTime\":\"2021-12-16 23:44:07\",\"remark\":\"快件在【上海华新中转场】完成分拣,准备发往【南通兴东航空站点】\",\"opCode\":\"30\"},{\"acceptAddress\":\"上海市\",\"acceptTime\":\"2021-12-16 23:47:31\",\"remark\":\"快件已发车\",\"opCode\":\"36\"},{\"acceptAddress\":\"南通市\",\"acceptTime\":\"2021-12-17 01:47:12\",\"remark\":\"快件到达【南通兴东航空站点】\",\"opCode\":\"31\"},{\"acceptAddress\":\"南通市\",\"acceptTime\":\"2021-12-17 01:52:08\",\"remark\":\"快件在【南通兴东航空站点】完成分拣,准备发往下一站\",\"opCode\":\"30\"},{\"acceptAddress\":\"南通市\",\"acceptTime\":\"2021-12-17 04:14:00\",\"remark\":\"快件在【南通飞往成都航班上】已起飞\",\"opCode\":\"105\"},{\"acceptAddress\":\"成都市/资阳市/眉山市\",\"acceptTime\":\"2021-12-17 07:23:00\",\"remark\":\"快件到达【成都】，准备发往【成都总集散中心】\",\"opCode\":\"106\"},{\"acceptAddress\":\"成都市/资阳市/眉山市\",\"acceptTime\":\"2021-12-17 08:07:26\",\"remark\":\"快件到达【成都总集散中心】\",\"opCode\":\"31\"},{\"acceptAddress\":\"成都市/资阳市/眉山市\",\"acceptTime\":\"2021-12-17 08:07:27\",\"remark\":\"快件在【成都总集散中心】完成分拣,准备发往下一站\",\"opCode\":\"30\"},{\"acceptAddress\":\"成都市/资阳市/眉山市\",\"acceptTime\":\"2021-12-17 08:07:57\",\"remark\":\"快件已发车\",\"opCode\":\"36\"},{\"acceptAddress\":\"成都市/资阳市/眉山市\",\"acceptTime\":\"2021-12-17 09:08:22\",\"remark\":\"快件到达【成都腾飞中转场】\",\"opCode\":\"31\"},{\"acceptAddress\":\"成都市/资阳市/眉山市\",\"acceptTime\":\"2021-12-17 10:59:18\",\"remark\":\"快件在【成都腾飞中转场】完成分拣,准备发往【成都市高新西区天河路速运营业部】\",\"opCode\":\"30\"},{\"acceptAddress\":\"成都市/资阳市/眉山市\",\"acceptTime\":\"2021-12-17 10:59:26\",\"remark\":\"快件已发车\",\"opCode\":\"36\"},{\"acceptAddress\":\"成都市/资阳市/眉山市\",\"acceptTime\":\"2021-12-17 12:11:35\",\"remark\":\"快件到达【成都市高新西区天河路速运营业部】\",\"opCode\":\"31\"},{\"acceptAddress\":\"成都市/资阳市/眉山市\",\"acceptTime\":\"2021-12-17 12:35:06\",\"remark\":\"快件交给李涛,正在派送途中（联系电话：15682053952,顺丰已开启“安全呼叫”保护您的电话隐私,请放心接听！）（主单总件数：1件）\",\"opCode\":\"204\"},{\"acceptAddress\":\"成都市/资阳市/眉山市\",\"acceptTime\":\"2021-12-17 12:55:09\",\"remark\":\"您的快件已签收，如有疑问请电联快递员【李涛，电话：15682053952】。疫情期间顺丰每日对网点消毒、快递员每日测温、配戴口罩，感谢您使用顺丰，期待再次为您服务。（主单总件数：1件）\",\"opCode\":\"80\"},{\"acceptAddress\":\"成都市/资阳市/眉山市\",\"acceptTime\":\"2021-12-17 12:55:10\",\"remark\":\"在官网\\\"运单资料&签收图\\\",可查看签收人信息\",\"opCode\":\"8000\"}]}]}}"}