Maximo Open Forum

Hi Jose,

Maybe it's a silly question, but why are you trying to get the attachment with an automation script if you need to send it to an external system?

Why not create an Object Structure with the main table Asset and the Doclinks tables, an External System, and a Publish Channel? Using OOTB MIF, you can send the attachment using the non-persistent field DOCUMENTDATA from the DOCLINKS object in your OS.

If you need to send it as JSON, you can use the JSON Mapping Application to convert it to a JSON structure that your external system will understand.

It can only be configurations, and you won't need any Automation Script. If you really need to use a script, I think you can still use the same DOCUMENTDATA field to get the base64 encoded attachment from the MBO without calling Maximo's API by using mbo.getString("DOCUMENTDATA") if your main MBO is the DOCLINKS table or getting the MBOSet from ASSET to DOCKLINKS.

The reason for using the autoscript is there is an existing script that creates and sends the json message, and now they want linked docs attached to the message.  So I'm trying to develope the "get linked docs" in a seperate script, which I will integrate into, or call from, the original script.

I'm not sure what you mean by " I think you can still use the same DOCUMENTDATA field to get the base64 encoded attachment from the MBO without calling Maximo's API by using mbo.getString("DOCUMENTDATA") ".  So just to try something I made a script with "mboset = MXServer.getMXServer().getMboSet("MXAPIDOCLINKS", MXServer.getMXServer().getSystemUserInfo())", but it errors out as suspected, with ""oslc:message": "BMXAA4216E - Unknown Object named MXAPIDOCLINKS has been encountered.".

Can you explain further, I did not realize it's possible to call an Object Structure as an mbo.

Hi Jose,

If your script is for object WORKORDER, your MBO is the open work order. So getting the DOCLINKS relationship, you'll get all attachments, and for each of them, you can get the DOCUMENTDATA field.

For instance:

doclinksMboSet = mbo.getMboSet("DOCLINKS")

if not doclinksMboSet.isEmpty():
     doclinkMbo = doclinksMboSet.moveFirst()
     if doclinkMbo is not None:
         doclinkData = doclinkMbo.getString("DOCUMENTDATA")
         service.log_error("DOCUMENTDATA: %s" % doclinkData) 
         // create the JSON to send the DOCUMENTDATA

If you can confirm that you have the base64 encoded value from this DOCUMENTDATA field, you can use it to send the JSON with the doclink file.

Unfortunately it appears the documentdata attribute is not populated.  The call getString("DOCUMENTDATA") did not throw an error, so it recognizes the attribute.

            doclinksMboSet = mbo.getMboSet("DOCLINKS")
            if not doclinksMboSet.isEmpty():
                doclinkMbo = doclinksMboSet.moveFirst()
                if doclinkMbo is not None:
                    doclinkData = doclinkMbo.getString("DOCUMENTDATA")
                    log("DOCUMENTDATA = " + doclinkData)                    
                    log("DOCUMENT = " +  doclinkMbo.getString("DOCUMENT"))
                    log("WebUrl = " +  doclinkMbo.getString("WebUrl"))

Which logged the following.  But maybe I can do something with the WebUrl.

22 Nov 2023 18:55:01:703 [INFO] *** GETLINKEDDOCS start
22 Nov 2023 18:55:01:710 [INFO] DOCUMENTDATA = 
22 Nov 2023 18:55:01:711 [INFO] DOCUMENT = PMCRONTASK
22 Nov 2023 18:55:01:711 [INFO] WebUrl = https://max761.edu/ATTACHMENTS/pmcrontask.jpg
22 Nov 2023 18:55:01:711 [INFO] *** GETLINKEDDOCS end