XERO JINT - Revision history

WikiSysopdi at 10:07, 10 September 2025

2025-09-10T10:07:49Z

← Older revision		Revision as of 10:07, 10 September 2025
Line 132:		Line 132:
	---		---

	Sample querying the ~~Norwind~~ database and populating XERO		Sample querying the Northwind database and populating XERO

	<nowiki>		<nowiki>

WikiSysopdi at 10:07, 10 September 2025

2025-09-10T10:07:07Z

← Older revision		Revision as of 10:07, 10 September 2025
Line 132:		Line 132:
	---		---

			Sample querying the Norwind database and populating XERO

			<nowiki>
			di.clear();
			di.addserver(4); //sql northwind server

			var customers = di.querydb("select * from customers where ContactName like '%Maria%'");
			di.addserver(6); //xero server
			for(var x=0;x<customers.Rows.Count;x++)
			{
			var nameValue = customers.Rows[x]['ContactName'];
			di.display('ContactName: ' + nameValue);
			var record = di.querydb("contacts","Name='"+nameValue+"'");
			di.display("record record count: " + record.Rows.Count);
			if(record == null \|\| record.Rows.Count <= 0)
			{
			di.display("Record not exist, so creating...");
			var xeroRecord = XeroRecord('contacts');
			xeroRecord.Set("Name",nameValue);
			var id = xeroRecord.Insert();
			di.display("New Xero Record: "+id);
			}
			else
			{
			di.display("Record already exist");
			}
			}
			</nowiki>
			---
	getGUID - This is used where you have a given key value and need the Guid ID. Only one result is returned so this depends on the named key value being unique. Otherwise use querydb.		getGUID - This is used where you have a given key value and need the Guid ID. Only one result is returned so this depends on the named key value being unique. Otherwise use querydb.

WikiSysopdi at 07:40, 28 August 2025

2025-08-28T07:40:05Z

← Older revision		Revision as of 07:40, 28 August 2025
Line 128:		Line 128:
	xeroBatch.process();		xeroBatch.process();
	</nowiki>		</nowiki>

			"Mode" can be "Insert" or "Update"
	---		---

WikiSysopdi at 12:00, 14 August 2025

2025-08-14T12:00:15Z

← Older revision		Revision as of 12:00, 14 August 2025
Line 22:		Line 22:
	xeroContact.Set("Name", "John Doe");		xeroContact.Set("Name", "John Doe");
	xeroRecord.setContact(xeroContact);		xeroRecord.setContact(xeroContact);
	xeroRecord.Set("Date", ~~"7/29/2025 12:00:00 AM"~~);		xeroRecord.Set("Date", new Date());
	var xeroLineItems = XeroRecord('lineitems');		var xeroLineItems = XeroRecord('lineitems');
	xeroLineItems.Set("Description", "test-description");		xeroLineItems.Set("Description", "test-description");
Line 57:		Line 57:
	xeroContact.Set("Name", "John Doe");		xeroContact.Set("Name", "John Doe");
	xeroRecord.setContact(xeroContact);		xeroRecord.setContact(xeroContact);
	xeroRecord.Set("Date", ~~"7/29/2025 12:00:00 AM"~~);		xeroRecord.Set("Date", new Date());
	var id = '05a07235-cf69-452f-bd69-3d037b62acea';		var id = '05a07235-cf69-452f-bd69-3d037b62acea';
	xeroRecord.Update(id);		xeroRecord.Update(id);
Line 72:		Line 72:
	xeroLineItem.Set("Description", "test-description");		xeroLineItem.Set("Description", "test-description");
	xeroRecord.setLineItem(xeroLineItem);		xeroRecord.setLineItem(xeroLineItem);
	xeroRecord.Set("Date", ~~"7/29/2025 12:00:00 AM"~~);		xeroRecord.Set("Date", new Date());
	var id = xeroRecord.Insert();		var id = xeroRecord.Insert();
	di.display(id);		di.display(id);
