Loading
Salesforce から送信されるメールは、承認済ドメインからのみとなります続きを読む

Mule 4: How to do a SQL Merge updates

公開日: Aug 1, 2025
タスク

GOAL

You want to perform Bulks Updates in a Mule 4 Application.

ステップ
  • As a requirement, you will need to use the DB Connector 1.5.1 version or above.

SQL Merge is an Update function, so you will need to use the Update Connector. See the code below as un example:
  
<db:bulk-update doc:name="Bulk update" doc:id="ab77f2ce-8185-40ee-9704-99d5e4c31a43" config-ref="Oracle">
			<db:sql >MERGE INTO destination USING origin ON (Id = :Id)
				WHEN MATCHED
				THEN UPDATE SET Id = :Id,
				Price =
				:Price
				WHEN NOT MATCHED THEN INSERT (Id, Price) VALUES (
				:Id, :Price)</db:sql>
			<db:bulk-input-parameters ><![CDATA[#[[{'Id': 2, 'Price': 200m= }]]]]></db:bulk-input-parameters>
</db:bulk-update>

 
ナレッジ記事番号

001117179

 
読み込み中
Salesforce Help | Article