D365 Finance & Operations and Dynamics AX Forum

Expand all | Collapse all

OData Support

  • 1.  OData Support

    TOP CONTRIBUTOR
    Posted 30 days ago
    So I was just seeking help with nailing down the syntax for an OData call used to interact with finance and operations Entities.
    The case Engineer from microsoft kindly told me that they do not own or offer support for OData.
    Is this everyone's understanding? It seems to me that OData is presented as best practice for implementing Integrations with Finance and Operations? And the syntax they support seems crucial to providing proper support to people who are implementing it...

    My question - in case anyone in this forum can assist:
    My customer has a website that wants to transmit sales orders to F&O, using the entities. I've assisted them in identifying the entities they need to use to lookup a customer, lookup/create a contact, post a header, post lines, post a payment header, and post payment lines.
    I'm currently trying to reduce the chattiness of this interaction by identifying how to submit a batch request with most of this data in one transmission.
    To that end, I've identified syntax in the OData spec referred to as a changeset, which allows for you to build upon previous entries in your batch transmission. Has anyone gotten this type of call to work in Postman?


    ------------------------------
    Tony Zeigler
    Senior Consultant
    Strategic Solutions NW, LLC
    Beaverton OR
    ------------------------------
    Conference-AXUG_200x200


  • 2.  RE: OData Support

    TOP CONTRIBUTOR
    Posted 29 days ago
    Edited by Alex Meyer 29 days ago
    Tony,

    Would something like the DIXF feature work in your case? It's built for importing/exporting large amounts of data.

    https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/data-entities/data-entities-data-packages

    https://docs.microsoft.com/en-us/dynamicsax-2012/appuser-itpro/migrating-data-using-the-data-import-export-framework-dixf-dmf

    https://gfeaxblog.wordpress.com/2017/10/09/o365-how-to-exportimport-data-through-data-management-framework-dimf/

    https://sandeepchaudhury.wordpress.com/tag/dixf/

    ------------------------------
    Alex Meyer
    Director of Dynamics AX/365 for Finance & Operations Development
    Fastpath
    Des Moines, IA
    ------------------------------

    Conference-AXUG_200x200


  • 3.  RE: OData Support

    TOP CONTRIBUTOR
    Posted 29 days ago
    ​OData is part of the DIXF framework in D365. Basically, it allows external systems to interact with the entities via HTTP.
    Documentation can be found here: https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/data-entities/odata

    One of the differences is that OData will return a response that tells the remote system if the transfer was successful. This allows the architecture to keep the data in the remote system, throw an error that someone can respond to by fixing the data in the remote system, and then allowing the now good data to transfer to D365 cleanly.

    The amount of data is really not huge - a couple thousand orders a day - but the difference is significant if each line has to represent a new transmission. The batch syntax by itself solves the line issue - but not the other pieces - such as the header, charges, etc. These are important to include in a single message so the architecture doesn't have to track partial saves.

    ------------------------------
    Tony Zeigler
    Senior Consultant
    Strategic Solutions NW, LLC
    Beaverton OR
    ------------------------------

    Conference-AXUG_200x200


If you've found this thread useful, dive deeper into User Group community content by role