Line 90:		Line 90:
	xeroRecord.LineItems.Add(xeroLineItem1);		xeroRecord.LineItems.Add(xeroLineItem1);
	xeroRecord.LineItems.Add(xeroLineItem2);		xeroRecord.LineItems.Add(xeroLineItem2);
	xeroRecord.Set("Date", ~~"7/29/2025 12:00:00 AM"~~);		xeroRecord.Set("Date", new Date());
	var id = xeroRecord.Insert();		var id = xeroRecord.Insert();
	di.display(id);		di.display(id);
Line 122:		Line 122:
	xeroContact.Set("Name", "John Doe");		xeroContact.Set("Name", "John Doe");
	xeroRecord_quote.setContact(xeroContact);		xeroRecord_quote.setContact(xeroContact);
	xeroRecord_quote.Set("Date", ~~"7/29/2025 12:00:00 AM"~~);		xeroRecord_quote.Set("Date", new Date());
	xeroRecord_quote.id = '05a07235-cf69-452f-bd69-3d037b62acea';		xeroRecord_quote.id = '05a07235-cf69-452f-bd69-3d037b62acea';
	xeroRecord_quote.mode="Update";		xeroRecord_quote.mode="Update";

WikiSysopdi at 11:01, 14 August 2025

2025-08-14T11:01:03Z

← Older revision		Revision as of 11:01, 14 August 2025
Line 17:		Line 17:

	var xeroRecord = XeroRecord('quotes');		var xeroRecord = XeroRecord('quotes');
	xeroRecord.Set("QuoteNumber", "~~TestXeroQuote8~~");		xeroRecord.Set("QuoteNumber", "QT-8888");
	var xeroContact = XeroRecord('contacts');		var xeroContact = XeroRecord('contacts');
	xeroContact.Set("ContactID", "ab215683-f30f-49f1-afa2-54d9fa90217e");		xeroContact.Set("ContactID", "ab215683-f30f-49f1-afa2-54d9fa90217e");

WikiSysopdi at 11:00, 14 August 2025

2025-08-14T11:00:39Z

← Older revision		Revision as of 11:00, 14 August 2025
Line 32:		Line 32:
	<nowiki>		<nowiki>
	var xeroRecord = XeroRecord('invoices');		var xeroRecord = XeroRecord('invoices');
	xeroRecord.Set("InvoiceNumber", "~~TestXeroInvoice4~~");		xeroRecord.Set("InvoiceNumber", "IN-88888");
	var xeroContact = XeroRecord('contacts');		var xeroContact = XeroRecord('contacts');
	xeroContact.Set("ContactID", "54233ac1-92eb-449b-b559-149c2fcb7366");		xeroContact.Set("ContactID", "54233ac1-92eb-449b-b559-149c2fcb7366");
	xeroContact.Set("Name", "~~TestXeroContact13~~");		xeroContact.Set("Name", "John Doe");
	xeroRecord.setContact(xeroContact);		xeroRecord.setContact(xeroContact);
	xeroRecord.Set("Type", "ACCREC");		xeroRecord.Set("Type", "ACCREC");
Line 44:		Line 44:
	<nowiki>		<nowiki>
	var xeroRecord = XeroRecord('contacts');		var xeroRecord = XeroRecord('contacts');
	xeroRecord.Set("Name", "~~TestXeroContact14~~");		xeroRecord.Set("Name", "John Doe");
	xeroRecord.Set("EmailAddress", "~~test14~~@~~test~~.com");		xeroRecord.Set("EmailAddress", "john@doej.com");
	var id = '0523f206-2c4e-455d-9f15-006d4e6054b1';		var id = '0523f206-2c4e-455d-9f15-006d4e6054b1';
	xeroRecord.Update(id);		xeroRecord.Update(id);
Line 52:		Line 52:
	<nowiki>		<nowiki>
	var xeroRecord = XeroRecord('quotes');		var xeroRecord = XeroRecord('quotes');
	xeroRecord.Set("Reference", "~~test reference 1~~");		xeroRecord.Set("Reference", "QT-88888");
	var xeroContact = XeroRecord('contacts');		var xeroContact = XeroRecord('contacts');
	xeroContact.Set("ContactID", "0523f206-2c4e-455d-9f15-006d4e6054b1");		xeroContact.Set("ContactID", "0523f206-2c4e-455d-9f15-006d4e6054b1");
	xeroContact.Set("Name", "~~TestXeroContact14~~");		xeroContact.Set("Name", "John Doe");
	xeroRecord.setContact(xeroContact);		xeroRecord.setContact(xeroContact);
	xeroRecord.Set("Date", "7/29/2025 12:00:00 AM");		xeroRecord.Set("Date", "7/29/2025 12:00:00 AM");
