Versions Compared

Old Version 34

changes.mady.by.user Kalpana Malladi

Saved on

compared with

New Version 35

changes.mady.by.user Subhajit Sengupta

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

In this Article

Table of Contents
maxLevel2
excludeOlder Versions|Additional Resources|Related Links|Related Information

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 Separator, Text Delimiter, Header 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

Note
  • 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

Note

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

Multiexcerpt include macro
nameTemporary Files
pageJoin

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 1438419 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 Separator, Text 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 

Multiexcerpt include macro
namedownload_instructions
pageOpenAPI

Attachments
patterns*.slp, *.zip

Insert excerpt
Anaplan Snap Pack
Anaplan Snap Pack
nopaneltrue