/* *******************************************************************************
	Function:       Map fn_GetSystemValues()
	Trigger:        Snippet to be used at beginning of code to get dynamic maps of system values
	Purpose:		Taxes, Currencies, Payment Terms, Sales Persons, and Nominal Accounts
	Inputs:         -
	Outputs:        -

	Date Created:   2021-09-24 (Ascent Business - Joel Lipman)
					- Initial release
	Date Modified:	???
					- ???
******************************************************************************* */
//
// our made up books org id but enter your own 
v_BooksOrgID=12345678901; 
//
// ---------------------------------
// ZohoBooks Taxes
m_Taxes = Map();
r_Taxes = invokeurl
[
	url :"https://books.zoho.eu/api/v3/settings/taxes?organization_id=" + v_BooksOrgID
	type :GET
	connection:"zbooks"
];
for each  m_Tax in r_Taxes.get("taxes")
{
	m_Taxes.put(m_Tax.get("tax_percentage").toString(),m_Tax.get("tax_id"));
}
info m_Taxes;
// 
// ---------------------------------
// get currencies 
m_Currencies = Map(); 
r_Currencies = invokeUrl 
[ 
    url :"https://books.zoho.eu/api/v3/settings/currencies?organization_id=" + v_BooksOrgID 
    type :GET 
    connection:"zbooks" 
]; 
for each  m_Currency in r_Currencies.get("currencies") 
{ 
    m_Currencies.put(m_Currency.get("currency_code"),m_Currency.get("currency_id")); 
} 
info m_Currencies; 
//
// ---------------------------------
// get payment terms
m_PaymentTerms = Map();
r_PaymentTerms = invokeUrl 
[ 
    url :"https://books.zoho.com/api/v3/settings/paymentterms?organization_id=" + v_BooksOrgID 
    type :GET 
    connection:"zbooks" 
]; 
l_PaymentTerms = r_PaymentTerms.get("data").get("payment_terms");
for each  m_PaymentTerm in l_PaymentTerms 
{ 
    m_PaymentTerms.put(m_PaymentTerm.get("payment_terms_label"),m_PaymentTerm.get("payment_terms")); 
} 
info m_PaymentTerms; 
//
// ---------------------------------
// get sales persons
m_SalesPersons = Map();
/*
r_SoDetails = zoho.crm.getRecordById("Sales_Orders",p_SoID); 
v_CRMOwnerID = r_SoDetails.get("Owner").get("id"); 
v_Filter = "crm_reference_id=" + v_OwnerID;
*/
// set v_Filter to blank to retrieve all sales persons
v_Filter = "";
r_AllSalesPersons = zoho.books.getRecords("salespersons", v_BooksOrgID, v_Filter, "zbooks"); 
for each  m_SalesPerson in r_AllSalesPersons.get("data")
{ 
    m_SalesPersons.put(m_SalesPerson.get("salesperson_email"),m_SalesPerson.get("salesperson_id")); 
} 
info m_SalesPersons; 
//
// ---------------------------------
// get chart of accounts to use: UK
r_ChartOfAccountsUK = invokeurl
[
	url :"https://books.zoho.eu/api/v3/chartofaccounts?organization_id=" + v_BooksOrgID
	type :GET
	connection:"zbooks"
];
m_NominalAccountsUK = Map();
if(!isnull(r_ChartOfAccountsUK.get("chartofaccounts")))
{
	for each  m_NomAccount in r_ChartOfAccountsUK.get("chartofaccounts")
	{
		m_NominalAccountsUK.put(m_NomAccount.get("account_name"),m_NomAccount.get("account_id"));
	}
}
info m_NominalAccountsUK;

