{"id":6360,"date":"2017-11-13T00:09:12","date_gmt":"2017-11-13T00:09:12","guid":{"rendered":"http:\/\/www.jitendrazaa.com\/blog\/?p=6360"},"modified":"2017-11-13T00:09:12","modified_gmt":"2017-11-13T00:09:12","slug":"import-and-export-records-using-salesforce-dx","status":"publish","type":"post","link":"https:\/\/www.jitendrazaa.com\/blog\/salesforce\/import-and-export-records-using-salesforce-dx\/","title":{"rendered":"Import and Export Records using Salesforce DX"},"content":{"rendered":"<p style=\"text-align: justify;\">In today&#8217;s\u00a0<strong><a href=\"https:\/\/www.jitendrazaa.com\/blog\/tag\/continuous-integration\/\">continuous integration<\/a>\u00a0<\/strong>solution built for Salesforce, if you need to load sample data into Salesforce then either we use <a href=\"https:\/\/www.jitendrazaa.com\/blog\/tag\/dataloader\/\">command line dataloader<\/a> or custom tool built to import export records.<\/p>\n<p style=\"text-align: justify;\">With Salesforce DX, we can import and export records right from <a href=\"https:\/\/www.jitendrazaa.com\/blog\/tag\/salesforce-dx\/\">Salesforce DX<\/a>. Again, if you are new to Salesforce DX, then <a href=\"https:\/\/www.jitendrazaa.com\/blog\/salesforce\/getting-started-with-salesforce-dx-salesforce-developer-experience\/\">first read this blog post to quickly understand what is\u00a0<\/a><strong>Salesforce DX.\u00a0<\/strong><\/p>\n<p style=\"text-align: justify;\">We don&#8217;t need\u00a0<strong>Developer Hub or Scratch Orgs\u00a0<\/strong>to use Salesforce DX for import and export. In this blog post, I have used my regular developer org for demo.<\/p>\n<p style=\"text-align: justify;\">First step as always, to make sure if Salesforce DX CLI is connected to your Org or not ? If its not connected then use below command to connect and give alias which is easy to remember.<!--more--><\/p>\n<pre class=\"brush: bash; title: ; notranslate\" title=\"\">\r\nsfdx force:auth:web:login --setalias jzaa1\r\n<\/pre>\n<h5>Export records using Salesforce DX<\/h5>\n<figure id=\"attachment_6362\" aria-describedby=\"caption-attachment-6362\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-6362\" src=\"https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2017\/11\/Import-Export-Data-Using-Salesforce-DX.gif?resize=800%2C510&#038;ssl=1\" alt=\"Import Export Data Using Salesforce DX\" width=\"800\" height=\"510\" \/><figcaption id=\"caption-attachment-6362\" class=\"wp-caption-text\">Import Export Data Using Salesforce DX<\/figcaption><\/figure>\n<p style=\"text-align: justify;\">Below command can be used to export 10 Account records. We can change this SOQL as per requirement<\/p>\n<pre class=\"brush: sql; title: ; notranslate\" title=\"\">\r\nsfdx force:data:tree:export -q &quot;SELECT Id,Name FROM Account limit 10&quot; -d .\/ilovenag -u ilovenagpur@gmail.com\r\n<\/pre>\n<p>Where<br \/>\n-q : SOQL query<br \/>\n-d : directory, where exported json file can be saved<br \/>\n-u : Salesforce user to perform operation<\/p>\n<h5>Import records using Salesforce DX<\/h5>\n<p style=\"text-align: justify;\">Use below command to Import records in Salesforce instance, which we just exported in previous step<\/p>\n<pre class=\"brush: sql; title: ; notranslate\" title=\"\">\r\nsfdx force:data:tree:import -f ilovenag\/Account.json -u jzaa1\r\n<\/pre>\n<p>Where<br \/>\n-f : JSON file to be imported<br \/>\n-u : Salesforce user to perform operation<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Using Salesforce DX to Export and Import records into regular Salesforce Instances without dependency on developer hub org<\/p>\n","protected":false},"author":1,"featured_media":6361,"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":[9],"tags":[294,414,415],"class_list":["post-6360","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-salesforce","tag-continuous-integration","tag-salesforce-dx","tag-sfdx"],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2017\/11\/Import-and-Export-Records-using-SalesforceDx.png?fit=1167%2C347&ssl=1","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":6353,"url":"https:\/\/www.jitendrazaa.com\/blog\/salesforce\/use-metadata-api-with-salesforce-dx\/","url_meta":{"origin":6360,"position":0},"title":"Use Metadata API with Salesforce DX","author":"Jitendra","date":"November 12, 2017","format":false,"excerpt":"How to use SalesforceDX to deploy metadata in Sandboxes or Non-Scratch Salesforce instances","rel":"","context":"In &quot;Salesforce&quot;","block_context":{"text":"Salesforce","link":"https:\/\/www.jitendrazaa.com\/blog\/category\/salesforce\/"},"img":{"alt_text":"Use Metadata API or Package.xml with Salesforce DX","src":"https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2017\/11\/Use-Metadata-API-or-Package.xml-with-SFDX.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\/2017\/11\/Use-Metadata-API-or-Package.xml-with-SFDX.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2017\/11\/Use-Metadata-API-or-Package.xml-with-SFDX.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2017\/11\/Use-Metadata-API-or-Package.xml-with-SFDX.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2017\/11\/Use-Metadata-API-or-Package.xml-with-SFDX.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":6951,"url":"https:\/\/www.jitendrazaa.com\/blog\/salesforce\/mastering-visual-studio-and-salesforce-dx\/","url_meta":{"origin":6360,"position":1},"title":"Mastering Visual Studio and Salesforce DX","author":"Jitendra","date":"January 14, 2020","format":false,"excerpt":"3.5 hours of video to become Master on using and navigating Visual Studio, Need of scratch org and building modular application using Unlocked Packages","rel":"","context":"In &quot;Salesforce&quot;","block_context":{"text":"Salesforce","link":"https:\/\/www.jitendrazaa.com\/blog\/category\/salesforce\/"},"img":{"alt_text":"Salesforce DX on Udemy","src":"https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2020\/01\/Salesforce-DX-on-Udemy.png?fit=1200%2C693&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2020\/01\/Salesforce-DX-on-Udemy.png?fit=1200%2C693&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2020\/01\/Salesforce-DX-on-Udemy.png?fit=1200%2C693&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2020\/01\/Salesforce-DX-on-Udemy.png?fit=1200%2C693&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2020\/01\/Salesforce-DX-on-Udemy.png?fit=1200%2C693&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":6062,"url":"https:\/\/www.jitendrazaa.com\/blog\/salesforce\/getting-started-with-salesforce-dx-salesforce-developer-experience\/","url_meta":{"origin":6360,"position":2},"title":"Most Frequently used SFDX Commands","author":"Jitendra","date":"May 25, 2017","format":false,"excerpt":"Introduction and basics of Salesforce Developer Experience (Salesforce DX) with source code and Video tutorials","rel":"","context":"In &quot;Salesforce&quot;","block_context":{"text":"Salesforce","link":"https:\/\/www.jitendrazaa.com\/blog\/category\/salesforce\/"},"img":{"alt_text":"Salesforce Developer Experience - SFDX","src":"https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2017\/05\/sfdx.jpg-large.jpg?fit=1024%2C512&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2017\/05\/sfdx.jpg-large.jpg?fit=1024%2C512&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2017\/05\/sfdx.jpg-large.jpg?fit=1024%2C512&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2017\/05\/sfdx.jpg-large.jpg?fit=1024%2C512&ssl=1&resize=700%2C400 2x"},"classes":[]},{"id":6606,"url":"https:\/\/www.jitendrazaa.com\/blog\/salesforce\/build-a-salesforce-dx-plugin-in-15-minutes-dreamforce-2018\/","url_meta":{"origin":6360,"position":3},"title":"Build a Salesforce DX Plugin in 15 Min","author":"Jitendra","date":"September 14, 2018","format":false,"excerpt":"My Dreamforce Session to create a Salesforce DX plugin in 15 minutes","rel":"","context":"In &quot;Salesforce&quot;","block_context":{"text":"Salesforce","link":"https:\/\/www.jitendrazaa.com\/blog\/category\/salesforce\/"},"img":{"alt_text":"Salesforce DX Plugin Structure","src":"https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2018\/09\/Salesforce-DX-Plugin-Structure.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":31310,"url":"https:\/\/www.jitendrazaa.com\/blog\/salesforce\/salesforce-mcp-server-for-claude-code-mcp-clients-setup\/","url_meta":{"origin":6360,"position":4},"title":"Salesforce MCP Server for Claude Code &amp; MCP Clients: Setup Guide 2026","author":"Jitendra Zaa","date":"January 30, 2026","format":false,"excerpt":"Master Salesforce MCP Server setup for Claude Code and other MCP clients. Step-by-step guide covering DX MCP Server, OAuth setup, hosted servers, and mcp-remote configuration.","rel":"","context":"In &quot;AI&quot;","block_context":{"text":"AI","link":"https:\/\/www.jitendrazaa.com\/blog\/category\/ai\/"},"img":{"alt_text":"Salesforce MCP Server for Claude Code & MCP Clients - Complete Developer Guide 2026","src":"https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2026\/01\/salesforce-mcp-server-claude-code-guide-featured.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\/2026\/01\/salesforce-mcp-server-claude-code-guide-featured.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2026\/01\/salesforce-mcp-server-claude-code-guide-featured.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2026\/01\/salesforce-mcp-server-claude-code-guide-featured.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2026\/01\/salesforce-mcp-server-claude-code-guide-featured.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":7183,"url":"https:\/\/www.jitendrazaa.com\/blog\/salesforce\/breaking-5-myths-scratch-orgs-salesforce-dx\/","url_meta":{"origin":6360,"position":5},"title":"Breaking 5 Myths &#8211; Scratch Orgs &#038; Salesforce DX","author":"Jitendra","date":"December 6, 2020","format":false,"excerpt":"Its been around 3 years that Salesforce has released new tooling set for developers - Salesforce DX. I've been working on Salesforce since days of S-Control around 2008 and have seen extreme changes on platform for better. To be honest, it's tough to keep yourself up to date on latest\u2026","rel":"","context":"In &quot;Salesforce&quot;","block_context":{"text":"Salesforce","link":"https:\/\/www.jitendrazaa.com\/blog\/category\/salesforce\/"},"img":{"alt_text":"Breaking 5 Myths - Scratch Orgs","src":"https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2020\/12\/Breaking-5-Myths-Scratch-Orgs-e1624579030977.jpg?fit=700%2C495&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2020\/12\/Breaking-5-Myths-Scratch-Orgs-e1624579030977.jpg?fit=700%2C495&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2020\/12\/Breaking-5-Myths-Scratch-Orgs-e1624579030977.jpg?fit=700%2C495&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2020\/12\/Breaking-5-Myths-Scratch-Orgs-e1624579030977.jpg?fit=700%2C495&ssl=1&resize=700%2C400 2x"},"classes":[]}],"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/posts\/6360","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=6360"}],"version-history":[{"count":1,"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/posts\/6360\/revisions"}],"predecessor-version":[{"id":6363,"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/posts\/6360\/revisions\/6363"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/media\/6361"}],"wp:attachment":[{"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/media?parent=6360"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/categories?post=6360"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/tags?post=6360"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}