Open Forum

I've been banging my head on this for a few days now and I'm struggling to understand the disconnect
I've installed the GP Odata service for 2016 and also installed the hotfix. I've walked through the Odata setup in GP
-  configure
- Data sources
- Publish Data
under the admin setup

I've given permissions to the service account using Odata and made sure the AD account im using is assigned to a user in GP that has the ODATA security roles

The issue I'm running into now is whenever I try to navigate to the published odata feed to test it, I get an HTTP Error 404 - Not Found Message (attached)

I've also tried changing the port from 443 to 448 just in case. Does anyone have an idea what the issue might be on this?

------------------------------
Pete Adams
Run Business Solutions
Amarillo TX
------------------------------

Hi @Pete Adams​

Other collaborators here on GPUG as well as myself have found that there were far too many flaws in GP2016's version of Odata - many of these were resolved in the latest version of 2018R2.

I'll tag in @Shawn Dorward, MVP as he, in my humble, is one of the leading users (read understanders) of Odata with GP.

Here is an article from the folks at Njevity regarding the issues and I agree with it.

Microsoft Dynamics GP 2016 and OData, close but no cigar

NjevityToGo		remove preview
Microsoft Dynamics GP 2016 and OData, close but no cigar Prior to the release of GP2016, I was super excited about the new OData feature. I was so looking forward to a live method of sharing data in SQL Server (from Microsoft Dynamics GP) to Microsoft Power BI and Excel, regardless of whether the data is on Premise or in the Cloud. View this on NjevityToGo >

If you can't upgrade to the latest GP version there may be some workarounds to deploying the GP views you would like, but Odata in your version is super buggy.

Best of luck!!

​

------------------------------
Kindest Regards,
Jo deRuiter , MCP, DCP
"That GP Red Head"
AISLING DYNAMICS CONSULTING, LLC
WEBSITE: https://aislingdynamics.com/
BLOG: https://community.dynamics.com/gp/b/gplife
GPUG Academy Instructor
Dynamics GP Credentialing Council-Vice Chair
770-906-4504 (Cell)

------------------------------

Original Message:
Sent: 12-04-2018 09:54 AM
From: Pete Adams
Subject: ODATA Issue

I've been banging my head on this for a few days now and I'm struggling to understand the disconnect
I've installed the GP Odata service for 2016 and also installed the hotfix. I've walked through the Odata setup in GP
-  configure
- Data sources
- Publish Data
under the admin setup

I've given permissions to the service account using Odata and made sure the AD account im using is assigned to a user in GP that has the ODATA security roles

The issue I'm running into now is whenever I try to navigate to the published odata feed to test it, I get an HTTP Error 404 - Not Found Message (attached)

I've also tried changing the port from 443 to 448 just in case. Does anyone have an idea what the issue might be on this?

------------------------------
Pete Adams
Run Business Solutions
Amarillo TX
------------------------------

Thanks for the quick response! I am upgrading this client to 2018 this year so Ill test the functionality there. Im hoping it's that simple :)

------------------------------
Pete Adams
Run Business Solutions
Amarillo TX
------------------------------

Original Message:
Sent: 12-04-2018 10:01 AM
From: Jo deRuiter
Subject: ODATA Issue

Hi @Pete Adams​

Other collaborators here on GPUG as well as myself have found that there were far too many flaws in GP2016's version of Odata - many of these were resolved in the latest version of 2018R2.

I'll tag in @Shawn Dorward, MVP as he, in my humble, is one of the leading users (read understanders) of Odata with GP.

Here is an article from the folks at Njevity regarding the issues and I agree with it.

Microsoft Dynamics GP 2016 and OData, close but no cigar

NjevityToGo		remove preview
Microsoft Dynamics GP 2016 and OData, close but no cigar Prior to the release of GP2016, I was super excited about the new OData feature. I was so looking forward to a live method of sharing data in SQL Server (from Microsoft Dynamics GP) to Microsoft Power BI and Excel, regardless of whether the data is on Premise or in the Cloud. View this on NjevityToGo >

If you can't upgrade to the latest GP version there may be some workarounds to deploying the GP views you would like, but Odata in your version is super buggy.

Best of luck!!

​

------------------------------
Kindest Regards,
Jo deRuiter , MCP, DCP
"That GP Red Head"
AISLING DYNAMICS CONSULTING, LLC
WEBSITE: https://aislingdynamics.com/
BLOG: https://community.dynamics.com/gp/b/gplife
GPUG Academy Instructor
Dynamics GP Credentialing Council-Vice Chair
770-906-4504 (Cell)


Original Message:
Sent: 12-04-2018 09:54 AM
From: Pete Adams
Subject: ODATA Issue

I've been banging my head on this for a few days now and I'm struggling to understand the disconnect
I've installed the GP Odata service for 2016 and also installed the hotfix. I've walked through the Odata setup in GP
-  configure
- Data sources
- Publish Data
under the admin setup

I've given permissions to the service account using Odata and made sure the AD account im using is assigned to a user in GP that has the ODATA security roles

The issue I'm running into now is whenever I try to navigate to the published odata feed to test it, I get an HTTP Error 404 - Not Found Message (attached)

I've also tried changing the port from 443 to 448 just in case. Does anyone have an idea what the issue might be on this?

------------------------------
Pete Adams
Run Business Solutions
Amarillo TX
------------------------------

FWIW: here is a link to my write up about OData and PowerBI for GP2018

