Integration

Get Involved. Join the Conversation.

Topic

    Stephen Bryant
    Call VBCS BO Rest Endpoint in ICS MapperAnswered
    Topic posted September 19, 2019 by Stephen BryantBronze Trophy: 5,000+ Points, tagged Adapters, Connection, ERP Cloud, Integration, Mapping, Orchestration 
    24 Views, 2 Comments
    Title:
    Call VBCS BO Rest Endpoint in ICS Mapper
    Summary:
    Patch Operation on VBCS Business Object using field other than ID
    Content:

    Hello,

    I am retrieving from ERP Cloud using an OTBI report using ICS and loading a VBCS Business Object without any problem at all.

    I would like to patch records in the VBCS business objects based on a field in the OTBI report.  This field is not the id field in the VBCS business object.

    In order to get the id field in the business object, I created a business object function in VBCS that accepts the field in the OTBI report as a parameter and returns the id from the business object.

    I can call the VBCS business object function from ICS.   However, I would like to pass the OTBI report field to the function and use the resulting Id in the patch operation.

    I am thinking that I can target the ID in the mapper with the result of the function and then update the row in the business object.  Is this possible in the mapper using the mapping components?

    Thanks for your help.

    Steve

     

     

     

     

    Version:
    19.1.3

    Best Comment

    Jorge Herreria

    Hi Steve

    The XSLT Map editor (and the XPath Expression Editor used by other Actions)  will load the functions registered/defined in Libraries

    Load your function in the Library, then open your Orchestration and edit the Map (it will open the Mapper editor).

    In the Map editor, open the Functions Mapping Components  and use the Search functionality (or click the trees to find it)  to find your function... from there is drag and drop.

    Here's documentation on registering your functions in Library. 

    https://docs.oracle.com/en/cloud/paas/integration-cloud-service/icsug/using-libraries-manage-functions-integrations.html#GUID-F0216FB7-1F07-4236-92D5-CC0376195966

    A recommendation: Make sure your function is bulletproof: It can handle undefined,  null or empty parameters; exceptions are catch and handled completely; the function does not throw exceptions. etc, etc, etc... All that bulletproof will save you headaches when the parameter data comes as not expected. 

    Comment

     

    • Jorge Herreria

      Hi Steve

      The XSLT Map editor (and the XPath Expression Editor used by other Actions)  will load the functions registered/defined in Libraries

      Load your function in the Library, then open your Orchestration and edit the Map (it will open the Mapper editor).

      In the Map editor, open the Functions Mapping Components  and use the Search functionality (or click the trees to find it)  to find your function... from there is drag and drop.

      Here's documentation on registering your functions in Library. 

      https://docs.oracle.com/en/cloud/paas/integration-cloud-service/icsug/using-libraries-manage-functions-integrations.html#GUID-F0216FB7-1F07-4236-92D5-CC0376195966

      A recommendation: Make sure your function is bulletproof: It can handle undefined,  null or empty parameters; exceptions are catch and handled completely; the function does not throw exceptions. etc, etc, etc... All that bulletproof will save you headaches when the parameter data comes as not expected. 

      • Stephen Bryant

        Thank you Jorge.  Yes, I had come across libraries last night and then received your response.  This is definitely the way to go so thanks so much.

         

        Steve