连接JSON Table输出中的两个字段

enter image description hereI'm trying to pull details from an API and load to a table in SQL Server. When i created by JSON Table, I gets the output in the below format. My API pulls around 5000 rows in a day.

{"fields":["source.time","source.kb_name","source.domain","content.query","content.resultFound","content.articleID","content.articleTitle","content.articleLabels","content.articleContext.Applications","translation.autoTranslated","translation.customersLanguage","translation.originalMessage","channel.rechanneled","channel.channelType","feedback.feedbackType","feedback.feedbackReason","feedback.feedbackText","count.resolved","count.interactions","count.feedback","count.feedbackPositive","count.feedbackNegative"],

rows":[["63725381805336","English","gph.accenture.com","Athena Opening Statement with Language Selection","True","1518752271","Athena Opening Statement with Language Selection","Bot","Athena","False","","","False","","","","","1","1","0","0","0"]
["63725381805336","English","gph.accenture.com","Athena Opening Statement with Language Selection","True","1518752271","Athena Opening Statement with Language Selection","Bot","Athena","False","","","False","","","","","1","1","0","0","0"],["63725381797070","English","gph.accenture.com","Athena Opening Statement with Language Selection","True","1518752271","Athena Opening Statement with Language Selection","Bot","Athena","False","","","False","","","","","1","1","0","0","0"],["63725381797070","English","gph.accenture.com","Athena Opening Statement with Language Selection","True","1518752271","Athena Opening Statement with Language Selection","Bot","Athena","False","","","False","","","","","1","1","0","0","0"],["63725381755149","English","gph.accenture.com","Athena Opening Statement with Language Selection","True","1518752271","Athena Opening Statement with Language Selection","Bot","Athena","False","","","False","","","","","1","1","0","0","0"],

字段是列标题,行代表每个列的值。

我想以一种形式将其连接起来,以使我的输出JSON表应该是行中的每个值都应以列标题作为前缀。例如:

rows":[["source.time":"63725381805336","source.kb_name":"English","content.query":"gph.accenture.com" -- etc..

这可能吗?我尝试了很多方法,但没有成功。 :(

评论