Skip to main content

Notifications

Community site session details

Community site session details

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

Does Microsoft GP have ability to return data via ODATA?

(0) ShareShare
ReportReport
Posted on by 63

Hello Team,

Could you clarify, does Microsoft GP allows returning data via ODATA?
If yes, could you provide a link to the specification?


Categories:
  • Suggested answer
    Beat Bucher  GP Geek  GPUG All Star Profile Picture
    28,058 Moderator on at
    RE: Does Microsoft GP have ability to return data via ODATA?

    Most of the issues I ran into when using OData or GP Web Services / Web Client are related to improper setup of SSL certs..

    Sometimes instead of trying to fix a failed setup, you better scrap everything and start from scratch, including deleting the related Web Services DB that was created.

  • Andrew1986 Profile Picture
    63 on at
    RE: Does Microsoft GP have ability to return data via ODATA?

    URL - 44.194.124.31:443/.../MC020104

  • Andrew1986 Profile Picture
    63 on at
    RE: Does Microsoft GP have ability to return data via ODATA?

    Video unavailable

    This video is private.

    To add ODATA in GP I used this instruction - www.dynamicconsulting.com/.../

    I made everything according to the instruction, but when I try to use generated URL, I receive the following message:

    GET 44.194.124.31:443/.../MC020104

    Error: connect ETIMEDOUT 44.194.124.31:443

    What is the reason?

  • Suggested answer
    David Musgrave MVP GPUG All Star Legend Moderator Profile Picture
    14,012 Most Valuable Professional on at
    RE: Does Microsoft GP have ability to return data via ODATA?

    Have a look at this blog post

    community.dynamics.com/.../microsoft-dynamics-gp-2016-odata-service

    Regards

    David

  • Suggested answer
    Derek Albaugh Profile Picture
    on at
    RE: Does Microsoft GP have ability to return data via ODATA?

    OData just gives you an option to pull GP table or view information into Excel, Power BI, etc.

    It's just pulling data from the tables and/or views you publish to OData and more of just a reporting tool.

    Thanks

  • Michael O'Donnell Profile Picture
    355 on at
    RE: Does Microsoft GP have ability to return data via ODATA?

    All GP data sits in SQL tables. It's yours for the taking.

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,302 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,108 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Product updates

Dynamics 365 release plans