Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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"
}
]
}
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.
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.
Thank you so much!! it worked.