//Ignore, formatting variable
newLine = "..................................................";

// TEST VARIABLES: Change these to your orgID and a selected invoice number to use to test
/*
orgID - Should be the Orginization ID pulled from Books (NOT CRM).
When looking at the url for books it is: https://books.zoho.com/app/53XXXXXX#/
The 53XXXXXX is the number you want (no #)

selectedInvoiceNumber - This is the invoice number.
It should look something like this: INV-672689

Note: Don't forget to change the oauth connection name as well (CHANGE_ME_BOOKS_CONNECTION)
This would be the "Connection Link Name" found when going to:
CRM settings -> Developer Hub -> Connections -> My Connections

You will need a books connection. Just give it all scopes for testing and remove it later.

This script only reads data it does not write anything.
*/

orgID = "CHANGE_ME";
selectedInvoiceNumber = "CHANGE_ME";

// Search parameter to get active invoices
searchParams = {"invoice_number":selectedInvoiceNumber};

// Step 1: Get the test invoice via getRecords:
response = zoho.books.getRecords("Invoices",orgID,searchParams,"CHANGE_ME_BOOKS_CONNECTION");

if(response.size() > 0 && response.get("invoices").size() > 0)
{
	selectedInvoice = response.get("invoices").get(0);

	// Debug: Print the invoice data, uncomment to debug
	//info selectedInvoice;

	invoiceID = selectedInvoice.get("invoice_id").toString();
	transactionType1 = selectedInvoice.get("transaction_type").toString();

	// Step 2: Retrieve the same invoice using getRecordsByID:
	selectedInvoice2 = zoho.books.getRecordsByID("Invoices",orgID,invoiceID,"CHANGE_ME_BOOKS_CONNECTION");

	// Debug: Print the invoice data, uncomment to debug
	//info selectedInvoice2;
	
    transactionType2 = selectedInvoice2.get("transaction_type").toString();
	
    // Step 3: Print both transaction types
	return "getRecords: " + transactionType1 + " " + newLine
        + " " + "getRecordsById: " + transactionType2;
}
else
{
	return "No invoice found with the specified number";
}