Ready API - Writing the output to datasink in the same excel file

Hi,

I don't know much about datasink but instead of the steps 4, 5 and 6 you can use a single groovy step:

import java.io.File;
import java.io.IOException;
import java.util.Date;
 
import jxl.*;
import jxl.write.*;
import jxl.write.Boolean;
import jxl.write.Number;
import jxl.write.biff.RowsExceededException;

def firstOrder = testRunner.testCase.getTestStepByName( "Properties" ).getPropertyValue( "firstOrderProperty" )
def secondOrder = testRunner.testCase.getTestStepByName( "Properties" ).getPropertyValue( "secondOrderProperty" )

try {
	// Create the excel file
	File exlFile = new File("D:/target_file.xls");
	final WritableWorkbook writableWorkbook = Workbook.createWorkbook( exlFile );	
	// Create a sheet in the excel file
	final WritableSheet writableSheet = writableWorkbook.createSheet("Sheet1", 0);
	
	// Write the first row
	Label label = new Label(0, 0, firstOrder);
	writableSheet.addCell(label);

	// Write the second row
	label = new Label(0, 1, secondOrder);
	writableSheet.addCell(label);

	//Write and close the workbook
	writableWorkbook.write();
	writableWorkbook.close();

} catch (IOException e) {
	e.printStackTrace();
} catch (RowsExceededException e) {
	e.printStackTrace();
} catch (WriteException e) {
	e.printStackTrace();
}

Cheers!

Quickly googled and found:

Workbook workbook1 = Workbook.getWorkbook(new File("D:\\test.xls"));
WritableWorkbook copy = Workbook.createWorkbook(new File("D:\\test.xls"), workbook1);
WritableSheet sheet2 = copy.getSheet(0); 
	
// Write the first row
Label label = new Label(0, 0, firstOrder);
sheet2.addCell(label);

// Write the second row
label = new Label(0, 1, secondOrder);
sheet2.addCell(label);

//Write and close the workbook
copy.write();
copy.close();

As for the other part... you don't necessarily need to create properties for the first/second order. You can get those values directly in the script if you want. So you can replace:

def firstOrder = ...
def secondOrder = ...

with anything you need (for instance you can extract the values from the response directly here)

Let me know if you need more help. :D

I will try to help you but only later today. I am quite busy now. :smileyhappy:

Just a thing... I saw no <document> node in your response.

I think there are multiple  ways to do this. This is how I did it:

I  gave all the requests where I wanted to extract the customerPO and documentNumber a similar name (notice GetOrder_*):

Then in the groovy script I simply looped over all the test steps with that similar name and extracted the required elements:

import java.io.File;
import java.io.IOException;
import jxl.*;
import jxl.write.*;

// Define the customerPo and documentNumber variables
def customerPo = ''
def documentNumber = ''
def requestCounter = 0

// Get a list of all test steps in the current test case
def testSteps = context.testCase.getTestStepList()
// Loop through all the test steps in the current test case
// If a test step respects a certain naming then extract the response from it
//   and register the customerPo and documentNumber in an excel
testSteps.each{
	if (it.name.startsWith("GetOrder_")) {

		/**
		 * Extract the customerPo and documentNumber from current request
		 */
		def rawResponse = testRunner.testCase.testSteps[ it.name ].testRequest.response.contentAsString
		// Extract customerPo
		def customerPoStartIndex = rawResponse.indexOf("<customerPO>") + "<customerPO>".length()
		customerPo = rawResponse.substring( customerPoStartIndex, rawResponse.indexOf( "</", customerPoStartIndex ) )
		// Extract documentNumber
		def documentNumberStartIndex = rawResponse.indexOf("<documentNumber>") + "<documentNumber>".length()
		documentNumber = rawResponse.substring( documentNumberStartIndex, rawResponse.indexOf( "</", documentNumberStartIndex ) )

		/**
		 * Write to file
		 */
		Workbook workbook = Workbook.getWorkbook(new File("D:\\test3.xls"));
		WritableWorkbook writableWorkbook = Workbook.createWorkbook(new File("D:\\test3.xls"), workbook);
		WritableSheet writableSheet = writableWorkbook.getSheet(0); 
			
		// Write the first colummn
		Label label = new Label( 0, requestCounter, customerPo );
		writableSheet.addCell(label);

		// Write the second colummn
		Label label2 = new Label( 1, requestCounter, documentNumber );
		writableSheet.addCell(label2);
		
		//Write and close the workbook
		writableWorkbook.write();
		writableWorkbook.close();

		requestCounter++
	}
}

Hope it helps!

The current iteration can be extracted like:

def currentRow = testRunner.testCase.testSteps['DataSourceStepName'].currentRow