- REST Service Root URL has changed the format to include the current Company. The /api/v1/ segment of the request URL has been replaced with /api/v2/odata/.
- The format of Business Activity Queries (BAQs) data requests has changed to include /Data in the request URL. This is critical for enabling REST API compatibility with Microsoft® Excel® 2016/365. Refer to the BAQ Feeds topic of this guide for detailed information and examples (Display Data in OData Applications Display in Excel Table).
https://[EpicorServer]/[ERPInstance]/api/v2/odata/[Company]/BaqSvc/[BaqName]/Data?[baqParam1]=x&[baqParam2]=y
For the URL, enter the resource you wish to display in this Excel spreadsheet.
https://EpicorServer/ERP102400/api/v2/odata/EPIC06/Erp.Bo.CustomerSvc/Customers
The following URL can be used to display data from the Customer Contacts Business Activity Query:
https://EpicorServer/ERP102400/api/v2/odata/EPIC06/BaqSvc/COM-CustContacts/Data
Example $metadata
https://EpicorServer/ERP102400/api/v2/odata/EPIC06/Erp.Bo.CustomerSvc/$metadata