IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.



#Automation


#Applicationintegration
#webMethods
#Integration
 View Only
  • 1.  $filter query parameter not allowed in Custom REST Connector

    Posted 07/20/20 08:06 AM

    Hi Team ,

    As Dynamics 365 Finance & Operations connector is not available , as a workaround we are using REST connector to call the D365 F&O OData APIs directly .

    We are able to call the get and post methods .

    We are stuck where we need to filter records based on say accountName equals ‘Test’ , but as webMethods IO does not allow to define vairables with $ for example $filter which D365 F&O expects as Query parameter to be passed for any filter conditions .

    Can you please let us know any workaround/solution for this issue ?

    P.S : D365 F&O OData APIs link : Open Data Protocol (OData) - Finance & Operations | Dynamics 365 | Microsoft Learn


    #webMethods-io-Integration
    #webMethods


  • 2.  RE: $filter query parameter not allowed in Custom REST Connector

    Posted 07/21/20 01:37 AM

    Hi Rakesh,

    Have you considered using OData v4 connector, as MS Dynamics 365 F&O does provide interfacing through OData protocol.

    https://docs.webmethods.io/integration/connectors/connector-bundle/developer-c/#co-odatav4


    #webMethods
    #webMethods-io-Integration


  • 3.  RE: $filter query parameter not allowed in Custom REST Connector

    Posted 07/21/20 02:19 AM

    Hi Mike ,

    Thanks for the reply , yes I need OData Connectors only .

    Using Azure AD OAuth 2.0 version 1 token endpoint to fetch token as webMethods IO does not yet support Azure AD OAuth 2.0 version 2 token endpoint


    #webMethods
    #webMethods-io-Integration


  • 4.  RE: $filter query parameter not allowed in Custom REST Connector

    Posted 07/21/20 10:26 AM

    Unfortunately the OData 4.0 Connector does not work for Dynamics Finance & Operations . It’s not able to list the proper Business Objects while creating the Custom actions


    #webMethods
    #webMethods-io-Integration