web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested answer

Importing Products using REST API's? - FinOps

(0) ShareShare
ReportReport
Posted on by

Greetings,

       I'm very new to the D365 space, but we're putting in FinOps into our company and I'm looking at ways we can integrate our products into D365.

I've been playing around with the REST API's to extract products (which I've been able to get working using Postman and the ProductsV2 entity) but am having a few issues importing products. 

Wondering if anyone has a working sample of how to import products - i.e. what entity/URL to use and what the POST body looks like?

Thanks,

Tim

I have the same question (0)
  • WillWU Profile Picture
    22,361 on at
    RE: Importing Products using REST API's? - FinOps

    Hi tyoung,

    Please have a look:

    docs.microsoft.com/.../data-management-api

    Moved to D365FO forum.

  • Martin Dráb Profile Picture
    236,320 Most Valuable Professional on at
    RE: Importing Products using REST API's? - FinOps

    Are you sure that you want to use OData rather than data management (file-based import)?

    By the way, you may be interested in the documentation page Choose a data integration strategy.

  • Mutsumi Negishi Profile Picture
    on at
    RE: Importing Products using REST API's? - FinOps

    Hello 

    The following article may be help for you and you can find the document regrading REST API + Logic Apps.

    https://community.dynamics.com/365/financeandoperations/f/dynamics-365-for-finance-and-operations-forum/368034/dmf---calling-importfrompackage-api-in-logic-app

  • Community Member Profile Picture
    on at
    RE: Importing Products using REST API's? - FinOps

    Hi Martin,

       We've looked at the DMF option and it looks like more moving parts involved, and (to me at least) the REST API looks cleaner. We won't be pushing high volumes so the 1000 request/hour limit mentioned on docs.microsoft.com/.../integration-overview should not be a limitation.

    Also we are looking to integrate with another SaaS solution and limiting the integration to REST calls would make things much cleaner.

    As I mentioned I've been using Postman to do a HTTPS GET on the cloudax.dynamics.com/data/ProductsV2 endpoint to extract products, but I can't find any examples online of a working PUT/PUSH to import the products (and I suspect I'm using the wrong entity for importing products too...)

    Thanks,

    Tim

  • Suggested answer
    Faisal Fareed Profile Picture
    10,796 User Group Leader on at
    RE: Importing Products using REST API's? - FinOps

    Hi Tim,

    Try using Released product creation V2 data entity to create a product.

    I would also suggest to use Release Product** data entities to retrieve information from the D365 FO.

  • Martin Dráb Profile Picture
    236,320 Most Valuable Professional on at
    RE: Importing Products using REST API's? - FinOps

    You said that "limiting the integration to REST calls would make things much cleaner", but both OData and the data management API are REST APIs. It sounds like you rejected data management because you're not aware of its API.

  • Community Member Profile Picture
    on at
    RE: Importing Products using REST API's? - FinOps

    I may be way off here, but my understanding of the DMF is that you need to upload files to BLOB storage and then orchestrate their loading via REST. In that case, it's the creation/upload of the file that I'm seeing as the blocker.

  • Martin Dráb Profile Picture
    236,320 Most Valuable Professional on at
    RE: Importing Products using REST API's? - FinOps

    Sure. you need to upload the file somewhere and blob storage is a natural choice. But it's still a REST API, which you asked for, so why it's suddenly a blocker?

    Also note that there is already an application that you can use: Recurring Integrations Scheduler. Either use it as it is and you instantly have an integration solution without any development. Or change its source code as you need.

  • Community Member Profile Picture
    on at
    RE: Importing Products using REST API's? - FinOps

    It would be a blocker if the calling application only supports REST calls.

    We are still exploring the capabilities of the calling system, but our initial take is that they would not (out-of-the-box) support the creation/upload of files.

  • Martin Dráb Profile Picture
    236,320 Most Valuable Professional on at
    RE: Importing Products using REST API's? - FinOps

    What does it mean that they can do REST calls but they're unable to send data to an HTTP endpoint (= uploading a file)? Isn't it a contradiction?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 2,004

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 865 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 582 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans