SoapUi-如何从json响应中提取列特定的数据 [英] SoapUi- How to extract column specific data form the json response

查看：217
本文介绍了SoapUi-如何从json响应中提取列特定的数据的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

问题描述

你好，我想从json响应中提取特定于列的数据 

  {
New England Schools__NE Schools $ ：{
dsData：Account Id＃％＃Territory＃％＃District＃％＃Area＃％＃Region＃％＃objname＃％＃〜ID〜＃％＃〜Lat-Lon Linked〜＃ ％＃〜纬度〜＃％＃〜经度〜＃％＃〜纬度邮编〜＃％＃学校名称＃％＃地址＃％＃城市＃％＃州＃％＃邮编＃％＃ZIP4＃％＃学校类型＃％＃状态＃％＃学校等级＃％＃计数免费午餐＃％＃计数减少午餐＃％＃总午餐＃＃％＃学生总数＃％＃幼儿园＃％＃幼儿园＃％＃1级＃％＃2级＃％＃等级3＃％＃等级4＃％＃等级5＃％＃等级6＃％＃等级7＃％＃等级8＃％＃等级9＃％＃等级10＃％＃等级11＃％＃等级12 ＃％＃Territory1＃％＃Region1＃％＃lat＃％＃lon＃％＃terrid \r\\\
15709＃％＃哈特福德，CT＃％＃新英格兰＃％＃未分配＃％＃未分配＃％＃帐户＃ ％＃15709＃％＃True＃％＃41.934711＃％＃ -  72.770021＃％＃06026＃％＃R＃DUDLEY SEYMOUR SCHOOL＃％＃185 HARTFORD AVENUE＃％＃EAST GRANBY＃％＃CT＃％＃6026＃％＃ 9520＃％＃1＃％＃1＃％＃2＃％＃0＃％＃0＃％＃0＃％＃131＃％＃0＃％＃0＃％＃0＃％＃0＃％＃0＃ ％＃60＃％＃71＃％＃0＃％＃0＃％＃0＃％＃0＃％＃0＃％＃0＃％＃0＃％＃哈特福德，CT＃％＃新英格兰＃％＃5151204.330513 76＃％＃ -  8100721.57141633＃％＃3 \r\\\
15707＃％＃哈特福德，CT＃％＃新英格兰＃％＃未分配＃％＃未分配＃％＃帐户＃％＃15707＃％＃True＃％＃ 41.934894＃％＃ -  72.730656＃％＃06026＃％＃EAST GRANBY HIGH SCHOOL＃％＃95 SOUTH MAIN STREET＃％＃EAST GRANBY＃％＃CT＃％＃6026＃％＃9550＃％＃1＃％＃1＃ ％＃3＃％＃0＃％＃0＃％＃0＃％＃219＃％＃0＃％＃0＃％＃0＃％＃0＃％＃0＃％＃0＃％＃0＃％＃ 0＃％＃0＃％＃0＃％＃57＃％＃55＃％＃53＃％＃54＃％＃Hartford，CT＃％＃New England＃％＃5151231.26605957＃％＃ -  8096340.03625871＃％＃3 \\ r\\\
15708＃％＃哈特福德，CT＃％＃新英格兰＃％＃未分配＃％＃未分配＃％＃帐户＃％＃15708＃％＃True＃％＃41.934894＃％＃ -  72.730656＃％＃06026＃ ％＃EAST GRANBY MIDDLE SCHOOL＃％＃95 SOUTH MAIN STREET＃％＃EAST GRANBY＃％＃CT＃％＃6026＃％＃9550＃％＃1＃％＃1＃％＃2＃％＃0＃％＃0 ＃％＃0＃％＃201＃％＃0＃％＃0＃％＃0＃％＃0＃％＃0＃％＃0＃％＃0＃％＃67＃％＃73＃％＃61＃％ ＃0＃％＃0＃％＃0＃％＃0＃％＃哈特福德，CT＃％＃新英格兰＃％＃＃5151231.26605957＃％＃ -  8096340.03625871＃％＃3\r\\\
15706＃％＃哈特福德，CT ＃％＃新英格兰＃％＃未分配＃％＃未分配＃％＃帐户＃％＃15706＃％＃True＃％＃41.944215＃％＃ -  72.732696＃％＃06026＃％＃ALLGROVE SCHOOL＃％＃33土耳其希尔斯公路＃％＃EAST GRANBY＃％＃CT＃％＃6026＃％＃9570＃％＃1＃％＃1＃％＃1＃％＃ 0＃％＃0＃％＃0＃％＃275＃％＃3＃％＃69＃％＃65＃％＃82＃％＃56＃％＃0＃％＃0＃％＃0＃％＃0＃ ％＃0＃％＃0＃％＃0＃％＃0＃％＃0＃％＃哈特福德，CT＃％＃新英格兰＃％＃5152627.52929053＃％＃ -  8096567.12801993＃％＃3\r\15710＃ ％＃哈特福德，CT＃％＃新英格兰＃％＃未分配＃％＃未分配＃％＃帐户＃％＃15710＃％＃True＃％＃41.944215＃％＃ -  72.732696＃％＃06026＃％＃HOMEBOUND＃％＃ 33土耳其山路＃＃％EAST GRANBY＃％＃CT＃％＃6026＃％＃674＃％＃4＃％＃3＃％＃4＃％＃0＃％＃0＃ ％＃0＃％＃0＃％＃0＃％＃0＃％＃0＃％＃0＃％＃0＃％＃0＃％＃0＃％＃0＃％＃0＃％＃0＃％＃ 0＃％＃0＃％＃哈特福德，CT＃％＃新英格兰＃％＃5152627.52929053＃％＃ -  8096567.12801993＃％＃3 \r\\\
15923＃％＃哈特福德，CT＃％＃新英格兰＃％＃未分配＃％＃未分配＃％＃＃＃＃％＃＃＃＃＃＃＃＃＃＃＃HOME＃％＃＃＃＃6023＃％＃＃72237＃％＃＃ ＃6027＃％＃9710＃％＃4＃％＃3＃％＃4＃％＃0＃％＃0＃％＃0＃％＃0＃％＃0＃％＃0＃％＃0＃％＃0 ＃％＃0＃％＃0＃％＃0＃％＃0＃％＃0＃％＃0＃％＃0＃％＃0＃％＃Hartford，CT＃％＃英格兰＃％＃＃5161383.89953631＃％＃ -  8119866.29744296＃％＃3 \r\\\
15922＃％＃哈特福德，CT＃％＃新英格兰＃％＃未分配＃％＃未分配＃％＃帐户＃％＃15922＃％＃ True＃％＃42.0027＃％＃ -  72.942＃％＃06027＃％＃HARTLAND ELEMENTARY SCH OOL＃％＃30 SOUTH ROAD＃％＃EAST HARTLAND＃％＃CT＃％＃6027＃％＃9710＃％＃1＃％＃1＃％＃1＃％＃0＃％＃ ＃2＃％＃0＃％＃25＃％＃17＃％＃26＃％＃29＃％＃37＃％＃36＃％＃38＃％＃35＃％＃40＃％＃0＃％＃0 ＃％＃0＃％＃0＃％＃哈特福德，CT＃％＃新英格兰＃％＃5161383.89953631＃％＃ -  8119866.29744296＃％＃3 \r\\\
16335＃％＃}

我的groovy脚本是 

  log .info json。New England Schools__NE Schools \ $。dsData

以上列印所有资料里面有列和它的数据，但我不知道如何获得专栏数据请帮助。



例如， Territory 是我的专栏，它的行值是 Hartford，CT



如果以上是不可能的我想要的方式，那么请告诉我如何打破所有的响应（像我们在java中所做的那样分割类型），以便我可以调用特定的值？

解决方案

在仔细研究细节之后，注意到它以行和合作形式存在数据由＃％＃分隔的记录由回车和新行标记分隔。



您提供的数据有一些额外的记录，只有几个字段，因此要提供一个工作脚本，必须在其末尾修剪不需要的额外字段。



以下是 Groovy脚本：

def str ='''帐户ID＃％＃地区＃％＃地区＃％＃地区＃％＃地区＃％＃objname＃％＃〜ID〜＃％＃〜Lat-Lon Linked〜＃％＃〜纬度〜＃％＃〜经度〜＃％＃〜纬度邮编〜＃％＃学校名称＃％＃地址＃％＃城市＃％＃国家＃％＃邮编＃％＃ZIP4＃％＃学校类型＃％＃状态＃％＃学校等级＃％＃计数免费午餐＃％＃计数减少的午餐＃％＃总午餐＃＃％＃学生总数＃％＃幼儿园＃％＃幼儿园＃％＃1＃＃＃＃2＃＃＃等级3＃％＃等级4＃％＃等级5＃％＃等级6＃％＃等级7＃％＃等级8＃％＃等级9＃％＃等级10＃％＃等级11＃％＃等级12＃％＃ Territory1＃％＃Region1＃％＃lat＃％＃lon＃％＃terrid \r\\\
15709＃％＃哈特福德，CT＃％＃新英格兰＃％＃未分配＃％＃未分配＃％＃帐号＃％＃15709＃％＃真＃％＃41.934711％＃ - ＃72.770021％＃06026＃％＃R上。 DUDLEY SEYMOUR SCHOOL＃％＃185 HARTFORD AVENUE＃％＃EAST GRANBY＃％＃CT＃％＃6026＃％＃9520＃％＃1＃％＃1＃％＃2＃％＃0 ＃％＃131＃％＃0＃％＃0＃％＃0＃％＃0＃％＃0＃％＃60＃％＃71＃％＃0＃％＃0＃％＃0＃％＃0＃％ ＃0＃％＃0＃％＃0＃％＃哈特福德，CT＃％＃新英格兰＃％＃5151204.33051376＃％＃ - 8100721.57141633＃％＃3\r\\\
15707＃％＃哈特福德，CT＃％＃新英格兰＃％＃未分配＃％＃未分配＃％＃帐户＃％＃15707＃％＃True＃％＃41.934894＃％＃ - 72.730656＃％＃06026＃％＃东格兰比高中＃％＃95 SOUTH MAIN STREET＃％＃ #EAST GRANBY＃％＃CT＃％＃6026＃％＃9550＃％＃1＃％＃1＃％＃3＃％＃0＃％＃0＃％＃0＃％＃ 0＃％＃0＃％＃0＃％＃0＃％＃0＃％＃0＃％＃0＃％＃0＃％＃0＃％＃57＃％＃55＃％＃53＃％＃54＃ ％＃哈特福德，康涅狄格州＃％＃新英格兰＃％＃＃＃＃＃＃＃＃＃＃＃％＃＃＃＃％＃＃80129 #Account＃％＃15708＃％＃True＃％＃41.934894＃％＃ - 72.730656＃％＃06026＃％＃EAST GRANBY MIDDLE SCHOOL＃％＃95 SOUTH MAIN STREET＃％＃EAST GRANBY＃％＃CT＃％＃6026 ＃％＃9550＃％＃1＃％＃1＃％＃2＃％＃0＃％＃0＃％＃0＃％＃201＃％＃0＃％＃0＃％＃0＃％＃0＃％ ＃0＃％＃0＃％＃0＃％＃67＃％＃73＃％＃61＃％＃0＃％＃0＃％＃0＃％＃0＃％＃哈特福德，CT＃％＃新英格兰＃ ％＃5151231.26605957＃％＃ - ＃8096340.03625871＃％3\r\\ ＃15706＃％＃True＃％＃41.944215＃％＃ - 72.732696＃％＃06026＃％＃ALLGROVE SCHOOL ＃％＃33土耳其山丘路＃％＃东部格兰比＃％＃CT＃％＃6026＃％＃9570＃％＃1＃％＃1＃％＃1＃％＃0＃％＃0＃％＃0＃％ ＃275＃％＃3＃％＃69＃％＃65＃％＃82＃％＃56＃％＃0＃％＃0＃％＃0＃％＃0＃％＃0＃％＃0＃％＃0 ＃％＃＃＃＃＃％＃＃＃％＃＃＃％＃＃＃＃％＃＃＃＃％＃＃＃％＃＃＃％＃＃＃％＃＃ ％＃未分配＃％＃未分配＃％＃帐户＃％＃15710＃％＃True＃％＃41.944215＃％＃ - 72.732696＃％＃06026＃％＃HOMEBOUND＃％＃33 TURKEY HILL ROAD＃％＃EAST GRANBY＃％＃ #CT＃％＃6026＃％＃674＃％＃4＃％＃3＃％＃4＃％＃0＃％＃0＃％＃0＃％＃0＃％＃0＃％＃0＃％＃0 ＃％＃0＃％＃0＃％＃0＃％＃0＃％＃0＃％＃0＃％＃0＃％＃0＃％＃0＃％＃0＃％＃0＃％＃Hartford，CT ＃％＃新英格兰＃％＃＃5152627.52929053＃％＃ - 8096567.12801993＃％＃3 \r\\\
15923＃％＃哈特福德，CT＃％＃新英格兰＃％＃未分配＃％＃未分配＃％＃帐户＃％＃ 15923＃％＃True＃％＃42.0027＃％＃ - 72.942＃％＃06027＃％＃HOMEBOUND＃％＃30 SOUTH ROAD＃％＃EAST HARTLAND＃％＃CT＃％＃6027＃％＃9710＃％＃4＃ ％＃3＃％＃4＃％＃0＃％＃0＃％＃0＃％＃0＃％＃0＃％＃0＃％＃0＃％＃0＃％＃0＃％＃0＃％＃ 0＃％＃0＃％＃0＃％＃0＃％＃0＃％＃0＃％＃0＃％＃0＃％＃哈特福德，CT ＃％＃新英格兰＃％＃＃5161383.89953631＃％＃ - 8119866.29744296＃％＃3 \r\\\
15922＃％＃哈特福德，CT＃％＃新英格兰＃％＃未分配＃％＃未分配＃％＃帐户＃％＃ 15922＃％＃True＃％＃42.0027＃％＃ - 72.942＃％＃06027＃％＃HARTLAND ELEMENTARY SCHOOL＃％＃30 SOUTH ROAD＃％＃EAST HARTLAND＃％＃CT＃％＃6027＃％＃9710＃％＃ 1＃％＃1＃％＃1＃％＃0＃％＃0＃％＃0＃％＃2＃％＃0＃％＃25＃％＃17＃％＃26＃％＃29＃％＃37＃ ％＃36＃％＃38＃％＃35＃％＃40＃％＃0＃％＃0＃％＃0＃％＃0＃％＃哈特福德，CT＃％＃新英格兰＃％＃5161383.89953631＃％＃ - 8119866.29744296＃％＃3'''
//由回车符和换行符分隔
def data = str.split（'\r\\\
'）
//按字段拆分从标题行中获取列名称
def headers = data [0] .split（'＃％＃'）
//只用标题键创建地图，以便在存储时使用它数据
def headerMap = [：]
headers.each {header - >
headerMap [header] =''
}
/ **
* Closure允许您查询所需的数据
*需要传递所有记录和行人类可读的开始于1）和标题键/字段名称
*因此信息被移位以及返回匹配值
* /
def getData = {recordList，row，field - >
println请求的数据：\ n行：$ {row} \\\
列：$ {field} \\\
列值：$ {recordList [row-1] .get（field）}
recordList [row-1] .get（field）
}
//这是保存所有记录的变量
//每个记录都将以地图的形式出现以便它可以根据字段
def records = []
轻松查询（i = 1; i< data.size（）; i ++）{
def fieldData = data [ i）.split（'＃％＃'）
def record = headerMap.clone（）
if（fieldData.size（）== headerMap.size（））{
def keys = headerMap.keySet（）
for（j = 0; j record [keys [j]] = fieldData [j]
}
println record
//将记录添加到记录
记录&l​​t;<记录


//一些元数据信息
printlnHeaders：$ {headers}
println头文件数量：$ {headers.size（ ）}
println行数：$ {records.size（）}
/ **
*以下是如何查询特定数据
*和自它返回值，你也可以为它赋值变量
* /
getData（records，1，'Territory'）
getData（records，7，'Account Id'）

您可以使用以下步骤快速验证输出：

点击链接=>在控制台中编辑=>执行脚本


Hi i want to extract column specific data form the json response

{
  "New England Schools__NE Schools$": {
"dsData": "Account Id#%#Territory#%#District#%#Area#%#Region#%#objname#%#~ID~#%#~Lat-Lon Linked~#%#~Latitude~#%#~Longitude~#%#~Lat-Lon Zip~#%#School Name#%#Address#%#City#%#State#%#ZIP#%#ZIP4#%#School Type#%#Status#%#School Level#%#Count Free Lunch#%#Count Reduced Lunch#%#Total Lunch Pgm#%#Total Students#%#PreKindergarten#%#Kindergarten#%#Grade 1#%#Grade 2#%#Grade 3#%#Grade 4#%#Grade 5#%#Grade 6#%#Grade 7#%#Grade 8#%#Grade 9#%#Grade 10#%#Grade 11#%#Grade 12#%#Territory1#%#Region1#%#lat#%#lon#%#terrid\r\n15709#%#Hartford, CT#%#New England#%#Unassigned#%#Unassigned#%#Account#%#15709#%#True#%#41.934711#%#-72.770021#%#06026#%#R. DUDLEY SEYMOUR SCHOOL#%#185 HARTFORD AVENUE#%#EAST GRANBY#%#CT#%#6026#%#9520#%#1#%#1#%#2#%#0#%#0#%#0#%#131#%#0#%#0#%#0#%#0#%#0#%#60#%#71#%#0#%#0#%#0#%#0#%#0#%#0#%#0#%#Hartford, CT#%#New England#%#5151204.33051376#%#-8100721.57141633#%#3\r\n15707#%#Hartford, CT#%#New England#%#Unassigned#%#Unassigned#%#Account#%#15707#%#True#%#41.934894#%#-72.730656#%#06026#%#EAST GRANBY HIGH SCHOOL#%#95 SOUTH MAIN STREET#%#EAST GRANBY#%#CT#%#6026#%#9550#%#1#%#1#%#3#%#0#%#0#%#0#%#219#%#0#%#0#%#0#%#0#%#0#%#0#%#0#%#0#%#0#%#0#%#57#%#55#%#53#%#54#%#Hartford, CT#%#New England#%#5151231.26605957#%#-8096340.03625871#%#3\r\n15708#%#Hartford, CT#%#New England#%#Unassigned#%#Unassigned#%#Account#%#15708#%#True#%#41.934894#%#-72.730656#%#06026#%#EAST GRANBY MIDDLE SCHOOL#%#95 SOUTH MAIN STREET#%#EAST GRANBY#%#CT#%#6026#%#9550#%#1#%#1#%#2#%#0#%#0#%#0#%#201#%#0#%#0#%#0#%#0#%#0#%#0#%#0#%#67#%#73#%#61#%#0#%#0#%#0#%#0#%#Hartford, CT#%#New England#%#5151231.26605957#%#-8096340.03625871#%#3\r\n15706#%#Hartford, CT#%#New England#%#Unassigned#%#Unassigned#%#Account#%#15706#%#True#%#41.944215#%#-72.732696#%#06026#%#ALLGROVE SCHOOL#%#33 TURKEY HILLS ROAD#%#EAST GRANBY#%#CT#%#6026#%#9570#%#1#%#1#%#1#%#0#%#0#%#0#%#275#%#3#%#69#%#65#%#82#%#56#%#0#%#0#%#0#%#0#%#0#%#0#%#0#%#0#%#0#%#Hartford, CT#%#New England#%#5152627.52929053#%#-8096567.12801993#%#3\r\n15710#%#Hartford, CT#%#New England#%#Unassigned#%#Unassigned#%#Account#%#15710#%#True#%#41.944215#%#-72.732696#%#06026#%#HOMEBOUND#%#33 TURKEY HILL ROAD#%#EAST GRANBY#%#CT#%#6026#%#674#%#4#%#3#%#4#%#0#%#0#%#0#%#0#%#0#%#0#%#0#%#0#%#0#%#0#%#0#%#0#%#0#%#0#%#0#%#0#%#0#%#0#%#Hartford, CT#%#New England#%#5152627.52929053#%#-8096567.12801993#%#3\r\n15923#%#Hartford, CT#%#New England#%#Unassigned#%#Unassigned#%#Account#%#15923#%#True#%#42.0027#%#-72.942#%#06027#%#HOMEBOUND#%#30 SOUTH ROAD#%#EAST HARTLAND#%#CT#%#6027#%#9710#%#4#%#3#%#4#%#0#%#0#%#0#%#0#%#0#%#0#%#0#%#0#%#0#%#0#%#0#%#0#%#0#%#0#%#0#%#0#%#0#%#0#%#Hartford, CT#%#New England#%#5161383.89953631#%#-8119866.29744296#%#3\r\n15922#%#Hartford, CT#%#New England#%#Unassigned#%#Unassigned#%#Account#%#15922#%#True#%#42.0027#%#-72.942#%#06027#%#HARTLAND ELEMENTARY SCHOOL#%#30 SOUTH ROAD#%#EAST HARTLAND#%#CT#%#6027#%#9710#%#1#%#1#%#1#%#0#%#0#%#0#%#2#%#0#%#25#%#17#%#26#%#29#%#37#%#36#%#38#%#35#%#40#%#0#%#0#%#0#%#0#%#Hartford, CT#%#New England#%#5161383.89953631#%#-8119866.29744296#%#3\r\n16335#%#}

my groovy script is 

log.info json."New England Schools__NE Schools\$".dsData

The above prints all the data inside it with column and its data but i am not sure how to get column specific data please help.

For example, Territory is my column and its row value is Hartford, CT

If above is not possible the way I want, then please tell me how to break all the response(split kind of thing as we do in java) so that I can call a specific value?

解决方案

After looking into the detail, noticed that it is having data in the form of rows and columns, separated by #%# and records are separated by carriage return and new line markers.

The data you provided has some extra record with only few fields, so to provide a working script, had to trim that unwanted extra field at the end of it.

Here is the Groovy Script:

def str = '''Account Id#%#Territory#%#District#%#Area#%#Region#%#objname#%#~ID~#%#~Lat-Lon Linked~#%#~Latitude~#%#~Longitude~#%#~Lat-Lon Zip~#%#School Name#%#Address#%#City#%#State#%#ZIP#%#ZIP4#%#School Type#%#Status#%#School Level#%#Count Free Lunch#%#Count Reduced Lunch#%#Total Lunch Pgm#%#Total Students#%#PreKindergarten#%#Kindergarten#%#Grade 1#%#Grade 2#%#Grade 3#%#Grade 4#%#Grade 5#%#Grade 6#%#Grade 7#%#Grade 8#%#Grade 9#%#Grade 10#%#Grade 11#%#Grade 12#%#Territory1#%#Region1#%#lat#%#lon#%#terrid\r\n15709#%#Hartford, CT#%#New England#%#Unassigned#%#Unassigned#%#Account#%#15709#%#True#%#41.934711#%#-72.770021#%#06026#%#R. DUDLEY SEYMOUR SCHOOL#%#185 HARTFORD AVENUE#%#EAST GRANBY#%#CT#%#6026#%#9520#%#1#%#1#%#2#%#0#%#0#%#0#%#131#%#0#%#0#%#0#%#0#%#0#%#60#%#71#%#0#%#0#%#0#%#0#%#0#%#0#%#0#%#Hartford, CT#%#New England#%#5151204.33051376#%#-8100721.57141633#%#3\r\n15707#%#Hartford, CT#%#New England#%#Unassigned#%#Unassigned#%#Account#%#15707#%#True#%#41.934894#%#-72.730656#%#06026#%#EAST GRANBY HIGH SCHOOL#%#95 SOUTH MAIN STREET#%#EAST GRANBY#%#CT#%#6026#%#9550#%#1#%#1#%#3#%#0#%#0#%#0#%#219#%#0#%#0#%#0#%#0#%#0#%#0#%#0#%#0#%#0#%#0#%#57#%#55#%#53#%#54#%#Hartford, CT#%#New England#%#5151231.26605957#%#-8096340.03625871#%#3\r\n15708#%#Hartford, CT#%#New England#%#Unassigned#%#Unassigned#%#Account#%#15708#%#True#%#41.934894#%#-72.730656#%#06026#%#EAST GRANBY MIDDLE SCHOOL#%#95 SOUTH MAIN STREET#%#EAST GRANBY#%#CT#%#6026#%#9550#%#1#%#1#%#2#%#0#%#0#%#0#%#201#%#0#%#0#%#0#%#0#%#0#%#0#%#0#%#67#%#73#%#61#%#0#%#0#%#0#%#0#%#Hartford, CT#%#New England#%#5151231.26605957#%#-8096340.03625871#%#3\r\n15706#%#Hartford, CT#%#New England#%#Unassigned#%#Unassigned#%#Account#%#15706#%#True#%#41.944215#%#-72.732696#%#06026#%#ALLGROVE SCHOOL#%#33 TURKEY HILLS ROAD#%#EAST GRANBY#%#CT#%#6026#%#9570#%#1#%#1#%#1#%#0#%#0#%#0#%#275#%#3#%#69#%#65#%#82#%#56#%#0#%#0#%#0#%#0#%#0#%#0#%#0#%#0#%#0#%#Hartford, CT#%#New England#%#5152627.52929053#%#-8096567.12801993#%#3\r\n15710#%#Hartford, CT#%#New England#%#Unassigned#%#Unassigned#%#Account#%#15710#%#True#%#41.944215#%#-72.732696#%#06026#%#HOMEBOUND#%#33 TURKEY HILL ROAD#%#EAST GRANBY#%#CT#%#6026#%#674#%#4#%#3#%#4#%#0#%#0#%#0#%#0#%#0#%#0#%#0#%#0#%#0#%#0#%#0#%#0#%#0#%#0#%#0#%#0#%#0#%#0#%#Hartford, CT#%#New England#%#5152627.52929053#%#-8096567.12801993#%#3\r\n15923#%#Hartford, CT#%#New England#%#Unassigned#%#Unassigned#%#Account#%#15923#%#True#%#42.0027#%#-72.942#%#06027#%#HOMEBOUND#%#30 SOUTH ROAD#%#EAST HARTLAND#%#CT#%#6027#%#9710#%#4#%#3#%#4#%#0#%#0#%#0#%#0#%#0#%#0#%#0#%#0#%#0#%#0#%#0#%#0#%#0#%#0#%#0#%#0#%#0#%#0#%#Hartford, CT#%#New England#%#5161383.89953631#%#-8119866.29744296#%#3\r\n15922#%#Hartford, CT#%#New England#%#Unassigned#%#Unassigned#%#Account#%#15922#%#True#%#42.0027#%#-72.942#%#06027#%#HARTLAND ELEMENTARY SCHOOL#%#30 SOUTH ROAD#%#EAST HARTLAND#%#CT#%#6027#%#9710#%#1#%#1#%#1#%#0#%#0#%#0#%#2#%#0#%#25#%#17#%#26#%#29#%#37#%#36#%#38#%#35#%#40#%#0#%#0#%#0#%#0#%#Hartford, CT#%#New England#%#5161383.89953631#%#-8119866.29744296#%#3'''
//split by carriage return and new line
def data = str.split('\r\n')
//split by field to get the just column names from header row
def headers = data[0].split('#%#')
//Create map with just header keys, so that it can be used while storing the data
def headerMap = [:]
headers.each { header ->
    headerMap[header] = ''
}
/**
 * Closure allows you to query the required data
 * Need to pass all the records and row (human readable starting with 1) and header key/ field name
 * so the information is displaced as well as returns matched value
 */
def getData = { recordList, row, field ->
    println "Requested data : \n Row : ${row} \n Column : ${field} \n Column Value : ${recordList[row-1].get(field)}"
    recordList[row-1].get(field)
}
// This is the variable which holds all the records
// And each record will be in the form of a map so that it can be queried easily based on the field
def records = []
for (i=1;i<data.size();i++) {
    def fieldData = data[i].split('#%#')
    def record = headerMap.clone()
    if (fieldData.size() == headerMap.size()) {
        def keys = headerMap.keySet()
        for (j=0;j<keys.size();j++) {
            record[keys[j]] = fieldData[j]
        }
        println record
        //Add the record to records
        records << record
    }
}
//Some meta data information
println "Headers : ${headers}"
println "No of headers : ${headers.size()}"
println "No of rows : ${records.size()}"
/**
 * Here is how you can query the specific data
 * and since it returns value, you can also assign it variable as well
 */
getData(records, 1, 'Territory')
getData(records, 7, 'Account Id')
​

You can quickly also verify the output by using the below steps:
Click link => Edit in Console => Execute Script https://groovyconsole.appspot.com/script/5076918839803904

How to query different data? Already provided the script with most of the lines with comments appropriately. You can just use getData() to retrieve any data form it, just pass the records , row number(human readable count starting with 1) and the field name.

Note that I have used println, you may replace it with log.info if needed to use in soapui.

这篇关于SoapUi-如何从json响应中提取列特定的数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！

查看全文
相关文章
其他开发最新文章
热门教程
热门工具
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