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.
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.
N
Naveena MANDAVA
said
7 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..
N
Naveena MANDAVA
said
7 months ago
In the past, through REST API, we used to update just Status.. But can same be done from SQL load..
F
Fathia Jama
said
7 months ago
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.
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 Oldest FirstFathia 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.
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..
Naveena MANDAVA
In the past, through REST API, we used to update just Status.. But can same be done from SQL load..
Fathia 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.
-
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 71 topics