EPICOR: Difference between revisions

From Starfish ETL
Jump to navigation Jump to search
(Created page with "=Origin= When creating an epicor Origin, you must supply your username, password, Epicor API URL, and then choose a Service. The Epicor API URL will look like: https://starfi...")
(No difference)

Revision as of 20:14, 30 July 2019

Origin

When creating an epicor Origin, you must supply your username, password, Epicor API URL, and then choose a Service. The Epicor API URL will look like: https://starfish.epicorhosting.com/EpicorERPCTS/api/v1

The Service you select will look like ERP.BO.QuoteSvc or Ice.BO.DynamicQuerySvc. Each service contains a number of tables of data. You can only join between tables in the same Service. For example, if you are using the ERP.BO.QuoteSvc, you can join