Designing and Running Pipelines

Create JSON from CSV file

Hi, I am new to snaplogic and want to create a JSON structure from a CSV file. CSV file data “Name”,“AddressLine1” “Test1234”,“122 Test St” The structure i need is very specific like: [ { “attributes”: { “Name”: [ { “value”: “Test1234” } ], “Addresse...

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

SnapLogic - Integration Nation

Forum Posts

Create JSON from CSV file

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

Transpose columns(Dynamic) into rows.

Is migrating of REST Snap to Http Client still man...

Change all Keys in JSON structure to lowercase

How to read .xlsb file

Append input data vertically

Difference between 2 dates

Find unmatched data using join

split target csv file into more smaller CSV's

How can I edit/update my community posts?

Http Client Snap vs REST Post snap