jsonPath return string without brackets

Asked Aug 24 '20 at 20:46

Active Aug 24 '20 at 20:46

Viewed 377 times

I have the following code:

responseBody =     '[{"properties":{"gridProperties":{"columnCount":26,"rowCount":1000},"index":3,"sheetId":1682983530,"sheetType":"GRID","title":"kamasi"}}]';

  
def jsonPathSearch = "sheets[?(@.properties.title=='kamasi')].properties"
def foundString = JsonPath.read(responseBody, jsonPathSearch)

println foundString.sheetId;

but it returns [1682983530], not 1682983530. It this possible to get 1682983530 without having to get the first element of the array such as foundString.sheetId[0] ? I know that there will be definitely only one element since the title of the sheet has to be unique

asked Aug 24 '20 at 20:46

laloune

2

just add `[0]` to get first element of the array – daggett Aug 25 '20 at 00:14
so there is no possibility to return it directly as a string, right ? – laloune Aug 25 '20 at 07:00
I don't get it, if I use the following jsonpath: ``def jsonFieldName = "sheets[?(@.properties.title=='kamasi')].length()`` I also end up with an array : [1]. Why doesn't it return an integer ? – laloune Aug 25 '20 at 08:41
obviously `sheets[...]` returns an array – daggett Aug 25 '20 at 12:58

jsonPath return string without brackets

0 Answers0