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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

OData Service for GP 2018 RTM, and HTTP ERROR 404

(1) ShareShare
ReportReport
Posted on by 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

I have the same question (0)
  • Tim Wappat Profile Picture
    5,711 on at

    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.

  • Verified answer
    YasserMahmoud Profile Picture
    270 on at

    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

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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans