Mongoose Scripting Guide

Legacy Contributor

Hi,

 

Is there any real time Mongoose Scripting guide / document available apart from the Mongoose development guide from the portal especially when we are interacting with other ERPs like M3 through REST API call other than contacting the SQL DB directly.

We are trying to pass a record values in the grid to M3 through one of the M3 API create transaction call. 

 

CollectionName= ThisForm.GetSecondaryIDOCollection(SecondaryCollectionNumber)


'CreateMOCol.New()
CollectionName.SetCurrentObjectProperty("IDOPROPERTYFIELD1","VALUE1")
CollectionName.SetCurrentObjectProperty("IDOPROPERTYFIELD2","VALUE2")

.....

.......

CollectionName.SetCurrentObjectProperty("IDOPROPERTYFIELDN","VALUEN")



''res = CollectionName.New()

''res = CollectionName.Save()

 

We tried all Specifying CollectionName.New() in the beginning, at the end, without specifying it, only using CollectionName.Save() at the end and CollectionName.SaveCurrent(). But all returning false. The IDO is derived from M3 MI transaction. As usual only Default list method is being mentioned in the IDO definition, Insert, Save methods unavailable in IDO definition eventhough when we have mentioned it from M3 Interface Test form, IDO creation wizard.

If any of our Mongoose developer encountered this scenario, please share the your ideas.

 

Thanks in advance for the response.

 

Regards,

Giri

Legacy Contributor

SetCurrentObjectProperty() with Collection.Save() isn’t enough to update the IDO. SetCurrentObjectProperty() does not indicate that the property is modified so it does not get sent.



Use SetCurrentObjectPropertyPlusModifyRefresh() in place of SetCurrentObjectProperty() and you should be good.



if you are developing locally (I.e. not on a shared server) I recommend watching the Mongoose 101 (coding) series on youtube.



Here's the channel it is on



www.youtube.com/.../UCWDPh6QvyvpOUST0TzvkPkw