Line 65:		Line 65:
	var xeroContact = XeroRecord('contacts');		var xeroContact = XeroRecord('contacts');
	xeroContact.Set("ContactID", "0523f206-2c4e-455d-9f15-006d4e6054b1");		xeroContact.Set("ContactID", "0523f206-2c4e-455d-9f15-006d4e6054b1");
	xeroContact.Set("Name", "~~TestXeroContact14~~");		xeroContact.Set("Name", "John Doe");
	var xeroRecord = XeroRecord('quotes');		var xeroRecord = XeroRecord('quotes');
	xeroRecord.Set("QuoteNumber", "~~TestXeroQuote7~~");		xeroRecord.Set("QuoteNumber", "QT-8000");
	xeroRecord.setContact(xeroContact);		xeroRecord.setContact(xeroContact);
	var xeroLineItem = XeroRecord('lineitems');		var xeroLineItem = XeroRecord('lineitems');
Line 77:		Line 77:
	</nowiki>		</nowiki>
	//Update a Xero quote record (with lineitem - multiple)		//Update a Xero quote record (with lineitem - multiple)
	~~jint di~~		<nowiki>
	var xeroContact = XeroRecord('contacts');		var xeroContact = XeroRecord('contacts');
	xeroContact.Set("ContactID", "0523f206-2c4e-455d-9f15-006d4e6054b1");		xeroContact.Set("ContactID", "0523f206-2c4e-455d-9f15-006d4e6054b1");
	xeroContact.Set("Name", "~~TestXeroContact14~~");		xeroContact.Set("Name", "John Doe");
	var xeroRecord = XeroRecord('quotes');		var xeroRecord = XeroRecord('quotes');
	xeroRecord.Set("QuoteNumber", "~~TestXeroQuote9~~");		xeroRecord.Set("QuoteNumber", "QT-7777");
	xeroRecord.setContact(xeroContact);		xeroRecord.setContact(xeroContact);
	var xeroLineItem1 = XeroRecord('~~lineitems~~');		var xeroLineItem1 = XeroRecord('lineitem');
	xeroLineItem1.Set("Description", "test-description-1-1");		xeroLineItem1.Set("Description", "test-description-1-1");
	var xeroLineItem2 = XeroRecord('~~lineitems~~');		var xeroLineItem2 = XeroRecord('lineitem');
	xeroLineItem2.Set("Description", "test-description-2-2");		xeroLineItem2.Set("Description", "test-description-2-2");
	xeroRecord.LineItems.Add(xeroLineItem1);		xeroRecord.LineItems.Add(xeroLineItem1);
Line 97:		Line 97:
	<nowiki>		<nowiki>
	var xeroRecord = XeroRecord('invoices');		var xeroRecord = XeroRecord('invoices');
	xeroRecord.Set("Reference", "~~test reference 11~~");		xeroRecord.Set("Reference", "IN-5555");
	var id = '5510fd79-206a-4ea1-a2f0-db1180a2c6c0';		var id = '5510fd79-206a-4ea1-a2f0-db1180a2c6c0';
	xeroRecord.Update(id);		xeroRecord.Update(id);
Line 104:		Line 104:
	<nowiki>		<nowiki>
	var xeroRecord = XeroRecord('contacts');		var xeroRecord = XeroRecord('contacts');
	xeroRecord.Set("Name", "~~TestXeroContact5~~");		xeroRecord.Set("Name", "John Doe");
	var id = '76912505-520c-4b1d-8739-24a98493508c';		var id = '76912505-520c-4b1d-8739-24a98493508c';
	xeroRecord.Delete(id);		xeroRecord.Delete(id);
