Anaplan Upload

In this Article

Overview

You can use the Anaplan Upload Snap to upload binary files to Anaplan models. Text encoding will be UTF-8.

Prerequisites

None.

Support for Ultra Pipelines

Works in Ultra Task Pipelines.

Snap Input and Output

Input/OutputType of ViewNumber of ViewsExamples of Upstream and Downstream SnapsDescription
InputBinary
  • Min:1
  • Max:1

Any Snap that produces a binary output. For example, File Reader

Binary file data that would be used in an Anaplan action (such as processing an import), typically a flat text file, column separated.
OutputDocument
  • Min:0
  • Max:1
N/A

A document output, however, an error output is a binary output. 

Snap Settings

Field NameField DependencyDescription

Label*

N/ASpecify the name for the Snap. You can modify this to be more specific, especially if you have more than one of the same Snap in your Pipeline.

Workspace*


N/A

Specify the workspace that contains the target model.

Default value: N/A

Model*


N/A

Specify the model on which you want the Snap to operate.

Default value: N/A

Server filename*


N/A

Specify the file name for an Anaplan server file.

Default value: None

Overwrite file


N/A

Select this checkbox to overwrite the Anaplan server file. Else, an error is displayed if the file with the same name already exists.

Default value: Selected

Override server settingsN/A

Select this checkbox to override the settings saved on Anaplan's server for SeparatorText DelimiterHeader Row, and First Data Row.

Default value: Not selected

Separator


N/A

Choose a column separator for the Snap to use. The available options are:

  • TAB
  • COMMA
  • SEMICOLON

Default value: TAB

  • Anaplan server might ignore this setting and try to auto detect.
  • Ensure that the separator settings in the Snap match the contents of the uploaded file. Else, an error message, "Could not find separator in the file: <File name>" is displayed.
Text Delimiter*


N/A

Choose the text delimiter for the Snap to use. The available options are:

  • DOUBLE_QUOTE
  • SINGLE_QUOTE
  • NONE

Default value: DOUBLE_QUOTE

Anaplan server might ignore this setting and try to auto detect.

Header Row*


N/A

Specify the integer value indicating the header row for the binary input. Note that the Anaplan server might ignore this setting and try to auto detect.

Default value: 0

First Data Row*N/A

Specify the Integer value indicating the first data row for the binary input. Note that the Anaplan server might ignore this setting and try to auto detect.

Default value: 1

Retry limit*N/A

Specify the maximum number of connection retry attempts the Snap must make in case of a connection failure. If the retry attempts exceed the configured value, the Pipeline execution fails and an error message is displayed.

Default value:  3

Retry interval*N/A

Specify the minimum retry time interval in seconds. Enter the time interval for the Snap to retry a connection request after a failed connection. The time increases exponentially between failures. For example, if the timeout is set to 3 seconds, the first timeout is at 3, the second is at 4.5 and so on.

Default value:  3

HTTP timeout*N/A

Specify the connection timeout value in seconds. In case of a connection failure, the Snap aborts the Pipeline execution. 
For example, if the HTTP timeout is set to 30 seconds, and the Snap fails to establish a connection until 30 seconds, the Pipeline logs a timeout exception and aborts execution.

Default value:  60

Snap Execution

N/A

Select one of the three modes in which the Snap executes. Available options are:

  • Validate & Execute: Performs limited execution of the Snap, and generates a data preview during Pipeline validation. Subsequently, performs full execution of the Snap (unlimited records) during Pipeline runtime.

  • Execute only: Performs full execution of the Snap during Pipeline execution without generating preview data.

  • Disabled: Disables the Snap and all Snaps that are downstream from it.

    Default Value: Execute only
    Example: Validate & Execute

Temporary Files

During execution, data processing on Snaplex nodes occurs principally in-memory as streaming and is unencrypted. When larger datasets are processed that exceeds the available compute memory, the Snap writes Pipeline data to local storage as unencrypted to optimize the performance. These temporary files are deleted when the Snap/Pipeline execution completes. You can configure the temporary data's location in the Global properties table of the Snaplex's node properties, which can also help avoid Pipeline errors due to the unavailability of space. For more information, see Temporary Folder in Configuration Options

Examples


