Getting error with dynamic extractions in Groovy script
SOLVED- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Getting error with dynamic extractions in Groovy script
Hello,
In Groovy Script trying to extract value from API Response . Instead of getting first value in Json trying to extract dynamically by referring to its value from datasource.
Ex- def sourceId = context.expand( '${GetSources#Response#$[0][\'SourceId\']}' )
Here instead of extracting 0th element, I need to get sourceId based on sourceCode.
Sources is datasource name
So I tried below 3 different ways but error is thrown. Attached error.
1. def sourceId = context.expand( '${GetSources#Response#$[[?@.SourceCode=='${Sources#SourceCode}')].SourceId][\'SourceId\']}' )
2. def sourceId = context.expand( '${GetSources#Response#$[[?(@.SourceCode=='${Sources#SourceCode}')].SourceId]}')
3.def sourceId = context.expand( '${GetSources#Response#$[?(@.SourceCode=='${Sources#SourceCode}')].SourceId]}')
Please suggest the correct syntax .
Here is format of GET API Response
[
{
"SourceId": "bc3cef1e-a9f1-46df-a4f0-c1131357ea57",
"SourceCode": "ABC",
"CodeTier": "123",
"SourceDescription": "ABC Desc"
},
{
"SourceId": "b4035134-ca33-4b33-b3c7-06ea880f1f28",
"SourceCode": "DEF",
"CodeTier": "456",
"SourceDescription": "DEF Descr"
},
{
"SourceId": "9666bd19-1916-4052-9044-06b0e38e9175",
"SourceCode": "GHI",
"SourceDescription": "GHI Descr",
}
Solved! Go to Solution.
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Have updated the script in the above post to handle NPE.
Please take the updated one and check.
Regards,
Rao.
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello nmrao,
I am not able to find the updated post with NPE. Could you please check and post it again.
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Its trivial change. Edit was done in the code of the post. That's what I said. Just compare the code you tried.
You won't be able to notice the change unless you look at character by character.
Regards,
Rao.
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks nmrao. It worked.
Could you suggest any library or link ,where I can refer more on these Json response , as there would be more of these kind of scenario's to handle. Thank you in advance.
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You can google for apache-groovy documentation.
Also you can find different sample on my github\ (shared in first reply) repo.
Appreciate if you mark "Accept the Solution" for the actual reply.
Regards,
Rao.

- « Previous
-
- 1
- 2
- Next »
- « Previous
-
- 1
- 2
- Next »