Designing and Running Pipelines

Read historical data in the first run

I have a pipeline that extracts data from Oracle table and write data to destination. Oracle select snap will read current day’s date based on a time field. When I am migrating this pipeline to PROD environment in the first run it should read entire ...

How to create folder in destination(or say here some application) using snaplogic rest api's?

Hello All, I was curious to know if there is a possibility to design a pipeline using rest API snaps to create a folder in the destination or some sort of application? Thanks, NJ

Create XML file for Card Transactions from Database Query

We need to create an XML file in Mastercard format for one of our custom cards from a database query that returns transactions with the card number, transaction amount, etc. Some of the header information will be static while the info. come from the ...

Resolved! Download all files from SFTP to a folder

Hi, I want to download all the files in a remote SFTP server to the Files folder. I think this is a pretty simple task but I am new, so I am not sure what to do. So I am thinking of using these 2 snaps but I have problem about the output file names....

Record Count in CSV

Is there an easier way to find the number of records in an incoming CSV? Want to log this information before processing the file. Appreciate the help but looking for a setting or simpler way to count the number.

Resolved! Using variable for file naming only and not in xml payload?

I’m formatting and writing an xml file, and would like to name the file based on a field value from the original file, but cannot be part of the xml. Is it possible to somehow bring a variable ($VAR) from a prior step in to the File Writer without i...

Correct way of restarting ultra pipelines

Hi, I’m writing to ask about the correct way to restart ultra pipelines. In our production environment we have 7 ultra tasks with 5 instances each. We went to the SnapLogic manager view and Disabled and Re-enabled all the tasks. In this case we sa...

What kind of snaplex is required?

I have an use case to extract data from on premise DB and load it to amazon Redshift. Using a cloudplex will I be able to access on premise DB and write it to redhsift? do I need to use two snaplexes ! (Groudnplex and Cloudplex)?

SnapLogic - Integration Nation

Forum Posts

Read historical data in the first run

How to create folder in destination(or say here some application) using snaplogic rest api's?

Create XML file for Card Transactions from Database Query

Resolved! Download all files from SFTP to a folder

Record Count in CSV

Resolved! Using variable for file naming only and not in xml payload?

Correct way of restarting ultra pipelines

What kind of snaplex is required?

What account should be used for API with query par...

How to dynamically update an account?

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...