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

Hello nmrao 

Actually Assertion are working fine for me with Json Path Match as below-

[?(@.SourceCode=='${Sources#SourceCode}')].SourceId

But when used in Groovy script as I had provided they are not working. So unable to understand what is issue with syntax . 

 

The JsonSlurper example provided does not have  the details from data source.

So it will not apply.

 

 

 

nmrao's avatar
nmrao
Champion Level 3
4 years ago
Get the response into a variable, say jsonString. And pass that to JsonSlurper().parseText(jsonString).
Now you should be able to follow the given example.
  • Hellotest's avatar
    Hellotest
    Contributor
    4 years ago

    Even though it passes for assertion, I am surprised why it will not work for dynamic extraction.

    There should be a better way to get a value from response.

    • nmrao's avatar
      nmrao
      Champion Level 3
      4 years ago
      You can check with customer care by creating a ticket.

      Any way you are using groovy script. There can be different ways to get the same.
      I have no comments if you want to get in a particular way.

      By the way have you tried the script link given in the initialreply.
      • Hellotest's avatar
        Hellotest
        Contributor
        4 years ago

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