...
How to Build Your Multi-tenant OData URL
🛠️ Work in progress - Put step #4 above here?
Notes
(W(n)): some sites will show these two URL segments, some sites will not.
(W(n)) where n = integer.
When the tenant name has spaces, the Acumatica URL will replace them with '+'. However, use %20 instead of + for the OData URL.
Examples:Acumatica URL: https://acumatica.com/Main?CompanyID=DataSelf+ETL+Plus&ScreenId=DB000031
OData URL: https://acumatica/odata/DataSelf%20ETL%20Plus/
The URL works with the regular table name appended. But it will not work with the full DAC name (example: PX_Objects_PO_POLine)
In ETL+, when you change the DAC table name between a tables and its PX_Objects sibling, you might have to update/re-add the SQL statement (column list). These two DAC tables might NOT have exactly the same column list.
...