I am trying to update and insert (upsert) a bunch of records into Salesforce. The records are in a json file on my hard-drive. The records are inserted but if they already exist, they need me to specify Salesforce "Id" as a column. How do I retreive Id from Salesforce and then add to my json file so that it updates the records.
Context: REST API is being used for this operation. I've configured a .NET client application to do this.
JObject job = JObject.Parse(File.ReadAllText(@"C:\Users\vinaytemb\accounts1rec.json")); String x = job.ToString(); String restURL = serviceUrl + "/services/data/v45.0/composite/sObjects/"; HttpRequestMessage rmess = new HttpRequestMessage(new HttpMethod("PATCH"), restURL);