Versions Compared

Key

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

On In this PageArticle

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

Snap type:

Write

Description:

This Snap is used to upload

Overview

You can use the Anaplan Upload Snap to upload binary files to Anaplan models.

Text

 Text encoding will be UTF-8

.Expected upstream Snaps: Snap

.

Image Added

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.

  • Expected downstream Snaps: [None].
  • Expected input: Binary

    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.
    Expected output A
    OutputDocument
    • Min:0
    • Max:1
    N/A

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

    . Prerequisites:

    None.

    Support and limitations:Works in Ultra Task Pipelines

    .

    Account:

     

    This Snap uses account references created on the Accounts page of SnapLogic Manager to handle access to this endpoint. See Anaplan Account for information on setting up this type of account.

    Views:
    InputThis Snap has exactly one binary input view.
    OutputThis Snap has at most one document output view.
    ErrorThis Snap has at most one binary error view and produces binaries in the view.

    Settings

    Label*

    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

    check box

    checkbox to overwrite the Anaplan server file. Else, an error

    occurs

    is displayed if the file with the same name already exists.

    Default value: Selected

    Override server settingsN/A

    Select this

    check box

    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

    the Multiexcerpt include macronameExecution_Detail_WritepageSOAP

    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

    Multiexcerpt include macro
    nameSnap Execution
    pageSOAP Execute

    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 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 gives gets the details of the uploaded file: 

     

    Download the Pipeline.

    Attachments
    patterns*.slp, *.zip

    Excerpt Include
    Anaplan Snap Pack
    Anaplan Snap Pack
    nopaneltrue