Please consider registering

sp_LogInOut Log In sp_Registration Sign up

Sign up | Lost password?
Advanced Search

— Forum Scope —

— Match —

— Forum Options —

Minimum search word length is 3 characters - maximum search word length is 84 characters

sp_Feed Topic RSS sp_Related Related Topics sp_TopicIcon
Call 'createPOsFromPR' service method via VBA/Excel
Call 'createPOsFromPR' service method via VBA/Excel
February 1, 2019
3:39 am
Dow Jones
New Member
Forum Posts: 1
Member Since:
February 1, 2019
sp_UserOfflineSmall Offline


is it possible to call via VBA in Maximo

My code is:

    Dim PostData() As Byte
    Dim IE As InternetExplorerMedium
    Set IE = New InternetExplorerMedium

    PostData = "~date=23-08-2018"
    PostData = StrConv(PostData, vbFromUnicode)

    myheader = myheader & "x-http-method-override: createPOsFromPR" & vbNewLine
    myheader = myheader  & "Content-Type: application/json" & vbCrLf

    IE.Navigate "https://host:port/maxrest/rest/mbo/pr/123", 0, "myIE", PostData, myheader

The curret result is "Error 500: "

I guess I have a conseptual error but is it possible to call methods like createPOsFromPR via VBA?

Unfortunately I cannot instal web service reference capability for office/vba.

Un example I found on IBM website is:

   POST maxrest/rest/mbo/asset/1234 HTTP/1.1
   x-method-override: "moveAssetLocation"Copy

   The form data request is the following:

Where can I read all available method's names and parameters?

Can I do this with VBA? Do I need other code.. annotations, references?

Thansk a lot : )

Forum Timezone: America/New_York

Most Users Ever Online: 54

Currently Online:
1 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

sun kim: 60

madd0g17: 59

v.barsamov: 51

Maximofresher: 44

cgregory: 42

matta0990: 33

Member Stats:

Guest Posters: 0

Members: 13636

Moderators: 0

Admins: 3

Forum Stats:

Groups: 1

Forums: 8

Topics: 1533

Posts: 4202

Newest Members:

sushant naik, Richard Del Rosario, RNLPRSH, Masako N, Julio Hernandez, Salvatore Morisset

Administrators: Chon: 1090, kristensibilia: 0, Joe Grassia: 0