The example assumes that you have configured and authorized a valid Anaplan account (see Configuring Anaplan Accounts) to be used with this Snap. The following Anaplan Upload Snap uploads a file from SnapLogic projects to Anaplan Workspace. The Anaplan Upload Snap is described using the following Pipeline: 

  1. Reads file data from your SnapLogic projects using the File Reader Snap.
  2. Uploads the data to a newly created file on your Anaplan Workspace using the Anaplan Upload Snap. 


The File Reader Snap reads the 123.csv file (a comma separated file) from SnapLogic projects:
 

 Then, the Anaplan Upload Snap creates a new file myNewFile.csv and uploads the 123.csv file data in it. The myNewFile.csv is made available on the Anaplan Workspace, SnapLogic QA, and Model, Anaplan Snap Tests. Note that, you must specify123.csv file formats (Such as SeparatorText Delimiter, & Header Row) for the Snap to upload the file data: 

Upon successful validation of the Snap, you will see a data preview that gets the details of the uploaded file: 

 

Download the Pipeline.

Downloads 

Important steps to successfully reuse Pipelines

  1. Download and import the Pipeline into SnapLogic.
  2. Configure Snap accounts as applicable.
  3. Provide Pipeline parameters as applicable.

  File Modified

File Example_Anaplan_Upload_Pipeline.slp

Jul 06, 2021 by Kalpana Malladi

Snap Pack History

 Click to view/expand
ReleaseSnap Pack Version DateTypeUpdates
August 2022main17386 StableUpgraded with the latest SnapLogic Platform release.
4.29main15993 StableUpgraded with the latest SnapLogic Platform release.
4.28main14627 StableUpgraded with the latest SnapLogic Platform release.
4.27427patches13160 Latest

Fixed the issue with Anaplan Snaps, where the log messages were stored in jccoutput.log file instead of jcc.json file, and updated the dependent libraries.

4.27

main12833

 

Stable

Upgraded with the latest SnapLogic Platform release.
4.26main11181 StableUpgraded with the latest SnapLogic Platform release.
4.25 Patch425patches10360 Latest

Added the following fields to the Anaplan Write Snap:

  • Override server settings
  • Separator
  • Text Delimiter
4.25main9554 StableNo updates made.
4.24424patches9313 LatestFixed an issue related to Index out of range in the Anaplan Upload Snap when the separator is not present or does not match the one in the upload file.
4.24main8556 StableNo updates made.
4.23 

main7430

 

Stable

No updates made.

4.22422patches7392
 
Latest

Fixed the Snap Pack error handling issue by reverting the getChunk method, that returns a variant that contains all or a part of the contents of a large text or binary data Field object, of 1.4.4.2 jar version to 1.4.4.1 jar version and upgraded the jar version to 1.4.4.3.

4.22422patches6561
 
Latest
  • Fixed the Anaplan Snaps by displaying the same value for both Task ID and Task Name, by following the Anaplan client SDK.
  • Enhanced the Anaplan Snaps by allowing you to provide interchangeable inputs for the following fields: 
    • Workspace ID and Workspace Name
    • Model ID and Model Name

      Introduces a suggestible option that enables you to select the Workspace Name and Model Name.

4.22main6403
 
Stable

No updates made.

4.21421patches5851
 
Latest

Fixed the Anaplan Action Snap that outputs the same value for TaskID and TaskName parameters.

4.21snapsmrc542
 
StableNo updates made.
4.20snapsmrc535
 
StableNo updates made
4.19snaprsmrc528
 
Latest

Removed the suggestion button from the Workspace and Model fields in the Snap Settings dialog. Hence, you need to enter the field values manually.  

4.18snapsmrc523
 
Stable

No updates made.

4.17Anaplan7422
 
Latest

Fixed an issue with the Anaplan Read Snap wherein the Snap pulls archived and deleted models.

4.17ALL7402
 
Latest

Pushed automatic rebuild of the latest version of each Snap Pack to SnapLogic UAT and Elastic servers.

4.17snapmrc515
Latest

Added the Snap Execution field to all Standard-mode Snaps. In some Snaps, this field replaces the existing Execute during preview check box.

4.16snapsmrc508
 
Stable

No updates made. Automatic rebuild with a platform release.

4.15snapsmrc500
 
Latest
  • To support Anaplan v2.0 API, we have enhanced the Anaplan Account configuration.
  • Added retry capability to Anaplan Action, Read, Write, and Upload Snaps that allow you to handle connection timeouts during Pipeline execution.
4.14anaplan6247

 

Latest

