Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Unanswered

GP Integration using Odata

(1) ShareShare
ReportReport
Posted on by Microsoft Employee

Hi All,

We have installed odata service v4 on GP and trying to use an integration platform Boomi to connect to the service. However we are able to retrieve data from the tables but not able to add any record even though the job finishes successfully. Where can we enable logs to see what is failing during insert/update?

Thanks in advance

Categories:
  • Lucas Miller Profile Picture
    Lucas Miller on at
    RE: GP Integration using Odata

    Hello,

    The Dynamics GP OData service is considered read-only since it can only be used to push data to external applications (e.g. Excel or PowerBI).  It cannot be used to INSERT/UPDATE/DELETE records in the Dynamics GP databases.

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

News and Announcements

Announcing Category Subscriptions!

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,359 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans