Forum Discussion

Mis3's avatar
Mis3
Frequent Contributor
4 years ago

How to assign attributes of a node to variables to output to a log file?

Not sure how to assign the attributes of a node to variables so I can output to a log file.  Please help. The request contains 8 API and the result contains 9 responses (1 for the whole request and ...
  • nmrao's avatar
    nmrao
    4 years ago

    Mis3 

    Here you go:

     

     

    If that is output you need? Then please use

     

     

    //Assuming you have data array, variable i, and xmlString
//Apart from that you can remove everything from the script
def line = ["Seq=${i}", data[0], data[1] ]
line << new XmlSlurper().parseText(xmlString).'**'.findAll {it.name() == 'sdmDataResponse' }.collectMany{ ["FlowId=${it.@flowId}", "Status=${it.children()[0].@resultCode}" ]}
log.info line.flatten()

     

  • nmrao's avatar
    nmrao
    4 years ago
    I thought I saw those brackets from your response.

    Just change
    line.flatten()
    To
    line.flatten().join(',')
nmrao's avatar
nmrao
Champion Level 3
4 years ago

Couple of things

- in the previous question, it was answer how to access the values of node attributes using @ for ex, @resultCode, @message

- In the response provided, there is no where values available 302330000007120, 12313140098 etc

- Understand that you might to print the data in certain format. Please show the expected data to be logged from given response. I case see you mentioned print in online. But can't understand MESSAGE1, 2 etc.,

- In the given response, only flowId is different, and resultCode and message are same.

  • Mis3's avatar
    Mis3
    Frequent Contributor
    4 years ago

    My comments inline below.

    The reason of this Groovy script is I have to read from an external file with hundreds of entries and execute a teststep with each entry. 

    As it stands now, there are at least 8 lines per execution of the teststep.   

    I am hoping to find a way to "flatten" the report file.  I can then import this report file in EXCEL and filters out the failed API.

     

    - in the previous question, it was answer how to access the values of node attributes using @ for ex, @resultCode, @message

    -->  Yes, I have learned how to read the node attributes.  I like to learn how to organize these results to a report file.

     

    - In the response provided, there is no where values available 302330000007120, 12313140098 etc

    -->  302330000007120, 12313140098 are the data the Groovy read from an external file.

    -->  I added this line  log.info " Seq="+i+" "+data[0]+", "+data[1]  to identify each data entry.

    -->  The CSV file:

    302330000006120, 12313140097

    302330000007120, 12313140098

     

    - Understand that you might to print the data in certain format. Please show the expected data to be logged from given response. I case see you mentioned print in online. But can't understand MESSAGE1, 2 etc.,

    -->  I am hoping to equate:

    MESSAGE1 to  @resultCode of FlowId=1 (changeImsiDataRequest)

    MESSAGE2  to @resultCode of FlowId=1 (changeMsisdnDataRequest)

    etc.

    -->  This way, I can use this line << "\n"+ "Seq="+i+" "+sdf.format(log_date)+" "+data[0]+" "+data[1]+" Result: ["+MESSAGE1+"] "+MESSAGE2

    to output to the report file like:

    Seq=0 06/24/2021 08:55:43 302330000006120 12313140097 Result: FlowId=1, Status=0, FlowId=2, Staus=0

    Seq=0 06/24/2021 08:55:43 302330000007120 12313140099 Result: FlowId=1, Status=0, FlowId=2, Staus=0

     

    - In the given response, only flowId is different, and resultCode and message are same.

    -->   resultCode can be different.  0=Success, 30=Inconsistent data, 40=record not found

     

    • nmrao's avatar
      nmrao
      Champion Level 3
      4 years ago
      Still not sure about adding data from csv. But that ok. Probably you will be able to handle it if the other part is available.
      I am under impression that the response might be partial. So are those values you send them in request?
      Thanks for your responses.
    • nmrao's avatar
      nmrao
      Champion Level 3
      4 years ago

      Mis3 

      Here you go:

       

       

      If that is output you need? Then please use

       

       

      //Assuming you have data array, variable i, and xmlString
//Apart from that you can remove everything from the script
def line = ["Seq=${i}", data[0], data[1] ]
line << new XmlSlurper().parseText(xmlString).'**'.findAll {it.name() == 'sdmDataResponse' }.collectMany{ ["FlowId=${it.@flowId}", "Status=${it.children()[0].@resultCode}" ]}
log.info line.flatten()

       

      • Mis3's avatar
        Mis3
        Frequent Contributor
        4 years ago

        Thanks, Rao. 

        I did not copy in the full Groovy because if the post is too long, it would be hard to read.   This time, I have create a small document to include the full request, Groovy script, test input file, log.info and the external log file.

         

        I copied the code from your previous post and it works well.

        I see 2 minor issues:

        1. In the output, I am missing the resultCode of the whole request; ie: changeSdmDataResponse  (3rd line from the top)

        2. In the report file, there is no line break.  (your code looks complicated, I do not want to touch it"