Added a new property, Override server settings, to override a few settings saved on Anaplan's server.

4.14anaplan5742
 
Latest

Fixed an issue where certain JCC-logging configurations had conflicts in class loading that resulted in inaccurate log information.

4.14snapsmrc490
 
Stable

No updates made. Automatic rebuild with a platform release.

4.13

snapsmrc486

 
Stable

No updates made. Automatic rebuild with a platform release.

4.12

snapsmrc480

 
StableNo updates made. Automatic rebuild with a platform release.
4.11snapsmrc465
 
StableNo updates made. Automatic rebuild with a platform release.
4.10

snapsmrc414

 
StableNo updates made. Automatic rebuild with a platform release.
4.9snapsmrc405
 
Latest
  • Added connection retry logic to Anaplan Action Snap.
  • "Re-submission of chunks" logic added to Anaplan Upload Snap.
4.8

snapsmrc398

 
Stable
  • No updates made. Automatic rebuild with a platform release.
  • Info tab added to accounts.
4.7

anaplan2179

 
Latest

Improved suggest lookup of Anaplan Snaps server files setting.

4.7

snapsmrc382

 
Latest

Updated the Anaplan Action Snap with a new output handling mechanism, Stream errors. Additionally, starting from 4.7 release, the default output handling mechanism is Stream errors. Prior to 4.7 release, the default mechanism was AllSuccess.

4.6

anaplan1874

 
Latest

Improved the error doc schema and error handling.

4.6

anaplan1870

  
Latest

Implemented new "Stream errors" mode.

4.6

anaplan1863

 
Latest

Resolved an issue with the Anaplan Action Snap failing with Java Heap Space.

4.6

snapsmrc362

 
Latest

Extended support for a der encoded representation of Anaplan Certificate for Anaplan account validation. Anaplan Action Snap is enhanced to support handling of output during an import action. If an import operation is unsuccessful, rows without an error are written to the output view, and rows with an error are written to the error view.

4.5.1


 
Stable

No updates made. Automatic rebuild with a platform release.

4.5

snapsmrc344

 
Latest
  • Resolved an issue with some Anaplan Snaps stopping on error even when an error view was enabled.
  • Improved error handling and output information to the Snaps in the Anaplan Snap Pack.
  • Support for Upload only operation in Anaplan Write Snap to upload a file to a server without running an import job.
  • Doc Enhancement: Examples added to Anaplan Snap documentation.

4.4.1


 
Latest

Anaplan Action Snap updated to include "resolution" in error output.

4.4


 
Latest

Resolved a "String index out of range" issue in the Anaplan Write Snap.

4.3.2


 
Latest
  • NEW! Anaplan Upload Snap
  • Anaplan Write now outputs more details to error view.
  • Resolved an issue in the Anaplan Read Snap where the suggested values for Export ID came back null.
  • Resolved an issue with the Anaplan Write Snap failing when writing to the error output view.
  • Resolved an issue with the Anaplan Action Snap not showing a list of the processes during Suggest.

4.3.1


 
Latest
  • Resolved an issue with Anaplan Write Snap's error handling in some cases producing inaccurate information.
  • Resolved null pointer exceptions in the Write Snap.
  • Server filename is now suggestible.
  • Migration impact: The output of the Write Snap is now a document instead of a string. Any pipelines using Anaplan Write along with a downstream Snap that is parsing the Anaplan Write output it will have to be reworked to use the new document map.
4.3
 
Latest

Migration Impact: The Anaplan Read Snap now writes the Anaplan file data read into the binary output view as a stream. This was done to resolve an issue with the Snap generating all column values into a single column.4.2.2


4.2.1


 
Latest
  • Resolved an issue with the Anaplan Write Snap skipping the first row.
  • Resolved an Anaplan Exception when writing from a database to Anaplan.
  • Resolved an issue with requests routing to error view but the file getting imported into Anaplan instance.
  • Migration Impact: The Anaplan Read Snap now writes the Anaplan file data read into the binary output view as a stream. This was done to resolve an issue with the Snap generating all column values into a single column.


June 2015 Latest

Anaplan action Snap should work for Anaplan processes as well.June 6, 2015 (2015.20)



March 2015

Latest

Anaplan accounts now work with Anaplan certificates



December 2014

Latest

NEW! Anaplan Action & Write



October 2014

Latest

NEW! Anaplan Read (Beta)