We are trying to send data from our Salesforce instance through Boomi into Epicor but are coming across some issues. The main one at this point being "Violation of Primary Key constraint ‘PK_OrderHed’ (as we are trying to send to the OrderHed table.
Is this something that others have accomplished? We are hoping to get some insight to help this integration so we can further utilize the Epicor platform and expand our usage.
Are you sending data to an existing Order? Or are you going to be creating new Orders?
The error sounds like you are trying to do an insert to the table using an order number that is already in the system.
Trying to create a new order technically, right now we are just testing to see if we can even transfer any data from Salesforce to Epicor, this was one of the fields that we will need to match
Please utilise the Rest API’s to add orders or import instead of trying to utilise the database directly.
We have created new orders outside of Epicor using the BOs. This was before REST so that wasn’t an option. Since it works, I haven’t updated the code.
What tool are you using to create the orders? Thought Epicor has an integration with Salesforce, (I haven’t used it, but have heard that it is out there)
Sorry just read that you are using Boomi, don’t know that tool. How does it work with Epicor?
what connector are you using in Boomi to get the order to Epicor. DB insert, REST, calling BOs?
We send order via REST into Epicor using MS Flow and it works great. I concur to not update the records in the DB directly instead rely on the BOs and REST to let it handle it.