Designing and Running Pipelines

SFTP file reader for daily pulls

Hello All, We are going to start receiving delta files to a data warehouse and this is the format that our vendor specified that they will be sent over. Company_Data_Storage_TITLE_YYYYMMDD_HHMM_YYYYMMDD_HHMM.txt My question, in the file reader how wo...

File content in the email body

How to append the content of the S3 file (as-is) in the body of the email ?

CSV Parsing issue

As per documentation CSV parser settings Escape character says : Leave this property empty if no escape character is used in the input CSV data. However when escape character '' is present in the data it fails. Only if I add \ in escape character it ...

Variable/Parameter Value

I have a parent pipeline followed by 5 different child pipeline. One of the child pipeline dynamically generates a variable value. How can i pass the value generated in that child pipeline during runtime to another child pipeline. Kindly advise.

How to loop a Soap Execute Snap?

Hi All, I am working on one task to get the "Completed "response from one web service with Soap Execute Snap.But the background process may not compete and respond with “Processing”. So is there a way to loop this Snap until I got “Completed” respond...

Snaplogic connect to MS-Access MDB database

You can use the JDBC snap to access the MS-Access MDB database by using 3rd party JDBC driver. The example here is using the JDBC driver from UCanAccess. Note that the JDBC driver will have no idea on how to access an SLDB:// location. The databas...

How to generate primary key column for each row in a document

Hi All , I wanted to load from csv to anaplan and need to generate a id column using sequence number . lets see if i have 100 rows in one document so , anaplan id column should be loaded through snaplogic with id as CS1,CS2,CS3 and so on and next tim...

Pipeline Execute Calling Many Time Instead Of Once

Good day Snaplogic Community I believe this might be a simple solution but I have a few pipelines in our test environment close to promotion to production and notice that one of pipeline executes i.e. “Process Transactions” in the pipeline below is b...

SnapLogic - Integration Nation

Forum Posts

SFTP file reader for daily pulls

File content in the email body

CSV Parsing issue

Variable/Parameter Value

How to loop a Soap Execute Snap?

Snaplogic connect to MS-Access MDB database

How to generate primary key column for each row in a document

Pipeline Execute Calling Many Time Instead Of Once

Execute each child pipeline multiple times

Routing files from S3

Clean duplicated lines in CSV datasource

How to get all values of a key from objects in a l...

The "Pipeline execute" is changing data types?

Remove XML duplicate key from JSON list in XML for...

Generating individual files based on 'n' records f...

Convert array with objects into object with key/va...

Converting a string to JSON doesn't work

Rest Post for Multipart form type content type wit...