Start a new topic
Answered

How to update basic entity records?

Query on Data Integration in Semarchy: Basic Entity(SA Table) Initially, the entire data(full snapshot) is being loaded via REST API. Later on, when we have updates on the previously loaded record how can we do that in Semarchy, if the PK is semarchy generated. As far as I know, the updation happens on PK. Note: Data is being ingested from SAP PRE using SAP PO as the middleware tool. • One way to achieve this is asking SAP PO team to do get request for the ID that needs to be updated and then update the record information for that ID. Is there any other way to achieve this apart from this? Eg: This is the data existing in the RetailSite Entity. Now, I have to update the SiteName from ABC to ABCD. RetailSiteID(Semarchy Generated ID) SiteName Brand 1 ABC BP 2 DEF BP


Best Answer

Hi Srinivasa, you are correct that when updating records in a basic entity you will need to reference the primary key value to make the update.


Unfortunately in SQL the entire record is updated where in the REST API we are performing a checkout, so in this logic you can update one attibute while the rest of the data is maintained. 

In the past, through REST API, we used to update just Status.. But can same be done from SQL load.. 

Hi Fathia,


    Is there any straight forward way to have a settings on Basic entities to skip Null value updates on specific fields.. 

Answer

Hi Srinivasa, you are correct that when updating records in a basic entity you will need to reference the primary key value to make the update.

Login to post a comment