MxLoader

 View Only
  • 1.  Problems with retrieving the child objects with the REST API

    Posted 07-08-2022 16:00

    Hello all,

    Trying to query child objects using REST in MXLoader. The parent object is JOBPLAN and the Child object is DOCLINKS. My query in MXLoader is JPNUM="J1013". This returns the parent object, but none of the child object attributes which are detailed in below screenshot. The highlighted column shows the Parent object, with the relationship name and operator. We also tried RELATIONSHIP NAME and OPERATOR and no result DOCLINKS{ADDINFO}

    If we use OS and Native authentication the results are returned for the child object.

     

     

     



    ------------------------------
    Colin Aitchison
    Regional Municipality of York
    ------------------------------


  • 2.  RE: Problems with retrieving the child objects with the REST API

    Posted 07-11-2022 09:07
    Hey Colin,

    Try removing "JOBPLAN." from JOBPLAN.DOCLINKS.DOCINFO. From my understanding of MxLoader, the relationship includes cell B1 which is the parent object.

    Thanks,
    Matt

    ------------------------------
    Matt McGuire
    Aquitas Solutions
    https://www.aquitas-solutions.com/
    ------------------------------



  • 3.  RE: Problems with retrieving the child objects with the REST API

    Posted 07-12-2022 15:24

    Hi Matt, thanks for your quick response. I've been working with Colin on this as well and we did try both options. We included the parent object and we also tried by not having the parent object. 

    JOBPLAN.DOCLINKS.ADDINFO AND DOCLINKS.ADDINFO

    Teresa



    ------------------------------
    Teresa Colangelo
    Region of York
    ------------------------------



  • 4.  RE: Problems with retrieving the child objects with the REST API
    Best Answer

    Posted 07-13-2022 19:02
    Hi Colin,

    It does work.  I've replicated using the REST API, see my screenshots.  Whenever dealing with child objects do not include the parent object.  The format is <relationship name>.<attributename>. 

    Could the be something wrong with the relationship query.  If in doubt run the query like in the case:

    Select * from doclinks where <relationship query>;





    ------------------------------
    Regards,
    Craig Kokay
    ISW
    Maximo Practice Manager
    eMail: ckokay@isw.net.au
    Phone: +61-411-682-040

    #IBMChampion2022
    ------------------------------