{"id":6739,"date":"2019-01-24T14:52:04","date_gmt":"2019-01-24T19:52:04","guid":{"rendered":"https:\/\/www.jitendrazaa.com\/blog\/?p=6739"},"modified":"2019-01-24T23:52:20","modified_gmt":"2019-01-25T04:52:20","slug":"process-pipe-delimited-file-in-mulesoft-3","status":"publish","type":"post","link":"https:\/\/www.jitendrazaa.com\/blog\/integration\/process-pipe-delimited-file-in-mulesoft-3\/","title":{"rendered":"Use pipe delimited file to upsert record in Mulesoft 3"},"content":{"rendered":"\n

Processing Comma Separated file is out of box but what if text file is delimited using comma.<\/p>\n\n\n\n

In this post, we will read Pipe delimited file and upsert record in Salesforce. Instead of upserting record in Salesforce, you can do anything else you want to.<\/p>\n\n\n\n

This is how final job will look like :<\/p>\n\n\n\n

\"\"<\/figure><\/div>\n\n\n\n\n\n\n\n

Pipe delimited file that we want to upload looks like, SAART Account Id is external id that would be used for upsert operation.<\/p>\n\n\n

\nNAME|SAART ACCOUNT ID\nAT&T|2\nIBM|1\nSalesforce|3\n<\/pre><\/div>\n\n\n
Step 1<\/strong> is to bring File component in Mule 3 workspace.  only two settings I configured<\/p>\n\n\n\n
  1. Path<\/li>
  2. File Name in “File Name Regex Filter”<\/li><\/ol>\n\n\n\n
    Step 2<\/strong> is to bring Salesforce component. Configure as shown in below image. In my case I’m going to upsert Account on basis of external Id field SAART Account Id<\/p>\n\n\n\n
    \"Configure
    Configure Salesforce Connector in Mulesoft 3<\/figcaption><\/figure><\/div>\n\n\n\n
    Step 3<\/strong> is to bring Transform Message between File and Salesforce component in workspace. Right click on Payload and select Set Metadata<\/strong><\/p>\n\n\n\n
    \"\"
    Set Metadata on Transform Message<\/figcaption><\/figure><\/div>\n\n\n\n
    After clicking Set Metadata, below screen will appear. We need to choose CSV<\/strong> as Type and add Headers manually.<\/p>\n\n\n\n
    \"Mulesoft
    Mulesoft Transformation Message Metadata<\/figcaption><\/figure><\/div>\n\n\n\n
    Next step is to inform Mule that this CSV file would be delimited using pipe operator. Select Transform message and click on Reader Configuration<\/strong><\/p>\n\n\n\n
    \"Reader
    Reader Configuration in Transform Message – Mulesoft 3<\/figcaption><\/figure><\/div>\n\n\n\n
    when popup comes up, set separator as Pipe (|) operator instead of comma<\/p>\n\n\n\n
    \"Mulesoft
    Mulesoft 3 – Transform Message Reader Configuration<\/figcaption><\/figure><\/div>\n\n\n\n
    Step 4 <\/strong>: Bring Logger in workspace to show output of Salesforce operation<\/p>\n\n\n\n
    \"Logger
    Logger in Mulesoft 3<\/figcaption><\/figure><\/div>\n\n\n\n
    Running it : Start Mulesoft and put valid file in folder mentioned in Step 1. Mule will process it, delete it and show log in console.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Use Mulesoft to upsert record in Salesforce using Pipe delimited file<\/p>\n","protected":false},"author":1,"featured_media":6749,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"jz_research_post":"","_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[453,454],"tags":[120,456,455],"class_list":["post-6739","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-integration","category-mulesoft","tag-integration","tag-mulesoft","tag-mulesoft-3"],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2019\/01\/Upsert-record-in-Salesforce-using-Mulesoft.png?fit=500%2C215&ssl=1","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":6752,"url":"https:\/\/www.jitendrazaa.com\/blog\/integration\/mulesoft\/defining-pipe-delimited-separator-in-mulesoft-3-4\/","url_meta":{"origin":6739,"position":0},"title":"Defining pipe delimited separator in Mulesoft 3 & 4","author":"Jitendra","date":"January 24, 2019","format":false,"excerpt":"How to use Pipe delimiter as separator in Mulesoft 3 and 4","rel":"","context":"In "Mulesoft"","block_context":{"text":"Mulesoft","link":"https:\/\/www.jitendrazaa.com\/blog\/category\/integration\/mulesoft\/"},"img":{"alt_text":"Reader Configuration in Transform Message - Mulesoft 3","src":"https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2019\/01\/Reader-Configuration-in-Transform-Message-Mulesoft-3.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2019\/01\/Reader-Configuration-in-Transform-Message-Mulesoft-3.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2019\/01\/Reader-Configuration-in-Transform-Message-Mulesoft-3.png?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2019\/01\/Reader-Configuration-in-Transform-Message-Mulesoft-3.png?resize=700%2C400&ssl=1 2x, https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2019\/01\/Reader-Configuration-in-Transform-Message-Mulesoft-3.png?resize=1050%2C600&ssl=1 3x, https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2019\/01\/Reader-Configuration-in-Transform-Message-Mulesoft-3.png?resize=1400%2C800&ssl=1 4x"},"classes":[]},{"id":7741,"url":"https:\/\/www.jitendrazaa.com\/blog\/integration\/mulesoft\/salesforce-bulk-api-2-using-mulesoft\/","url_meta":{"origin":6739,"position":1},"title":"Salesforce Bulk API 2 using Mulesoft","author":"Jitendra","date":"November 20, 2022","format":false,"excerpt":"Demo of using Bulk API 2 & Solving most common errors","rel":"","context":"In "Mulesoft"","block_context":{"text":"Mulesoft","link":"https:\/\/www.jitendrazaa.com\/blog\/category\/integration\/mulesoft\/"},"img":{"alt_text":"Bulk API 2 using MuleSoft","src":"https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2022\/11\/Bulk-API-2-using-Mulesoft.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2022\/11\/Bulk-API-2-using-Mulesoft.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2022\/11\/Bulk-API-2-using-Mulesoft.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2022\/11\/Bulk-API-2-using-Mulesoft.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2022\/11\/Bulk-API-2-using-Mulesoft.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":4447,"url":"https:\/\/www.jitendrazaa.com\/blog\/salesforce\/all-about-upsert-and-external-id-in-dataloader-and-apex-videos\/","url_meta":{"origin":6739,"position":2},"title":"All about Upsert and External ID in Dataloader and Apex – Videos","author":"Jitendra","date":"May 11, 2015","format":false,"excerpt":"You may be wondering that there are tons of articles available for upsert operation and what is need of one more blog post. I wanted to note everything important about upsert operations using datalaoder and Apex with identified gotchas at single place, and that's why its here :) . External\u2026","rel":"","context":"In "Apex"","block_context":{"text":"Apex","link":"https:\/\/www.jitendrazaa.com\/blog\/category\/salesforce\/apex\/"},"img":{"alt_text":"Field Mapping to create Parent Child relationship using ExternalId in Salesforce","src":"https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2015\/05\/Field-Mapping-to-create-Parent-Child-relationship-using-ExternalId-in-Salesforce-e1431304939365.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2015\/05\/Field-Mapping-to-create-Parent-Child-relationship-using-ExternalId-in-Salesforce-e1431304939365.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2015\/05\/Field-Mapping-to-create-Parent-Child-relationship-using-ExternalId-in-Salesforce-e1431304939365.png?resize=525%2C300&ssl=1 1.5x"},"classes":[]},{"id":30699,"url":"https:\/\/www.jitendrazaa.com\/blog\/salesforce\/complete-mulesoft-guide-40-expert-interview-questions\/","url_meta":{"origin":6739,"position":3},"title":"Complete MuleSoft Guide: 40+ Expert Interview Questions & Answers","author":"Jitendra Zaa","date":"December 18, 2025","format":false,"excerpt":"Master MuleSoft interviews with 40+ expert questions covering API-led connectivity, DataWeave, Kafka, Salesforce integration, AI capabilities (Agentforce, MAC Project), CloudHub deployment, VPC\/VPN security, certifications, and career paths. Includes Gartner iPaaS 2025 insights.","rel":"","context":"In "Integration"","block_context":{"text":"Integration","link":"https:\/\/www.jitendrazaa.com\/blog\/category\/integration\/"},"img":{"alt_text":"Complete MuleSoft Guide - 40+ Expert Interview Questions covering API-Led Connectivity, DataWeave, Agentforce AI, CloudHub VPC, Certifications, Career Path, Kafka Integration, and Gartner iPaaS 2025","src":"https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2025\/12\/mulesoft-interview-questions-2025-featured-new.png?fit=1200%2C704&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2025\/12\/mulesoft-interview-questions-2025-featured-new.png?fit=1200%2C704&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2025\/12\/mulesoft-interview-questions-2025-featured-new.png?fit=1200%2C704&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2025\/12\/mulesoft-interview-questions-2025-featured-new.png?fit=1200%2C704&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2025\/12\/mulesoft-interview-questions-2025-featured-new.png?fit=1200%2C704&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":6863,"url":"https:\/\/www.jitendrazaa.com\/blog\/integration\/mulesoft\/mulesoft-live-demo-alpharetta-developer-group-meet\/","url_meta":{"origin":6739,"position":4},"title":"Introduction to Mulesoft with Example – Alpharetta Developer Group Meet","author":"Jitendra","date":"June 17, 2019","format":false,"excerpt":"Slides and Video from Alpharetta Developer group meet - Loading data in Salesforce using Mulesoft 4","rel":"","context":"In "Mulesoft"","block_context":{"text":"Mulesoft","link":"https:\/\/www.jitendrazaa.com\/blog\/category\/integration\/mulesoft\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/img.youtube.com\/vi\/sqWLC2I8Ozg\/0.jpg?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":6898,"url":"https:\/\/www.jitendrazaa.com\/blog\/integration\/mulesoft\/mulesoft-4-transformation-convert-json-to-xml\/","url_meta":{"origin":6739,"position":5},"title":"Mulesoft 4 Transformation – Convert JSON to XML","author":"Jitendra","date":"September 15, 2019","format":false,"excerpt":"Dataweave code to convert JSON to XML in Mulesoft 4","rel":"","context":"In "Mulesoft"","block_context":{"text":"Mulesoft","link":"https:\/\/www.jitendrazaa.com\/blog\/category\/integration\/mulesoft\/"},"img":{"alt_text":"Mulesoft-Project-Convert-JSON-to-XML","src":"https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2019\/09\/Mulesoft-Project-Convert-JSON-to-XML.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]}],"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/posts\/6739","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/comments?post=6739"}],"version-history":[{"count":5,"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/posts\/6739\/revisions"}],"predecessor-version":[{"id":6755,"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/posts\/6739\/revisions\/6755"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/media\/6749"}],"wp:attachment":[{"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/media?parent=6739"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/categories?post=6739"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/tags?post=6739"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}