Batching Updates: Difference between revisions

From Apps for Creatio
No edit summary
No edit summary
 
(One intermediate revision by the same user not shown)
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'''<blockquote>jint di


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


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


var creatiobatch=CreatioBatch();
'''creatioRecord_contact'''.Set("Name","Jane Doe");


var creatioRecord_contact = CreatioRecord('Contact');
'''creatioRecord_contact'''.Set("JobTitle","Head of Design");


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


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


creatioRecord_contact.mode="Insert";
var '''creatioRecord_contact2''' = '''CreatioRecord'''('Contact');


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


var creatioRecord_contact2 = CreatioRecord('Contact');
'''creatioRecord_contact2'''.Set("Email","frank@jonesinc.com");


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


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


creatioRecord_contact2.id = id2;
'''creatiobatch'''.add('''creatioRecord_contact2''');


creatioRecord_contact2.mode="Update";
var '''creatiobatchResult'''='''creatiobatch'''.'''process'''();</blockquote>
 
creatiobatch.add(creatioRecord_contact2);
 
var creatiobatchResult=creatiobatch.process();

Latest revision as of 07:28, 2 March 2026

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


SAMPLE SCRIPT

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();