Batching Updates: Difference between revisions
From Apps for Creatio
No edit summary |
No edit summary |
||
(2 intermediate revisions 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 | |||
----'''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'''(); |
Latest revision as of 08:34, 5 June 2025
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();