Dynamics GP & Power BI (GP2018RTM) | GP Life Hacks

------------------------------
Shawn Dorward
Dynamics GP Practice Lead
Microsoft MVP, Business Applications
shawn.dorward@interdynartis.com
Twitter: @ShawnMDorward
InterDyn Artis
Blog: http://www.GPLifeHacks.com
------------------------------

Original Message:
Sent: 12-04-2018 10:49 AM
From: Pete Adams
Subject: ODATA Issue

Thanks for the quick response! I am upgrading this client to 2018 this year so Ill test the functionality there. Im hoping it's that simple :)

------------------------------
Pete Adams
Run Business Solutions
Amarillo TX

Original Message:
Sent: 12-04-2018 10:01 AM
From: Jo deRuiter
Subject: ODATA Issue

Hi @Pete Adams​

Other collaborators here on GPUG as well as myself have found that there were far too many flaws in GP2016's version of Odata - many of these were resolved in the latest version of 2018R2.

I'll tag in @Shawn Dorward, MVP as he, in my humble, is one of the leading users (read understanders) of Odata with GP.

Here is an article from the folks at Njevity regarding the issues and I agree with it.

Microsoft Dynamics GP 2016 and OData, close but no cigar

NjevityToGo		remove preview
Microsoft Dynamics GP 2016 and OData, close but no cigar Prior to the release of GP2016, I was super excited about the new OData feature. I was so looking forward to a live method of sharing data in SQL Server (from Microsoft Dynamics GP) to Microsoft Power BI and Excel, regardless of whether the data is on Premise or in the Cloud. View this on NjevityToGo >

If you can't upgrade to the latest GP version there may be some workarounds to deploying the GP views you would like, but Odata in your version is super buggy.

Best of luck!!

​

------------------------------
Kindest Regards,
Jo deRuiter , MCP, DCP
"That GP Red Head"
AISLING DYNAMICS CONSULTING, LLC
WEBSITE: https://aislingdynamics.com/
BLOG: https://community.dynamics.com/gp/b/gplife
GPUG Academy Instructor
Dynamics GP Credentialing Council-Vice Chair
770-906-4504 (Cell)


Original Message:
Sent: 12-04-2018 09:54 AM
From: Pete Adams
Subject: ODATA Issue

I've been banging my head on this for a few days now and I'm struggling to understand the disconnect
I've installed the GP Odata service for 2016 and also installed the hotfix. I've walked through the Odata setup in GP
-  configure
- Data sources
- Publish Data
under the admin setup

I've given permissions to the service account using Odata and made sure the AD account im using is assigned to a user in GP that has the ODATA security roles

The issue I'm running into now is whenever I try to navigate to the published odata feed to test it, I get an HTTP Error 404 - Not Found Message (attached)

I've also tried changing the port from 443 to 448 just in case. Does anyone have an idea what the issue might be on this?

------------------------------
Pete Adams
Run Business Solutions
Amarillo TX
------------------------------

OK, looks like that was the issue, at least that I can tell. Odata works as expected when using GP 2018. Thank you so much!

------------------------------
Pete Adams
Run Business Solutions
Amarillo TX
------------------------------

Original Message:
Sent: 12-04-2018 10:01 AM
From: Jo deRuiter
Subject: ODATA Issue

Hi @Pete Adams​

Other collaborators here on GPUG as well as myself have found that there were far too many flaws in GP2016's version of Odata - many of these were resolved in the latest version of 2018R2.

I'll tag in @Shawn Dorward, MVP as he, in my humble, is one of the leading users (read understanders) of Odata with GP.

Here is an article from the folks at Njevity regarding the issues and I agree with it.

Microsoft Dynamics GP 2016 and OData, close but no cigar

NjevityToGo		remove preview
Microsoft Dynamics GP 2016 and OData, close but no cigar Prior to the release of GP2016, I was super excited about the new OData feature. I was so looking forward to a live method of sharing data in SQL Server (from Microsoft Dynamics GP) to Microsoft Power BI and Excel, regardless of whether the data is on Premise or in the Cloud. View this on NjevityToGo >

If you can't upgrade to the latest GP version there may be some workarounds to deploying the GP views you would like, but Odata in your version is super buggy.

Best of luck!!

​

------------------------------
Kindest Regards,
Jo deRuiter , MCP, DCP
"That GP Red Head"
AISLING DYNAMICS CONSULTING, LLC
WEBSITE: https://aislingdynamics.com/
BLOG: https://community.dynamics.com/gp/b/gplife
GPUG Academy Instructor
Dynamics GP Credentialing Council-Vice Chair
770-906-4504 (Cell)


Original Message:
Sent: 12-04-2018 09:54 AM
From: Pete Adams
Subject: ODATA Issue

I've been banging my head on this for a few days now and I'm struggling to understand the disconnect
I've installed the GP Odata service for 2016 and also installed the hotfix. I've walked through the Odata setup in GP
-  configure
- Data sources
- Publish Data
under the admin setup

I've given permissions to the service account using Odata and made sure the AD account im using is assigned to a user in GP that has the ODATA security roles

The issue I'm running into now is whenever I try to navigate to the published odata feed to test it, I get an HTTP Error 404 - Not Found Message (attached)

I've also tried changing the port from 443 to 448 just in case. Does anyone have an idea what the issue might be on this?

------------------------------
Pete Adams
Run Business Solutions
Amarillo TX
------------------------------