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
F
Fathia Jama
said
over 2 years ago
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.
N
Naveena MANDAVA
said
8 months ago
In the past, through REST API, we used to update just Status.. But can same be done from SQL load..
N
Naveena MANDAVA
said
8 months ago
Hi Fathia,
Is there any straight forward way to have a settings on Basic entities to skip Null value updates on specific fields..
F
Fathia Jama
said
over 2 years ago
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.
Fathia Jama
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
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.
- Oldest First
- Popular
- Newest First
Sorted by Newest FirstFathia Jama
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.
Naveena MANDAVA
In the past, through REST API, we used to update just Status.. But can same be done from SQL load..
Naveena MANDAVA
Hi Fathia,
Is there any straight forward way to have a settings on Basic entities to skip Null value updates on specific fields..
Fathia Jama
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.
-
Import Data Into Entities via Azure Data Lake
-
Recover Deleted(soft Delete) Record and Configure in Application
-
Data Quality in batch mode and real-time integration
-
Integration with analytics tools
-
Query/Load/Delete data with the REST API
-
Does the Done Tab in Inbox have a limit?
-
How Can I Trigger Enricher or Sql Procedure when deleting?
-
Matching Rules But Only The Latest Record Creates a Golden Record
-
Unstructured and Semi Structured Data in Semarchy?
-
Read CSV files from AWS S3
See all 73 topics