Line 112:		Line 112:
	var xeroBatch=XeroBatch();		var xeroBatch=XeroBatch();
	var xeroRecord_contact = XeroRecord('contacts');		var xeroRecord_contact = XeroRecord('contacts');
	xeroRecord_contact.Set("EmailAddress", "~~test141~~@~~test~~.com");		xeroRecord_contact.Set("EmailAddress", "js@doej.com");
	xeroRecord_contact.id = '0523f206-2c4e-455d-9f15-006d4e6054b1';		xeroRecord_contact.id = '0523f206-2c4e-455d-9f15-006d4e6054b1';
	xeroRecord_contact.mode="Update";		xeroRecord_contact.mode="Update";
	xeroBatch.add(xeroRecord_contact);		xeroBatch.add(xeroRecord_contact);
	var xeroRecord_quote = XeroRecord('quotes');		var xeroRecord_quote = XeroRecord('quotes');
	xeroRecord_quote.Set("Reference", "~~test reference 33~~");		xeroRecord_quote.Set("Reference", "QT-77773");
	var xeroContact = XeroRecord('contacts');		var xeroContact = XeroRecord('contacts');
	xeroContact.Set("ContactID", "0523f206-2c4e-455d-9f15-006d4e6054b1");		xeroContact.Set("ContactID", "0523f206-2c4e-455d-9f15-006d4e6054b1");
	xeroContact.Set("Name", "~~TestXeroContact14~~");		xeroContact.Set("Name", "John Doe");
	xeroRecord_quote.setContact(xeroContact);		xeroRecord_quote.setContact(xeroContact);
	xeroRecord_quote.Set("Date", "7/29/2025 12:00:00 AM");		xeroRecord_quote.Set("Date", "7/29/2025 12:00:00 AM");

WikiSysopdi at 10:56, 14 August 2025

2025-08-14T10:56:49Z

← Older revision		Revision as of 10:56, 14 August 2025
Line 50:		Line 50:

	//Update a Xero quote record (without lineitem) with using JINT		//Update a Xero quote record (without lineitem) with using JINT
	~~jint di~~		<nowiki>
	var xeroRecord = XeroRecord('quotes');		var xeroRecord = XeroRecord('quotes');
	xeroRecord.Set("Reference", "test reference 1");		xeroRecord.Set("Reference", "test reference 1");

WikiSysopdi at 10:56, 14 August 2025

2025-08-14T10:56:39Z

← Older revision		Revision as of 10:56, 14 August 2025
Line 7:		Line 7:
	You can update XERO now from javascript code using the JINT functionality		You can update XERO now from javascript code using the JINT functionality

	//Insert a Xero contact record ~~with using JINT~~		//Insert a Xero contact record
	~~<nowiki>~~
	var xeroRecord = XeroRecord('contacts');		var xeroRecord = XeroRecord('contacts');
	xeroRecord.Set("Name", "~~TestXeroContact14~~");		xeroRecord.Set("Name", "John Doe");
	var id = xeroRecord.Insert();		var id = xeroRecord.Insert();
	di.display(id);		di.display(id);
	~~</nowiki>~~
	//Insert a Xero quote record ~~with using JINT~~		//Insert a Xero quote record
	~~<nowiki>~~
	var xeroRecord = XeroRecord('quotes');		var xeroRecord = XeroRecord('quotes');
	xeroRecord.Set("QuoteNumber", "TestXeroQuote8");		xeroRecord.Set("QuoteNumber", "TestXeroQuote8");
	var xeroContact = XeroRecord('contacts');		var xeroContact = XeroRecord('contacts');
	xeroContact.Set("ContactID", "ab215683-f30f-49f1-afa2-54d9fa90217e");		xeroContact.Set("ContactID", "ab215683-f30f-49f1-afa2-54d9fa90217e");
	xeroContact.Set("Name", "~~TestXeroContact10-Different-Name~~");		xeroContact.Set("Name", "John Doe");
	xeroRecord.setContact(xeroContact);		xeroRecord.setContact(xeroContact);
	xeroRecord.Set("Date", "7/29/2025 12:00:00 AM");		xeroRecord.Set("Date", "7/29/2025 12:00:00 AM");
	var xeroLineItems = XeroRecord('lineitems');		var xeroLineItems = XeroRecord('lineitems');
	xeroLineItems.Set("Description", "test-description");		xeroLineItems.Set("Description", "test-description");
	xeroRecord.setLineItem(xeroLineItems);		xeroRecord.setLineItem(xeroLineItems);
	var id = xeroRecord.Insert();		var id = xeroRecord.Insert();
	di.display(id);		di.display(id);
	~~</nowiki>~~
	//Insert a Xero invoice record ~~with using JINT~~		//Insert a Xero invoice record
	<nowiki>		<nowiki>
	var xeroRecord = XeroRecord('invoices');		var xeroRecord = XeroRecord('invoices');
