Hi, I have trigger calling an external Api once an account is updated, I don't have any DML in the trigger and I'm calling a handler and assigning @future(callout = true) for the method calling the external Api but having this issue: System.CalloutException: You have uncommitted work pending. Please commit or rollback before calling out* I have deactivated the workflow assigned to account but still having this issue and don't see how to debug it even after looking to the developer logs any thoughts please how to debug this issue ?
Hi, I have 2 custom objects, one stroring list of books with details of author , pages etc and one other custom objects linking a contact to a book when inserting a new record assignig a book to a contact in second custom object, I should reference the salesforce Id of the book and the salesforce id of the contact right ?
Hi, I need to run reports for different custom objects with lookup fields, and some other objects are junction objects do I need to change these fields to master detail fields so I can run standard reports ?
Hi, I have 2 custom objects, one stroring list of books with details of author , pages etc and one other custom objects linking a contact to a book when inserting a new record assignig a book to a contact in second custom object, I should reference the salesforce Id of the book and the salesforce id of the contact right ?
I have a set of records in a spreadsheet each with it's own fields. For example, a record might be a contact with an email address, company name, city, phone number, and employee count. I want to bulk upsert this data into Salesforce. The tricky part is what's considered a new record vs an existing record. I do not know the object IDs for the data in the spreadsheet - some might already exist in Salesforce and some might not. Here are two scenarios:
1) If a record in the spreadsheet has the same email address as a record in Salesforce, then they are considered the same and it would be an update. If no record is found with the same email address, then it should create a new record. 2) If a record in the spreadsheet has the same company name and city as a record in Salesforce, then they are considered the same and it would be an update. Unlike before, the email address is irrelevant. If no matching record is found, then it should create a new record.
The rules here might vary and there will be more use cases here. Ideally, matching can be done in a case insensitive manner.
As far as I can tell, an upsert request is based on an object ID. Since there might be thousands of requests per day, using individual API requests might be a problem, and a batch job is ideal.
The Question: Is there some way to send a batch upsert job with thousands of records and specify the rules for what's considered an update (ie: if these fields match) vs what's considered a new field, then the batch job will figure it out and do what's needed? Additionally, is this possible to do via a REST API?
