What tables are you talking about?  Most tables have these two fields.  You can read these fields to know if updated.

105  DateUpdated . . . . . . . . .     8 SNN  Last Update Date. . . . . . . .DATE
                                                Read Only:Y Notes: YYYYMMDD
 106  TimeUpdated . . . . . . . . .     8 SNN  Last Update Time. . . . . . . .TIME
                                                Read Only:Y

That's what I do today, but I have to keep reading these fields every minute. Or change the service to read every X seconds, which might be heavy on the database, no?

You would need to keep a Sage 100 session open (using a license) so that you could use User Defined Scripts and business object events to trigger your service when they trigger on table and/or field writes.

I'll look into that, thanks!

I created a new user-defined script that triggers on Post-Write to the CI_Item table.

The goal of this script is to send an HTTP request to an API to notify it that the item has been updated/added.

This is the script:

itemCode = ""
retVal = oBusObj.GetValue("ItemCode$", itemCode)
url = https://someUrl/ & itemCode & ""

Set o = CreateObject("MSXML2.XMLHTTP")
o.open "GET", url , False
o.send

response = o.responseText

When I open item maintenance and edit the description for an item (000001, for instance), my API receives the request successfully. Without closing the item maintenance window, no API call is made if I edit the same item again. Still, the script works fine without closing the window if I try editing another item.

Now, if I close the window and open it again, and I edit the item 000001, the script triggers the API call.

It seems like the script is re-loaded for the item when I re-open the window. However, if I keep the window open, the script is not triggered again.

Any thought?

You will get one Table Post-Write per "Accept"-ance. I suggest you learn how to use trace and oScript.DebugPrint to monitor your script executions.

You will get one Table Post-Write per "Accept"-ance. I suggest you learn how to use trace and oScript.DebugPrint to monitor your script executions.

Thanks.

Where can this information/tutorial/documentation be found?

Here

Thanks!

And here...

Thanks for the resources. I've went through the word document, which is very useful. However, it doesn't discuss the "one Table Post-Write per "Accept"-ance".

Is there any way to solve this programmatically, without closing then re-opening the window?

The window does not need to be closed to trigger subsequent events. These table based event scripts are triggered by table activity and not the user interface. Changes in the panel are written when you click the Accept button. That doesn't close the window. Another order or the same order can be re-selected, changed, and another event will be triggered when the Accept button is used again. If this didn't solve you issue, then I'm not understanding exactly what you are trying to accomplish.

The problem could be your object, not Sage.  Try something other than that function (DebugPrint, MessageBox...) to verify when the Post-Write script is running.

If you are on Advanced / Premium, try running in MAS90 mode to verify if your script is throwing an invisible error (or is otherwise being locked up).

In fact, the issue is somewhere in my objects. But I can't figure out where. See the following trace window:

I updated the same item 3 times in a row without closing the window. I can see that the script has been triggered 3 times. However, the API call is never re-made because my API response is a GUID that should change every time, which is not happening. In addition, my API only logs the reception of requests the first time. It's like my API is never called if the URL is the same (because it gets triggered if I change the item or if I close and then re-open the window).

Here is my updated script:

retVal = oScript.DebugPrint("Script Triggered")

url = ""
itemCode = ""
response = ""

retVal = oBusObj.GetValue("ItemCode$", itemCode)
url = "https://localhost:7017/Synchronization/ping/" & itemCode & ""

retVal = oScript.DebugPrint("URL: " & url)

Set o = CreateObject("MSXML2.XMLHTTP")

o.open "GET", url , False
o.send
response = o.responseText
oScript.DebugPrint("Response: " & response)

Set o = nothing
Set itemCode = nothing
Set url = nothing
Set response = nothing

Moreover, if, instead of sending the item code (which never changes) in the URL, I send the description (which I am updating for the sake of testing), the API call is made successfully because the URL has changed.

Is there a sort of a cache that is used?

I suspect you may be getting an error from your open or send and the "MSXML2.XMLHTTP" object is not updating "responseText".

I doubt it because if I log the response before and after the call, before the call the response text is empty, and after it is not. If I log errors, I don't see anything relevant about the HTTP request. I'll keep trying though.