tRestClient to tExtractJSONFields unable to extract data

[anand17072020]

Hi All,

I am able to print to tLogRow from tRestClient the whole json file without any issues. But having issues with extracting the fields I need using tExtractJSONFields from tRestClient.

Json file:

{

 "message": "Successfully retrieved promotions",

 "errors": [],

 "validationErrors": [],

 "data": [

 {

  "tlt": "005",

  "appName": "platform"

 },

 {

  "tlt": "007",

  "appName": "server"

 }

 ]

}

[rhall1 · Accepted solution]

You need to make a couple. of changes here. The first change is that the tRestClient will be passing the JSON using the "string" column and not the "body" column. So change your JSON field to "string". The next is your "Loop jsonpath query". This needs to be....

" $.data[*]"

After these changes, it should start producing results for you.

[anand17072020]

Thank you so much!! it worked.