Line 41:		Line 41:
	di.display(id);		di.display(id);
	</nowiki>		</nowiki>
	//Update a Xero contact record ~~with using JINT~~		//Update a Xero contact record
	<nowiki>		<nowiki>
	var xeroRecord = XeroRecord('contacts');		var xeroRecord = XeroRecord('contacts');
Line 61:		Line 61:
	xeroRecord.Update(id);		xeroRecord.Update(id);
	</nowiki>		</nowiki>
	//Update a Xero quote record (with lineitem - single) ~~with using JINT~~		//Update a Xero quote record (with lineitem - single)
	<nowiki>		<nowiki>
	var xeroContact = XeroRecord('contacts');		var xeroContact = XeroRecord('contacts');
Line 76:		Line 76:
	di.display(id);		di.display(id);
	</nowiki>		</nowiki>
	//Update a Xero quote record (with lineitem - multiple) ~~with using JINT~~		//Update a Xero quote record (with lineitem - multiple)
	jint di		jint di
	var xeroContact = XeroRecord('contacts');		var xeroContact = XeroRecord('contacts');
Line 94:		Line 94:
	di.display(id);		di.display(id);
	</nowiki>		</nowiki>
	//Update a Xero invoice record ~~with using JINT~~		//Update a Xero invoice record
	<nowiki>		<nowiki>
	var xeroRecord = XeroRecord('invoices');		var xeroRecord = XeroRecord('invoices');
Line 101:		Line 101:
	xeroRecord.Update(id);		xeroRecord.Update(id);
	</nowiki>		</nowiki>
	//Archive a Xero contact record ~~with using JINT~~		//Archive a Xero contact record
	<nowiki>		<nowiki>
	var xeroRecord = XeroRecord('contacts');		var xeroRecord = XeroRecord('contacts');
Line 108:		Line 108:
	xeroRecord.Delete(id);		xeroRecord.Delete(id);
	</nowiki>		</nowiki>
	//Batch job => to update a Xero contact and Xero quote record ~~with using JINT~~		//Batch job => to update a Xero contact and Xero quote record
	<nowiki>		<nowiki>
	var xeroBatch=XeroBatch();		var xeroBatch=XeroBatch();

WikiSysopdi at 10:54, 14 August 2025

2025-08-14T10:54:41Z

Show changes

WikiSysopdi at 08:52, 14 August 2025

2025-08-14T08:52:47Z

← Older revision		Revision as of 08:52, 14 August 2025
Line 27:		Line 27:
	xeroRecord.Delete(id)		xeroRecord.Delete(id)
	</nowiki>		</nowiki>
			//Insert Invoice
			<nowiki>
			var xeroRecord = XeroRecord('invoices');
			xeroRecord.Set("InvoiceNumber", "TestXeroInvoice1");
			xeroRecord.Set("Contact_ContactID", "e5e631e9-c5c8-4a4b-a5d0-b8dcfd4a5ad9");
			xeroRecord.Set("Type", "ACCREC");
			xeroRecord.Insert();
			</nowiki>


	getGUID - This is used where you have a given key value and need the Guid ID. Only one result is returned so this depends on the named key value being unique. Otherwise use querydb.		getGUID - This is used where you have a given key value and need the Guid ID. Only one result is returned so this depends on the named key value being unique. Otherwise use querydb.