I am working with a customer who has multiple tenants. We are doing projects using ODatav4 to pull data to a third party tool. This is working fine for all of the tenants except one. As far as I can tell, the only difference is that this tenant has an ampersand in the name. So the name is, say, “AB&C Corp”. We know to replace the space with “%20” but we cannot seem to get the URL correct for the ampersand.
The thing is, we get no error message via Postman or other tools, it says the status is “200 OK”… but no data is returned at all.
I have tried several versions of the URL:
https://xxx.acumatica.com/odatav4/AB&C%20Corp/$metadata
https://xxx.acumatica.com/odatav4/AB%26C%20Corp/$metadata
https://xxx.acumatica.com/odatav4/ABC%20Corp/$metadata
None succeed. That third version gives a 404 Not Found response. The other two come back with the OK response.
Like I said, we have lots of tenants and they are all working properly. I suppose it could be a setting somewhere that got overlooked but I haven’t found it. Which is why I am focused on the ampersand. Is that possibly the problem and is there a workaround for it?
Best answer by Samuel Olivier Lavigueur
View original