Unable to normalize the results using restAPI call in tlogrow

[Haresh]

I have a job design as attached and i am trying to extract the results from trestapi call and use treplicate & tnormalize to display the unique combination of executionID & triggerTimestamp column results,but for some reason it always gets duplicated after extraction.

Please suggest what needs to be fixed:

I would like to capture the results in the context variables and perform manipulation for every iteration of executionID & triggerTime column combination!

tjava3:

 context.testexecutionID=((String)globalMap.get("executionID"));

 context.triggerTimestamp=((String)globalMap.get("triggerTimestamp"));

   context.executionID=context.testexecutionID.substring(5, context.testexecutionID.lastIndexOf("\"")-3);

 context.triggerTime=context.triggerTimestamp.substring(5, context.triggerTimestamp.lastIndexOf("\"")-3);

Since the iteration results are not ideal,i am getting unparseable data in tjava3 error!

[Anonymous]

Hi

As you done, for debugging, we usually use tLogRow component to print the result on the console to check if we have the expected result in each step. If you are getting error, please paste the error messages, and tell us what are your expected result.

Regards

Shong

[gjeremy1617088143]

Hi, maybe it could be better to use textractJsonFields component, could you send an exemple of the input json ?