Update/Insert Upsert (Microsoft SQL Server -> Salesforce)
I am trying to update records on a related custom object in Salesforce or insert if it's not present, but when I try to use the update block I receive the following message:
Message: Multi-object operations are not allowed. More than one object matched the filter criteria. Parameter name: allowMultipleObject: Error in calling Operation Update at Scribe.Connector.Force.Operations.UpdateOperation.QueryIdsForUpdate(DataEntity dataEntity, Expression lookupCondition, Boolean allowMultipleObject) at Scribe.Connector.Force.Operations.UpdateOperation.GetUpdateDefinitions(OperationInput operationInput, PreProcessingError& preProcessingErrors, MultipleObjectBlock& multipleObjectBlocks)
If I try to use insert block, the status shows completed successfully but does not return anything in Salesforce.
Basically what I am trying to achieve is query tickets from SQL Server, and upsert flights__c records within the opportunity. The only way I can relate the records to the opportunity is by ID and that's why I use the Fetch Opportunity block.
Thank you so much for your help in advance!