How can insert or update data in a legacy Epicor version 10.1.500.17? This version does not have API or Service Connect. What are the recommended methods to insert data directly into the Epicor database from External API?
2 Likes
I would guess DMT, but we have always been current
4 Likes
10.1.500 has REST. You just have to enable it in the EAC.
More info: Which version is required to start using REST API - #2 by Olga
Otherwise, DMT. It’s in all 10.x. But if you’re trying to connect an external system the API would be best.
5 Likes
We have large amounts of data across multiple tables and want to develop an API/workflow/application that uses Epicor objects to continuously insert data into the Epicor database once configured.
Are there any options to read data from an external database and insert it into the Epicor database?
I have worked with Service Connect and REST API but this version old does not have these features.
Not that I’m aware of. Either REST or Service Connect with the .NET business objects. You could do direct SQL read/write but that’s strongly not recommended for a lot of reasons. I’d never do that in production.
You should have the REST API. It was added in 10.1.500. You just have to manually enable it.
1 Like
As Chaddb says, REST is in this version but it was the initial release without API keys IIRC. So be careful not to expose it to an open IP address to keep it somewhat more secure.
If you have DMT you can use that as well.
4 Likes
You would need DMT, or use an updatable baq. A dashboard tied to the Ubaq could also use the uotake from Excel. Option as well, not to mention the paste insert capability, which can be used for other STD grids.
A more sophisticated method would be to use a Ubaq then with custom code ingest a CSV… I am sure there examples here.. Of course doing the same thing in functions is a bit simpler, but you don’t have that functionality.
You did not mention what specific data you were wanting to import.
As @Randy mentioned you have the REST API so you could build an external app, in whatever tool you wished. Just note the security implications.
1 Like