Forum Discussion

Hellotest's avatar
Hellotest
Contributor
4 years ago

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 sourceI...
  • nmrao's avatar
    nmrao
    4 years ago
    Hellotest wrote:

    I tried first with out datasource as below but getting null pointer error as attached. 

     

    import static com.jayway.jsonpath.JsonPath.parse
    def jsonString = context.expand( '${GetSources#Response}' )
    def sourceId = new groovy.json.JsonSlurper().parseText(jsonString).result.find{it.SourceCode == 'ABC'}
    log.info "source id: ${sourceId.SourceId}"

     

    You almost there, but trivial errors.

     

     

     

    //Get the parsed json of GetSources test step response
def json = new groovy.json.JsonSlurper().parseText(context('${GetSources#Response}'))

//Closure to the the SourceId for a given SourceCode of the json
def getSourceIdBySourceCode = { code ->  json.find {it?.SourceCode == code}?.SourceId }

//Check if the value is matching
assert 'b4035134-ca33-4b33-b3c7-06ea880f1f28' == getSourceIdBySourceCode( 'DEF')
assert 'bc3cef1e-a9f1-46df-a4f0-c1131357ea57' == getSourceIdBySourceCode( 'ABC')

     

     

     

    You can test it online here

    https://ideone.com/p8X57U

Hellotest's avatar
Hellotest
Contributor

I tried first with out datasource as below but getting null pointer error as attached. 

 

import static com.jayway.jsonpath.JsonPath.parse
def jsonString = context.expand( '${GetSources#Response}' )
def sourceId = new groovy.json.JsonSlurper().parseText(jsonString).result.find{it.SourceCode == 'ABC'}
log.info "source id: ${sourceId.SourceId}"

 

Error- java.lang.NullPointerEcxeption: Cannot get property 'source code' on null object  error at line 3 

Not sure what is wrong here.

 

Response JSON

[
{
"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",
}
]

nmrao's avatar
nmrao
Champion Level 3
4 years ago
Hellotest wrote:

I tried first with out datasource as below but getting null pointer error as attached. 

 

import static com.jayway.jsonpath.JsonPath.parse
def jsonString = context.expand( '${GetSources#Response}' )
def sourceId = new groovy.json.JsonSlurper().parseText(jsonString).result.find{it.SourceCode == 'ABC'}
log.info "source id: ${sourceId.SourceId}"

 

You almost there, but trivial errors.

 

 

 

//Get the parsed json of GetSources test step response
def json = new groovy.json.JsonSlurper().parseText(context('${GetSources#Response}'))

//Closure to the the SourceId for a given SourceCode of the json
def getSourceIdBySourceCode = { code ->  json.find {it?.SourceCode == code}?.SourceId }

//Check if the value is matching
assert 'b4035134-ca33-4b33-b3c7-06ea880f1f28' == getSourceIdBySourceCode( 'DEF')
assert 'bc3cef1e-a9f1-46df-a4f0-c1131357ea57' == getSourceIdBySourceCode( 'ABC')

 

 

 

You can test it online here

https://ideone.com/p8X57U

  • Hellotest's avatar
    Hellotest
    Contributor
    4 years ago

    Thanks nmrao for your suggestions. It is working fine but failing in one condition.

     

    example- In situation where XYZ is not present in JSON .

    getSourceIdBySourceCode( 'XYZ')

     

    XYZ is coming form my datasource but that value may not be present in JSON then getting null pointer.

    here we are supposed to add new source but prior to it , need to check source id but getting java.lang.NullPointerException : cannot get property 'Sourceid' on null object.

  • nmrao's avatar
    nmrao
    Champion Level 3
    4 years ago
    Thanks for trying it out.

    Have updated the script in the above post to handle NPE.
    Please take the updated one and check.
  • Hellotest's avatar
    Hellotest
    Contributor
    4 years ago

    Hello nmrao,

    I am not able to find the updated post with NPE. Could you please check and post it again.

  • nmrao's avatar
    nmrao
    Champion Level 3
    4 years ago

    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.

  • Hellotest's avatar
    Hellotest
    Contributor
    4 years ago

    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.

  • nmrao's avatar
    nmrao
    Champion Level 3
    4 years ago
    Thank you for your patience and trying it out.
    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.