Forum Discussion

doubtsreadyapi's avatar
doubtsreadyapi
Contributor
5 years ago

Require Groovy script for Parameterizing the value in next request

Hi   My GET Method response is like below, But when i do get once the Id changes and the place "journals|0_0_7|JOURNALS_PART_ONE" and "journals|0_0_7|JOURNALS_MAPPING" changes, that is some times "...
doubtsreadyapi's avatar
doubtsreadyapi
Contributor

Hi nmrao 

 

The Pack_id :""pack_id" : "journals|0_0_7|PART_ONE", remains fixed, where as for this pack_id i have to pick the id and parameterize to next request,  But the node value for pack_id keep changing i said eariler the pack_id : journals|0_0_7|PART_ONE, will be coming last in the response ,  The id value will keep changing. Status doesnt matter.

 

So in the below response, if ""pack_id" = "journals|0_0_7|PART_ONE", i have to pick the id for this pack_id and parameterize to the next request.

 

"dependencies" : [
{
"id" : 13311,
"pack_id" : "journals|0_0_7|PART_TWO",
"status" : "not_started",
"output" : null,
"run_id" : null
},
{
"id" : 13312,
"pack_id" : "journals|0_0_7|PART_ONE",
"status" : "complete",
"output" : null,
"run_id" : ""
},
{
"id" : 13313,
"pack_id" : "journals|0_0_7|MAPPING",
"status" : "waiting",
"output" : [
{
],

 

Thanks

  • doubtsreadyapi's avatar
    doubtsreadyapi
    Contributor
    5 years ago

    Hi nmrao 

     

    I have tried with the below code, where as i am getting null pointer exception, attached is the error for the same.

     

    My code is

    import groovy.json.JsonSlurper;

    def res = context.expand( '${Get_Period_Id#Response}' )

    def packid = new groovy.json.JsonSlurper().parseText(res).result.find{it.pack_id =="journals|0_0_7|JOURNALS_PART_ONE"}.dependencies

     

     

    My response node is like below, i have to dependency_parameters instead of dependencies?

     

    "dependency_parameters" : {
    "c_fa" : [
    {
    "journals_in_scope" : true,
    "company_codes" : [
    "1",
    "16",

    ],
    "id" : "s7879987998",
    "name" : "abcd"
    }
    ]
    },

    "dependencies" : [
    {
    "id" : 13336,
    "pack_id" : "journals|0_0_7|JOURNALS_PART_TWO",
    "status" : "not_started",
    "output" : null,
    "run_id" : null
    },
    {
    "id" : 13337,
    "pack_id" : "journals|0_0_7|JOURNALS_PART_ONE",
    "status" : "not_started",
    "output" : null,
    "run_id" : null
    },
    {
    "id" : 13338,
    "pack_id" : "journals|0_0_7|JOURNALS_MAPPING",
    "status" : "not_started",
    "output" : null,
    "run_id" : null
    }
    ]
    }

     

     

  • nmrao's avatar
    nmrao
    Champion Level 3
    5 years ago
    Is it a valid json which you posted latest?
  • doubtsreadyapi's avatar
    doubtsreadyapi
    Contributor
    5 years ago

    nmrao 

     

    Yes its valid json, but this got resolved i tried in different way, it worked

     

    Thanks for the help

  • nmrao's avatar
    nmrao
    Champion Level 3
    5 years ago
    Glad you got it working.
  • richie's avatar
    richie
    Community Hero
    5 years ago
    Hey doubtsreadyapi!

    I got a script working but its different to yours and far less efficient. Im learning so would welcome if you posted the working script you used?

    You published the script you were using but it was erroring out and you made some sort or change, so would you mind in the interests of my education, publish the working script?

    Many thanks fella,

    Rich
  • richie's avatar
    richie
    Community Hero
    5 years ago
    Hey doubtsreadyapi,

    Thanks man.....youre the best!

    Rich
  • richie's avatar
    richie
    Community Hero
    5 years ago
    Hey doubtsreadyapi!

    Im not picking holes in your script but reading it, im wondering if the script actually does what you asked for.

    Originally i thought your response could return multiple records (at least 3) and you wanted to extract the "id" attribute value where "pack_id" = "journals|0_0_7|JOURNALS_PART_ONE" and this particular record could appear in your response at any position (so it could be generated in record1, or record2, or record3......recordx) was that correct?

    The reason i ask is that currently the script will write out the "id" value to a testcase level property if "pack_id" = "journals|0_0_7|JOURNALS_PART_ONE" if it is generated in record1 and if it isnt, then the else part executes and it writes the "id" value to the testcase level property whatever the "pack_id" value is.

    I dont think this script does what you originally asked for cos it assumes that there isnt more than 2 records in the response and the else will write the "id" value to the property when the "pack_id" isnt "journals|0_0_7|JOURNALS_PART_ONE"

    Please understand.....im not criticising at all, i just wanna make sure your script does exactly what you need as it doesnt appear to equate to your initial requirements considering the response payload appears to include the record youre actually interested in, anywhere in your response and the response contains multiple (at least 3) records.

    Nice one,

    Rich