Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / OData Service for GP 2...
Microsoft Dynamics GP (Archived)

OData Service for GP 2018 RTM, and HTTP ERROR 404

(1) ShareShare
ReportReport
Posted on by YasserMahmoud 270

Dear Friends,

 

I install and configured GP 2018 ODATA service using below link

https://www.youtube.com/watch?v=bHFmRRb9JZ4&feature=youtu.be

 

Inside GP, I published Accounts View in one company that generated the below link:

http://srvrname.domain.local/GPOData/XYZ/Accounts

 

When I tried testing this link in Chrome Browser, I get error “HTTP ERROR 404”.

When I test it in excel, I get warning “We couldn’t access the data feed server because the feed URL is invalid” and another warning “Unable to obtain list of tables from the data source”.

I note that Security Roles for OData not available in my environment, so I created my own and assign to GP user that assign current windows user for it.

I checked same URL in OData Service Server, local, and had same errors and warning.

 

Note:

SQL Server instance and Databases exist in local domain not in Azure cloud.

 

What the issue I face?

 

I appreciate your help.

Thanks

Yasser Mahmoud

*This post is locked for comments

  • Verified answer
    YasserMahmoud Profile Picture
    YasserMahmoud 270 on at
    RE: OData Service for GP 2018 RTM, and HTTP ERROR 404

    Thanks Tim for your replay.

    I found the issue that I must use https, not http, when publishing OData configuration in GP.

    Beside in installation, I change OData port to 444. So. it must include in OData URL.

    below is example

    srvrname.domain.local/.../Accounts

    Thanks and Regards

    Yasser Mahmoud

  • Tim Wappat Profile Picture
    Tim Wappat 5,701 on at
    RE: OData Service for GP 2018 RTM, and HTTP ERROR 404

    Looks like quite an open question as there could be so many causes for this to be not working as expected.

    One of the first places to check are the event log of the machine to see if there were any errors during install, configuration or running of the services.

    Try browsing from the server too.

    Tim.

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

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 Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans