Avatar

Please consider registering
guest

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
Avatar
Dow Jones
New Member
Members
Forum Posts: 1
Member Since:
February 1, 2019
sp_UserOfflineSmall Offline

Hello,

is it possible to call via VBA in Maximo 7.6.0.8?

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:
   ~asset=this&~newLocation=Some_where&~newSite=some_site&~newParent=Some_one

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: 13553

Moderators: 0

Admins: 3

Forum Stats:

Groups: 1

Forums: 8

Topics: 1527

Posts: 4194

Newest Members:

Inez Wessel, Rob Kelpe, govindarao kottakotla, Tịnh Phan, Rica Paeste, Monroe Sawyer

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