I'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..
这可能吗？我尝试了很多方法，但没有成功。 :(
