{"id":3324,"date":"2023-04-12T15:26:35","date_gmt":"2023-04-12T15:26:35","guid":{"rendered":"https:\/\/quebit.com\/askquebit\/export-from-a-saved-view-using-anaplan-connect-and-batch-script\/"},"modified":"2023-04-12T17:27:12","modified_gmt":"2023-04-12T17:27:12","slug":"export-from-a-saved-view-using-anaplan-connect-and-batch-script","status":"publish","type":"post","link":"https:\/\/quebit.com\/askquebit\/export-from-a-saved-view-using-anaplan-connect-and-batch-script\/","title":{"rendered":"Export from a Saved View using Anaplan Connect and Batch Script"},"content":{"rendered":"<p><strong>Anaplan Connect<\/strong> is an API (application programming interface) client that functions using a command-line interface. Through this interface, and the writing of batch and or shell scripts, an Anaplan administrator may automate the running of various actions from Anaplan. Typically, when using Anaplan\u2019s API or Anaplan Connect, users leverage a predefined import, export, or some other kind of action type to make use of the available customization, automation, and scheduling capabilities inherent to API and scripting tools. However, Anaplan Connect also allows users to perform exports directly from saved views in Anaplan.<\/p>\n<p>To achieve this, one would first need to create a saved view. Pivot and filter your module to your needs, click on the \u2018View\u2019 drop down, and then click on \u2018Save As\u2026\u2019<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-1998 alignnone\" src=\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2022\/01\/V1-min.jpg\" alt=\"\" width=\"779\" height=\"447\" \/><\/p>\n<p>Title your view and enable the selectors as you see fit.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-1999 alignnone\" src=\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2022\/01\/V2-min.jpg\" alt=\"\" width=\"292\" height=\"217\" \/><\/p>\n<p>Your saved view is now ready to export via <strong>Anaplan Connect<\/strong>. For this example, I will cover only a <strong>batch script<\/strong> to perform the export. You will need your Anaplan user email and password, the Anaplan service URL, Anaplan authentication URL, your respective workspace and model IDs, a chosen file path to export to, and your respective module and saved view names.<\/p>\n<p>Workspace and model IDs may be found within the Anaplan GUI, under the question mark, and in the \u2018About\u2019 tab:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-2000 alignnone\" src=\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2022\/01\/V3-min.jpg\" alt=\"\" width=\"356\" height=\"663\" \/><\/p>\n<p>See the below script for a full example:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-large wp-image-2001 alignnone\" src=\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2022\/01\/V4-min-1018x1024.jpg\" alt=\"\" width=\"605\" height=\"609\" \/><\/p>\n<p><strong><em>Security Consideration<\/em>: <\/strong>Note that leaving the \u2018<strong>AnaplanPassword<\/strong>\u2019 variable outside of the quotes, as is formatted in the above text box, will require you to enter your password upon running the script. If you are setting the script to run via a set schedule, you may prefer to hard code your password. This is a less secure option, but it will allow the script to run without interruption. Otherwise, Anaplan Connect offers Certificate Authority (CA) authentication. \u00a0It is wise to use a Java KeyStore to protect your private key and certificate with a KeyStore password. See the <a href=\"https:\/\/anaplanenablement.s3.amazonaws.com\/Community\/Anapedia\/Anaplan_Connect_User_Guide_v2.1.1.pdf\">Anaplan Connect documentation<\/a> for further instructions on starting with CA authentication and batch and or shell script adaptations.<\/p>\n<p>Setting the file path is required to achieve an output. On Windows, you may hold shift, right click, and select \u2018Copy as Path\u2019 to acquire a file path to a given location. This path may then be pasted into the quotes following the \u2018<strong>FilePath<\/strong>\u2019 variable.<\/p>\n<p>Your operation line will need to include the <strong>\u2018-execute -get:csv_mc<\/strong>\u2019 to perform the direct export from a saved view function.<\/p>\n<p>Once your script is completed, save it, navigate to the saved script, and double click on it to run. Otherwise, you may use the command line to navigate to the scripts location and enter the .bat file\u2019s name to run it.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anaplan Connect is an API (application programming interface) client that functions using a command-line interface. Through this interface, and the writing of batch and or shell scripts, an Anaplan administrator may automate the running of various actions from Anaplan. Typically, when using Anaplan\u2019s API or Anaplan Connect, users leverage a predefined import, export, or some&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[22],"tags":[66,68,35],"class_list":["post-3324","post","type-post","status-publish","format-standard","hentry","category-anaplan","tag-analplan-development","tag-anaplan","tag-development"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Export from a Saved View using Anaplan Connect and Batch Script - QueBIT<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/quebit.com\/askquebit\/export-from-a-saved-view-using-anaplan-connect-and-batch-script\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Export from a Saved View using Anaplan Connect and Batch Script - QueBIT\" \/>\n<meta property=\"og:description\" content=\"Anaplan Connect is an API (application programming interface) client that functions using a command-line interface. Through this interface, and the writing of batch and or shell scripts, an Anaplan administrator may automate the running of various actions from Anaplan. Typically, when using Anaplan\u2019s API or Anaplan Connect, users leverage a predefined import, export, or some&hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/quebit.com\/askquebit\/export-from-a-saved-view-using-anaplan-connect-and-batch-script\/\" \/>\n<meta property=\"og:site_name\" content=\"QueBIT\" \/>\n<meta property=\"article:published_time\" content=\"2023-04-12T15:26:35+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-04-12T17:27:12+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2022\/01\/V1-min.jpg\" \/>\n<meta name=\"author\" content=\"agoddard\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"agoddard\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/export-from-a-saved-view-using-anaplan-connect-and-batch-script\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/export-from-a-saved-view-using-anaplan-connect-and-batch-script\\\/\"},\"author\":{\"name\":\"agoddard\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#\\\/schema\\\/person\\\/e52d72da0fd2f5f70d189343fe4f5084\"},\"headline\":\"Export from a Saved View using Anaplan Connect and Batch Script\",\"datePublished\":\"2023-04-12T15:26:35+00:00\",\"dateModified\":\"2023-04-12T17:27:12+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/export-from-a-saved-view-using-anaplan-connect-and-batch-script\\\/\"},\"wordCount\":460,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/export-from-a-saved-view-using-anaplan-connect-and-batch-script\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2022\\\/01\\\/V1-min.jpg\",\"keywords\":[\"Analplan Development\",\"Anaplan\",\"Development\"],\"articleSection\":[\"Anaplan\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/quebit.com\\\/askquebit\\\/export-from-a-saved-view-using-anaplan-connect-and-batch-script\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/export-from-a-saved-view-using-anaplan-connect-and-batch-script\\\/\",\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/export-from-a-saved-view-using-anaplan-connect-and-batch-script\\\/\",\"name\":\"Export from a Saved View using Anaplan Connect and Batch Script - QueBIT\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/export-from-a-saved-view-using-anaplan-connect-and-batch-script\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/export-from-a-saved-view-using-anaplan-connect-and-batch-script\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2022\\\/01\\\/V1-min.jpg\",\"datePublished\":\"2023-04-12T15:26:35+00:00\",\"dateModified\":\"2023-04-12T17:27:12+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#\\\/schema\\\/person\\\/e52d72da0fd2f5f70d189343fe4f5084\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/export-from-a-saved-view-using-anaplan-connect-and-batch-script\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/quebit.com\\\/askquebit\\\/export-from-a-saved-view-using-anaplan-connect-and-batch-script\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/export-from-a-saved-view-using-anaplan-connect-and-batch-script\\\/#primaryimage\",\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2022\\\/01\\\/V1-min.jpg\",\"contentUrl\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2022\\\/01\\\/V1-min.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/export-from-a-saved-view-using-anaplan-connect-and-batch-script\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Export from a Saved View using Anaplan Connect and Batch Script\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#website\",\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/\",\"name\":\"QueBIT\",\"description\":\"QueBIT\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#\\\/schema\\\/person\\\/e52d72da0fd2f5f70d189343fe4f5084\",\"name\":\"agoddard\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d817b364cff1d66116debde8d1c85e5e76eeece9c5ae731b19276a6040231455?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d817b364cff1d66116debde8d1c85e5e76eeece9c5ae731b19276a6040231455?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d817b364cff1d66116debde8d1c85e5e76eeece9c5ae731b19276a6040231455?s=96&d=mm&r=g\",\"caption\":\"agoddard\"},\"sameAs\":[\"https:\\\/\\\/quebit.com\\\/askquebit\"],\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/author\\\/agoddard\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Export from a Saved View using Anaplan Connect and Batch Script - QueBIT","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/quebit.com\/askquebit\/export-from-a-saved-view-using-anaplan-connect-and-batch-script\/","og_locale":"en_US","og_type":"article","og_title":"Export from a Saved View using Anaplan Connect and Batch Script - QueBIT","og_description":"Anaplan Connect is an API (application programming interface) client that functions using a command-line interface. Through this interface, and the writing of batch and or shell scripts, an Anaplan administrator may automate the running of various actions from Anaplan. Typically, when using Anaplan\u2019s API or Anaplan Connect, users leverage a predefined import, export, or some&hellip;","og_url":"https:\/\/quebit.com\/askquebit\/export-from-a-saved-view-using-anaplan-connect-and-batch-script\/","og_site_name":"QueBIT","article_published_time":"2023-04-12T15:26:35+00:00","article_modified_time":"2023-04-12T17:27:12+00:00","og_image":[{"url":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2022\/01\/V1-min.jpg","type":"","width":"","height":""}],"author":"agoddard","twitter_card":"summary_large_image","twitter_misc":{"Written by":"agoddard","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/quebit.com\/askquebit\/export-from-a-saved-view-using-anaplan-connect-and-batch-script\/#article","isPartOf":{"@id":"https:\/\/quebit.com\/askquebit\/export-from-a-saved-view-using-anaplan-connect-and-batch-script\/"},"author":{"name":"agoddard","@id":"https:\/\/quebit.com\/askquebit\/#\/schema\/person\/e52d72da0fd2f5f70d189343fe4f5084"},"headline":"Export from a Saved View using Anaplan Connect and Batch Script","datePublished":"2023-04-12T15:26:35+00:00","dateModified":"2023-04-12T17:27:12+00:00","mainEntityOfPage":{"@id":"https:\/\/quebit.com\/askquebit\/export-from-a-saved-view-using-anaplan-connect-and-batch-script\/"},"wordCount":460,"commentCount":0,"image":{"@id":"https:\/\/quebit.com\/askquebit\/export-from-a-saved-view-using-anaplan-connect-and-batch-script\/#primaryimage"},"thumbnailUrl":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2022\/01\/V1-min.jpg","keywords":["Analplan Development","Anaplan","Development"],"articleSection":["Anaplan"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/quebit.com\/askquebit\/export-from-a-saved-view-using-anaplan-connect-and-batch-script\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/quebit.com\/askquebit\/export-from-a-saved-view-using-anaplan-connect-and-batch-script\/","url":"https:\/\/quebit.com\/askquebit\/export-from-a-saved-view-using-anaplan-connect-and-batch-script\/","name":"Export from a Saved View using Anaplan Connect and Batch Script - QueBIT","isPartOf":{"@id":"https:\/\/quebit.com\/askquebit\/#website"},"primaryImageOfPage":{"@id":"https:\/\/quebit.com\/askquebit\/export-from-a-saved-view-using-anaplan-connect-and-batch-script\/#primaryimage"},"image":{"@id":"https:\/\/quebit.com\/askquebit\/export-from-a-saved-view-using-anaplan-connect-and-batch-script\/#primaryimage"},"thumbnailUrl":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2022\/01\/V1-min.jpg","datePublished":"2023-04-12T15:26:35+00:00","dateModified":"2023-04-12T17:27:12+00:00","author":{"@id":"https:\/\/quebit.com\/askquebit\/#\/schema\/person\/e52d72da0fd2f5f70d189343fe4f5084"},"breadcrumb":{"@id":"https:\/\/quebit.com\/askquebit\/export-from-a-saved-view-using-anaplan-connect-and-batch-script\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/quebit.com\/askquebit\/export-from-a-saved-view-using-anaplan-connect-and-batch-script\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/quebit.com\/askquebit\/export-from-a-saved-view-using-anaplan-connect-and-batch-script\/#primaryimage","url":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2022\/01\/V1-min.jpg","contentUrl":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2022\/01\/V1-min.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/quebit.com\/askquebit\/export-from-a-saved-view-using-anaplan-connect-and-batch-script\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/quebit.com\/askquebit\/"},{"@type":"ListItem","position":2,"name":"Export from a Saved View using Anaplan Connect and Batch Script"}]},{"@type":"WebSite","@id":"https:\/\/quebit.com\/askquebit\/#website","url":"https:\/\/quebit.com\/askquebit\/","name":"QueBIT","description":"QueBIT","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/quebit.com\/askquebit\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/quebit.com\/askquebit\/#\/schema\/person\/e52d72da0fd2f5f70d189343fe4f5084","name":"agoddard","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/d817b364cff1d66116debde8d1c85e5e76eeece9c5ae731b19276a6040231455?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/d817b364cff1d66116debde8d1c85e5e76eeece9c5ae731b19276a6040231455?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d817b364cff1d66116debde8d1c85e5e76eeece9c5ae731b19276a6040231455?s=96&d=mm&r=g","caption":"agoddard"},"sameAs":["https:\/\/quebit.com\/askquebit"],"url":"https:\/\/quebit.com\/askquebit\/author\/agoddard\/"}]}},"_links":{"self":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts\/3324","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/comments?post=3324"}],"version-history":[{"count":1,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts\/3324\/revisions"}],"predecessor-version":[{"id":3795,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts\/3324\/revisions\/3795"}],"wp:attachment":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/media?parent=3324"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/categories?post=3324"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/tags?post=3324"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}