- Exclusive Look: Maximo REST web service API
- Query data with the Maximo REST API
- Creating a work order with Maximo’s REST API framework
- Create a work order and add labor hours with Maximo REST
- Retrieving and Posting data to Maximo REST Web Services
- Add Work Log to SR through Maximo REST API
- Initiate Workflow through Maximo REST API
You can already create a new work order with REST but it’s useless if you can’t add labor hours to it right? This tutorial will show you how to setup the MXWO object structure to be able to add LABTRANS records at the same time you create a work order. You can now create a work order with a location and description and add the same time add labor hours to it.
The process is pretty much the same as you did for creating a work order with REST but we have to change the MXWO object structure to work with the LABTRANS object. You can always create your own object but we can just modify the existing one for now.
First to go Object Structures and open the MXWO record. You will see there is only one WORKORDER object listed. We need to add the LABTRANS object like so:
Once you have added that, we need to change the inbound restrictions on this object. Click on Select Action -> Inbound Setting Restrictions. You will the STATUS field is restricted to change it, click on the ‘Override’ and then click on ‘Restricted’ checkboxes. Next, hit OK and generate schema by click on Select Action -> Generate Schema/View XML.
Now we are ready to POST data to this object. It’s the same form we used in the last tutorial but we added a few fields.
<html>
<body>
<form name="input" action="http://maximoserver/maxrest/rest/os/MXWO?_lid=maxadmin&_lpwd=maxadmin" method="POST">
LOCATION <input name="LOCATION" value="SHIPPING" type="text"> <p/>
DESCRIPTION <input name="DESCRIPTION" value="Test Rest" type="text"> <p/>
STATUS <input name="STATUS" value="APPR" type="text"><p/>
SITEID <input name="SITEID" value="BEDFORD" type="text"> <p/>
ORGID <input name="ORGID" value="EAGLENA" type="text"> <p/>
LABORCODE <input name="LABTRANS.ID1.LABORCODE" value="SILIKI" type="text"><p/>
CRAFT <input name="LABTRANS.ID1.CRAFT" value="MECH" type="text"><p/>
REGULARHRS <input name="LABTRANS.ID1.REGULARHRS" value="2.0" type="text"><p/>
<input type="submit" value="Submit">
</form>
</body>
You can see in this form, we added the STATUS field because you can’t add labor hours to a work order that is WAPPR and that is the default status when creating a new one so we have to change it. Then I added LABORCODE, CRAFT and REGULARHRS fields that are associated with the LABTRANS child object. These are the minimum fields that are required for the LABTRANS to be added. You can see something that might look odd and that is the “ID1” in the name attribute. This is needed to identify which fields are associated with that record. For example, you are adding one LABTRANS record, but you are using the LABORCODE, CRAFT and REGULARHRS fields on that one record. This is useful because you can add as many LABTRANS records as you want.
Here is an example where you can add two LABTRANS records in the same form:
<html>
<body>
<form name="input" action="http://maximoserver/maxrest/rest/os/MXWO?_lid=maxadmin&_lpwd=maxadmin" method="POST">
LOCATION <input name="LOCATION" value="SHIPPING" type="text"> <p/>
DESCRIPTION <input name="DESCRIPTION" value="Test Rest" type="text"> <p/>
STATUS <input name="STATUS" value="APPR" type="text"><p/>
SITEID <input name="SITEID" value="BEDFORD" type="text"> <p/>
ORGID <input name="ORGID" value="EAGLENA" type="text"> <p/>
LABORCODE <input name="LABTRANS.ID1.LABORCODE" value="SILIKI" type="text"><p/>
CRAFT <input name="LABTRANS.ID1.CRAFT" value="MECH" type="text"><p/>
REGULARHRS <input name="LABTRANS.ID1.REGULARHRS" value="2.0" type="text"><p/>
LABORCODE <input name="LABTRANS.ID2.LABORCODE" value="SILIKI" type="text"><p/>
CRAFT <input name="LABTRANS.ID2.CRAFT" value="MECH" type="text"><p/>
REGULARHRS <input name="LABTRANS.ID2.REGULARHRS" value="2.0" type="text"><p/>
<input type="submit" value="Submit">
</form>
</body>
Notice that the second record is marked with “ID2”. This will create a new work order, change the status to APPR and then add two labor records to the work order.
Thanks Chon. This works on my local
I was trying this on an instance of Maximo using an App Server security.
When I use the below link:
https://lmaximoserver/maxrest/rest/mbo/workorder?_lid=maxadmin&_lpwd=maxadmin&wonum=1263
It gives me a Security Config error in the Browser and the Logs throw up an error
/UNAUTHENTICATED is not assigned a role of maximouser
Is there any way of getting around this ?
Do you have an example where we can pass one labtrans record that does not use a form? Just the whole url with the data? I am interested in using this to stuff labtrans records from our time entry program.
That’s not really possible because the HTTP request has to be a POST and in a plain URL it is an HTTP GET.
We are posting data from SharePoint (InfoPath Form) into Maximo. The data is being truncated to 255 characters. Can you give me pointers on where to look?
hello chon ,
when i add labtrans hours to specific workorder , I get an error on double separator some maximo instances only accept point separator(.) other only accept comma separator(,) .
Is there any solution for that ? thank you
This is probably happening because of the users locale setting. You have to send the correct separator based on the locale of the user.