NAV2013R2:OData connection string with / in the company name

hummel

hi

Here in DK many companies are named with A/S (joint-stock company). The issue is that no matter how I try to connect to the OData feed Excel will not accept the connection when a / is present, see examples below (company is named "Sanovo Foods A/S"):

http://xxxxxxx:7048/TestServicetier/ODa ... ods%20A/S')/Customer
http://xxxxxxx:7048/TestServicetier/ODa ... s%20A%2FS')/Customer
http://xxxxxxx:7048/TestServicetier/ODa ... ods%20A_S')/Customer
http://xxxxxxx:7048/TestServicetier/ODa ... oods%20AS')/Customer

Connecting to companies without a / works fine.

Is this a bug or does anybody know how to connect to a company with a / in the companyname ?

Best regards
Brian Kofoed

Jens_M-P

From what I remember, this has been fixed in Update rollup 1 for Microsoft Dynamics NAV 2013 R2 (Build 35701)​​​.
The issue is called 'GETURL does not return correct encoding for Slash '/''

I hope this helps

hummel

hi

Thanks for you reply, unfortunatly we can not test it, as there is huge bug in the latest builds concerning that ALL service tiers, no matter what they are called starts up with the standard name DynamicsNAV. We need to run several service tiers on the same servers.

But if this issue is also solved we really look forward to a new build

/Brian

Jens_M-P

This is news to me.
So it does not work to e.g. add a new instance in the Management Console with a different name?

What build are you using?

hummel

hi

The bug is known at Microsoft according to CGI. The bug is in build 35796 and 35800, I also think it is in the build you refer to, but here I am not 100% sure if it was build 35701 we tested or another 357xx. We install all our service tiers by cmdlets/scripts, as I am aware it is not yet possible to create service tiers with portsharing by the Management Console. Due to the number service tiers we don't want to create separate ports for each service tier. Port sharing Works fine in our environment.

We are using build 35473, but with 35800 objects, this seems to Work for us (except the / OData bug)

/Brian

hummel

hi

We have now installed build 36035, unfortunatly we still can't get data from companies with /

Hope Microsoft is watching this forum/message.

/Brian

vibaek

I Have the same problem with "Some Company A/S" in NAV 2015 build 39663 - did anyone find a solotion to this problem?

lynge

At our free demo-site (just upgraded to NAV 2016 RTM) this works:

https://navdemo.schost.dk:7052/NAV90_PublicDemo/ODATA/Company('CRONUS Danmark A/S 1')/

(here the company name is "CRONUS Danmark A/S 1"

So space is %20 and forward slash is %2F

Fell free to test it with your browser - login/password is NAVDemo1/NAVDemo1 (setup for NavUserPassword auth.)

Microsoft Edge will just save the answer as a file. Internet Explorer will show something about not understading the feed, but the show source on the page will show you the contents.