Upsert functionality in Rest APIs of Cognite

• Upsert functionality is available in the cognite  Java SDK but not in the rest API calls  

  On a high level there are two types of Rest interfaces which are coming from SAP to CDF 

    

  2)Assets are going through asset hierarchy so they get automatically linked. 

  Events : there are two major concerns 

  Cognite doesn’t have an  upsert API – we need to check every time whether the record exists from PI PO and then call create/ update API based on the response. This is doubling the calls from PI PO side 

  In the event API as per the documentation available in  https://docs.cognite.com/api/v1/#tag/Events/operation/createEvents the request body schema assetIds is expecting internal ID . Asset IDs of equipment that this event relates to).  

   

    

  Due to the above cognite design there is duplicity of calls . 

   So, we are requesting the below requirements 

   

   

  Requirements 

  • Assets  

  •            Functional Location, Equipment. 

  • Events 

  •            Notifications, Work order 

  1. The challenge is SAP doesn’t have the Cognite internal id of the equipment to send it in the work order. 

  2. The event API doesn’t even have an event id to link.( i.e to link work order operations with work order header) 

Must Have  

• Assets API  
  • A single API should have the capability to update/create assets 
  • Same API should have the capability to use external ID to update assets 
• Events API 
  • A single API should have the capability to update/create events 
  • Same API should have the capability to use external ID to update events 
  • Same API should have the capability to use external ID to link assets 
  • Same API should have parent external ID to link to a parent event. 

Good to Have  

• Single API which can do upsert for other Cognite Objects. 

• Same API should have the capability to use external ID to update other cognite objects