No, this is not an error in WordPress on this server – “Bad Request – Error in query syntax.” is in fact the intended subject for this Blog post :-).<\/p>\n\n\n\n
If you are running OData WebServices towards you Microsoft Dynamics NAV or 365 Business Central (DBC) and you get this error – and you have a forward slash ( “\/” ) in the company name in question, then this Blog post is for you :-). <\/p>\n\n\n\n
You have just discovered that Excel, PowerShell.exe and\/or older version of PowerShell ISE cannot work with OData URLs with a forward slash in the \u2026\/Company(‘<my company name>’)\/\u2026 part of the URL.<\/p>\n\n\n\n
A obvious solution is to rename the company in NAV\/DBC – but that is not really a neat solution, is it?<\/p>\n\n\n\n
According to this Microsoft blog post<\/a>, another far superior solution exists. NAV\/DBC supports two syntaxes when stating the company name.<\/p>\n\n\n\n The “classic” one you use for OData version 3 when you got the error:<\/p>\n\n\n\n …or the corresponding OData version 4 one:<\/p>\n\n\n\n …and another one for working around this error:<\/p>\n\n\n\n …or the corresponding OData version 4 one:<\/p>\n\n\n\n Note that you can off cause add additonal parameters (selecting tenant or setting filters etc.) to the URL using the ampersand sign ( “&” ) – just like you do when construction any URL.<\/p>\n\n\n\n Congratulations – you solved your problem \ud83d\ude42<\/p>\n\n\n\n If you want to learn more about OData towards NAV\/DBC, I suggest you visit these links:<\/p>\n\n\n\n <\/p>\n","protected":false},"excerpt":{"rendered":" No, this is not an error in WordPress on this server – “Bad Request – Error in query syntax.” is in fact the intended subject for this Blog post :-). If you are running OData WebServices towards you Microsoft Dynamics NAV or 365 Business Central (DBC) and you get this error – and you have … <\/p>\nhttps:\/\/<my hostname>:<my odata port>\/<my instance>\/OData\/Company('<my company')\/<my webservice><\/pre>\n\n\n\nhttps:\/\/<my hostname>:<my odata port>\/<my instance>\/ODataV4\/Company('<my company')\/<my webservice><\/pre>\n\n\n\nhttps:\/\/<my hostname>:<my odata port>\/<my instance>\/OData\/<my webservice>?company='<my company>'<\/pre>\n\n\n\n
https:\/\/<my hostname>:<my odata port>\/<my instance>\/ODataV4\/<my webservice>?company='<my company>'<\/pre>\n\n\n\n
Yes, one of the authors is me :-). Although the blog text is in Danish (sorry), the code example is in English…
<\/li>
<\/li>
Note: This one also shows how to do a lookup using the primary key.
<\/li>
Disclaimer: I’m not sure everything works when NAV\/DBC is the OData target – you’ll have to check that yourself…<\/li><\/ul>\n\n\n\n