excel - 如何将 XML API 响应转换为 Excel 表？

Question

我正在使用此代码使用来自 API 调用的数据填充 excel 单元格：

=WEBSERVICE(CONCATENATE("https://api.snov.io/v2/domain-emails-with-info?domain=",[@Domain],"&access_token=",snovioapikey,"&limit=100&lastId=0&type=personal"))

但是，返回的内容看起来完全像这样，它直接进入一个单元格（我当然已经删除了联系方式）

{"success":true,"domain":"xxxx.com","webmail":false,"result":4,"lastId":1985229771,"limit":100,"companyName":"xxxxx","emails":[{"email":"[e-mail]","firstName":"xxx","lastName":"xxx","position":"xxx","sourcePage":"xxx","companyName":"xxx","type":"prospect","status":"verified"},{"email":"[e-mail]","firstName":"yyy","lastName":"yyy","position":"yyy","sourcePage":"yyy","companyName":"yyy","type":"prospect","status":"verified"},{"email":"zzz","firstName":"zzz","lastName":"zzz","position":"zzz","sourcePage":"zzz","companyName":"zzz","type":"prospect","status":"verified"}]}

现在，这里的梦想显然是有一个表，其中填充了从该查询返回的数据，格式化为正确的列，例如

名	第二个名字
xxx	xxx
年年	年年

有人知道如何将这些单元格中保存的数据提取到表格中吗？

标签： excelxmlapidatatable