I want to update part bom quantity based on the data in Excel
I registered the IOM.tdl in the VBA tool and wrote the following VBA code (based on the manual):
Dim f As New IomFactory 'must use the New keyword
Dim innov As Innovator
'Establish User Credentials
URL = "">localhost/.../InnovatorServer.aspx"
db = "API12"
user = "admin"
pw = "innovator"
Dim conn As HttpServerConnection
Set conn = f.CreateHttpServerConnection(URL, db,
user, pw) ' create a connection
Dim result As Item
Set result = conn.Login
If result.IsError Then
MsgBox result.getErrorString
Exit Sub
End If
However, I am encountering an error stating that CreateHttpServerConnection is not registered.
Does anyone have any suggestions on how to fix it?
* P.S. I also tried OData to try to get the part bom data, but the http result is 'no data found'
