Batching Updates: Difference between revisions
From Apps for Creatio
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');..." |
No edit summary |
||
| (4 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'''<blockquote>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("JobTitle","Head of Design"); | '''creatioRecord_contact'''.Set("Name","Jane Doe"); | ||
creatioRecord_contact.mode="Insert"; | |||
creatiobatch.add(creatioRecord_contact); | '''creatioRecord_contact'''.Set("JobTitle","Head of Design"); | ||
var creatioRecord_contact2 = CreatioRecord('Contact'); | |||
var id2 = di.getguid('contact','Frank Jones'); | '''creatioRecord_contact'''.mode="'''Insert'''"; | ||
creatioRecord_contact2.Set("Email","frank@jonesinc.com"); | |||
creatioRecord_contact2.id = id2; | '''creatiobatch'''.add('''creatioRecord_contact'''); | ||
creatioRecord_contact2.mode="Update"; | |||
creatiobatch.add(creatioRecord_contact2); | var '''creatioRecord_contact2''' = '''CreatioRecord'''('Contact'); | ||
var creatiobatchResult=creatiobatch.process(); | |||
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'''();</blockquote> | |||
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();