1.  /* ******************************************************************************* 
2.      Function:       Map fn_GetSystemValues() 
3.      Trigger:        Snippet to be used at beginning of code to get dynamic maps of system values 
4.      Purpose:        Taxes, Currencies, Payment Terms, Sales Persons, and Nominal Accounts 
5.      Inputs:         - 
6.      Outputs:        - 
7.   
8.      Date Created:   2021-09-24 (Ascent Business - Joel Lipman) 
9.                      - Initial release 
10.      Date Modified:    ??? 
11.                      - ??? 
12.  ******************************************************************************* */ 
13.  // 
14.  // our made up books org id but enter your own 
15.  v_BooksOrgID=12345678901; 
16.  // 
17.  // --------------------------------- 
18.  // ZohoBooks Taxes 
19.  m_Taxes = Map(); 
20.  r_Taxes = invokeUrl 
21.  [ 
22.      url :"https://books.zoho.eu/api/v3/settings/taxes?organization_id=" + v_BooksOrgID 
23.      type :GET 
24.      connection:"zbooks" 
25.  ]; 
26.  for each  m_Tax in r_Taxes.get("taxes") 
27.  { 
28.      m_Taxes.put(m_Tax.get("tax_percentage").toString(),m_Tax.get("tax_id")); 
29.  } 
30.  info m_Taxes; 
31.  // 
32.  // --------------------------------- 
33.  // get currencies 
34.  m_Currencies = Map(); 
35.  r_Currencies = invokeUrl 
36.  [ 
37.      url :"https://books.zoho.eu/api/v3/settings/currencies?organization_id=" + v_BooksOrgID 
38.      type :GET 
39.      connection:"zbooks" 
40.  ]; 
41.  for each  m_Currency in r_Currencies.get("currencies") 
42.  { 
43.      m_Currencies.put(m_Currency.get("currency_code"),m_Currency.get("currency_id")); 
44.  } 
45.  info m_Currencies; 
46.  // 
47.  // --------------------------------- 
48.  // get payment terms 
49.  m_PaymentTerms = Map(); 
50.  r_PaymentTerms = invokeUrl 
51.  [ 
52.      url :"https://books.zoho.com/api/v3/settings/paymentterms?organization_id=" + v_BooksOrgID 
53.      type :GET 
54.      connection:"zbooks" 
55.  ]; 
56.  l_PaymentTerms = r_PaymentTerms.get("data").get("payment_terms"); 
57.  for each  m_PaymentTerm in l_PaymentTerms 
58.  { 
59.      m_PaymentTerms.put(m_PaymentTerm.get("payment_terms_label"),m_PaymentTerm.get("payment_terms")); 
60.  } 
61.  info m_PaymentTerms; 
62.  // 
63.  // --------------------------------- 
64.  // get sales persons 
65.  m_SalesPersons = Map(); 
66.  /* 
67.  r_SoDetails = zoho.crm.getRecordById("Sales_Orders",p_SoID); 
68.  v_CRMOwnerID = r_SoDetails.get("Owner").get("id"); 
69.  v_Filter = "crm_reference_id=" + v_OwnerID; 
70.  */ 
71.  // set v_Filter to blank to retrieve all sales persons 
72.  v_Filter = ""; 
73.  r_AllSalesPersons = zoho.books.getRecords("salespersons", v_BooksOrgID, v_Filter, "zbooks"); 
74.  for each  m_SalesPerson in r_AllSalesPersons.get("data") 
75.  { 
76.      m_SalesPersons.put(m_SalesPerson.get("salesperson_email"),m_SalesPerson.get("salesperson_id")); 
77.  } 
78.  info m_SalesPersons; 
79.  // 
80.  // --------------------------------- 
81.  // get chart of accounts to use: UK 
82.  r_ChartOfAccountsUK = invokeUrl 
83.  [ 
84.      url :"https://books.zoho.eu/api/v3/chartofaccounts?organization_id=" + v_BooksOrgID 
85.      type :GET 
86.      connection:"zbooks" 
87.  ]; 
88.  m_NominalAccountsUK = Map(); 
89.  if(!isnull(r_ChartOfAccountsUK.get("chartofaccounts"))) 
90.  { 
91.      for each  m_NomAccount in r_ChartOfAccountsUK.get("chartofaccounts") 
92.      { 
93.          m_NominalAccountsUK.put(m_NomAccount.get("account_name"),m_NomAccount.get("account_id")); 
94.      } 
95.  } 
96.  info m_NominalAccountsUK;