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(',')
Mis3's avatar
Mis3
Frequent Contributor

Your script works well.

Is there any way I can remove the "[" and "]" in the outputs (both log.info and report)?

(Groovy script attached)

 

Log.info:

Fri Jun 25 13:39:56 EDT 2021:INFO:[Seq=0, 302130000006120, 14313140097, Status=0, FlowId=1, Status=0, FlowId=2, Status=0, FlowId=3, Status=0, FlowId=4, Status=0, FlowId=5, Status=0, FlowId=6, Status=0, FlowId=7, Status=0, FlowId=8, Status=0]
Fri Jun 25 13:39:57 EDT 2021:INFO:[Seq=1, 302130000006120, 14313140097, Status=0, FlowId=1, Status=0, FlowId=2, Status=0, FlowId=3, Status=0, FlowId=4, Status=0, FlowId=5, Status=0, FlowId=6, Status=0, FlowId=7, Status=0, FlowId=8, Status=0]

Report:

 

SDM-Activate Start: 25_06_2021_13_45_54

[Seq=0, 302130000006120, 14313140097, Status=0, FlowId=1, Status=0, FlowId=2, Status=0, FlowId=3, Status=0, FlowId=4, Status=0, FlowId=5, Status=0, FlowId=6, Status=0, FlowId=7, Status=0, FlowId=8, Status=0,
]
[Seq=1, 302130000006120, 14313140097, Status=0, FlowId=1, Status=0, FlowId=2, Status=0, FlowId=3, Status=0, FlowId=4, Status=0, FlowId=5, Status=0, FlowId=6, Status=0, FlowId=7, Status=0, FlowId=8, Status=0,
]

 

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

Just change
line.flatten()
To
line.flatten().join(',')
  • Mis3's avatar
    Mis3
    Frequent Contributor
    4 years ago

    Perfect.   Although I do not understand your code (one day I will), the script works great.

    Below is the new report.  When I run the campaign for a thousand entries, I can import the report file into EXCEL and easily identify the failures.

    Thanks.

     

    Seq=0 302330000006120 13313140097 Status=0 FlowId=1 Status=0 FlowId=2 Status=0 FlowId=3 Status=0 FlowId=4 Status=0 FlowId=5 Status=0 FlowId=6 Status=0 FlowId=7 Status=0 FlowId=8 Status=0
    Seq=1 302330000007120 13313140098 Status=0 FlowId=1 Status=0 FlowId=2 Status=0 FlowId=3 Status=0 FlowId=4 Status=0 FlowId=5 Status=0 FlowId=6 Status=0 FlowId=7 Status=0 FlowId=8 Status=0