Batching Updates - Revision history

CreatioWikiSysop at 11:28, 2 March 2026

2026-03-02T11:28:01Z

← Older revision		Revision as of 07:28, 2 March 2026
Line 1:		Line 1:
	Using JINT mode we can use scripting to batch inserts and updates (This uses the oData Batch api).		Using JINT mode we can use scripting to batch inserts and updates (This uses the oData Batch api).
	This speeds up any inserts/updates		This speeds up any inserts/updates
	----'''SAMPLE SCRIPT'''		----'''SAMPLE SCRIPT'''<blockquote>jint di

	jint di

	var '''creatiobatch'''='''CreatioBatch'''();		var '''creatiobatch'''='''CreatioBatch'''();
Line 29:		Line 27:
	'''creatiobatch'''.add('''creatioRecord_contact2''');		'''creatiobatch'''.add('''creatioRecord_contact2''');

	var '''creatiobatchResult'''='''creatiobatch'''.'''process'''();		var '''creatiobatchResult'''='''creatiobatch'''.'''process'''();</blockquote>

CreatioWikiSysop at 12:34, 5 June 2025

2025-06-05T12:34:34Z

← Older revision		Revision as of 08:34, 5 June 2025
Line 1:		Line 1:
	Using JINT mode we can use scripting to batch inserts and updates (This uses the oData Batch api).		Using JINT mode we can use scripting to batch inserts and updates (This uses the oData Batch api).
	This speeds up any inserts/updates		This speeds up any inserts/updates
			----'''SAMPLE SCRIPT'''
	EG

	jint di		jint di

	var creatiobatch=CreatioBatch();		var '''creatiobatch'''='''CreatioBatch'''();

	var creatioRecord_contact = CreatioRecord('Contact');		var '''creatioRecord_contact''' = '''CreatioRecord'''('Contact');

	creatioRecord_contact.Set("Name","Jane Doe");		'''creatioRecord_contact'''.Set("Name","Jane Doe");

	creatioRecord_contact.Set("JobTitle","Head of Design");		'''creatioRecord_contact'''.Set("JobTitle","Head of Design");

	creatioRecord_contact.mode="Insert";		'''creatioRecord_contact'''.mode="'''Insert'''";

	creatiobatch.add(creatioRecord_contact);		'''creatiobatch'''.add('''creatioRecord_contact''');

	var creatioRecord_contact2 = CreatioRecord('Contact');		var '''creatioRecord_contact2''' = '''CreatioRecord'''('Contact');

	var id2 = di.getguid('contact','Frank Jones');		var id2 = di.'''getguid'''('contact','Frank Jones');

	creatioRecord_contact2.Set("Email","frank@jonesinc.com");		'''creatioRecord_contact2'''.Set("Email","frank@jonesinc.com");

	creatioRecord_contact2.id = id2;		'''creatioRecord_contact2'''.id = id2;

	creatioRecord_contact2.mode="Update";		'''creatioRecord_contact2'''.mode="Update";

	creatiobatch.add(creatioRecord_contact2);		'''creatiobatch'''.add('''creatioRecord_contact2''');

	var creatiobatchResult=creatiobatch.process();		var '''creatiobatchResult'''='''creatiobatch'''.'''process'''();

CreatioWikiSysop at 12:26, 5 June 2025

2025-06-05T12:26:13Z

← Older revision		Revision as of 08:26, 5 June 2025
Line 1:		Line 1:
	Using JINT mode we can use scripting to batch inserts and updates (This uses the oData Batch api)		Using JINT mode we can use scripting to batch inserts and updates (This uses the oData Batch api).
			This speeds up any inserts/updates

	EG		EG

CreatioWikiSysop at 12:25, 5 June 2025

2025-06-05T12:25:53Z

← Older revision		Revision as of 08:25, 5 June 2025
Line 1:		Line 1:
	Using JINT mode we can use scripting to batch inserts and updates (This uses the oData Batch api)		Using JINT mode we can use scripting to batch inserts and updates (This uses the oData Batch api)

			EG

			jint di

			var creatiobatch=CreatioBatch();

			var creatioRecord_contact = CreatioRecord('Contact');

			creatioRecord_contact.Set("Name","Jane Doe");

			creatioRecord_contact.Set("JobTitle","Head of Design");

			creatioRecord_contact.mode="Insert";

			creatiobatch.add(creatioRecord_contact);

			var creatioRecord_contact2 = CreatioRecord('Contact');

			var id2 = di.getguid('contact','Frank Jones');

			creatioRecord_contact2.Set("Email","frank@jonesinc.com");

			creatioRecord_contact2.id = id2;

			creatioRecord_contact2.mode="Update";

			creatiobatch.add(creatioRecord_contact2);

			var creatiobatchResult=creatiobatch.process();

CreatioWikiSysop at 12:25, 5 June 2025

2025-06-05T12:25:07Z

← Older revision		Revision as of 08:25, 5 June 2025
Line 1:		Line 1:
	Using JINT mode we can use scripting to batch inserts and updates (This uses the oData Batch api)		Using JINT mode we can use scripting to batch inserts and updates (This uses the oData Batch api)

	~~jint di~~
	~~var creatiobatch=CreatioBatch();~~
	~~var creatioRecord_contact = CreatioRecord('Contact');~~
	~~creatioRecord_contact.Set("Name","Jane Doe");~~
	~~creatioRecord_contact.Set("JobTitle","Head of Design");~~
	~~creatioRecord_contact.mode="Insert";~~
	~~creatiobatch.add(creatioRecord_contact);~~
	~~var creatioRecord_contact2 = CreatioRecord('Contact');~~
	~~var id2 = di.getguid('contact','Frank Jones');~~
	~~creatioRecord_contact2.Set("Email","frank@jonesinc.com");~~
	~~creatioRecord_contact2.id = id2;~~
	~~creatioRecord_contact2.mode="Update";~~
	~~creatiobatch.add(creatioRecord_contact2);~~
	~~var creatiobatchResult=creatiobatch.process();~~

CreatioWikiSysop: Created page with "Using JINT mode we can use scripting to batch inserts and updates (This uses the oData Batch api) jint di var creatiobatch=CreatioBatch(); var creatioRecord_contact = CreatioRecord('Contact'); creatioRecord_contact.Set("Name","Jane Doe"); creatioRecord_contact.Set("JobTitle","Head of Design"); creatioRecord_contact.mode="Insert"; creatiobatch.add(creatioRecord_contact); var creatioRecord_contact2 = CreatioRecord('Contact'); var id2 = di.getguid('contact','Frank Jones');..."

2025-06-05T12:24:58Z

Created page with "Using JINT mode we can use scripting to batch inserts and updates (This uses the oData Batch api) jint di var creatiobatch=CreatioBatch(); var creatioRecord_contact = CreatioRecord('Contact'); creatioRecord_contact.Set("Name","Jane Doe"); creatioRecord_contact.Set("JobTitle","Head of Design"); creatioRecord_contact.mode="Insert"; creatiobatch.add(creatioRecord_contact); var creatioRecord_contact2 = CreatioRecord('Contact'); var id2 = di.getguid('contact','Frank Jones');..."

New page

Using JINT mode we can use scripting to batch inserts and updates (This uses the oData Batch api)

jint di
var creatiobatch=CreatioBatch();
var creatioRecord_contact = CreatioRecord('Contact');
creatioRecord_contact.Set("Name","Jane Doe");
creatioRecord_contact.Set("JobTitle","Head of Design");
creatioRecord_contact.mode="Insert";
creatiobatch.add(creatioRecord_contact);
var creatioRecord_contact2 = CreatioRecord('Contact');
var id2 = di.getguid('contact','Frank Jones');
creatioRecord_contact2.Set("Email","frank@jonesinc.com");
creatioRecord_contact2.id = id2;
creatioRecord_contact2.mode="Update";
creatiobatch.add(creatioRecord_contact2);
var creatiobatchResult=creatiobatch.process();