Designing and Running Pipelines

Handling timestamp in parquet file writer

Hi team, I am getting wrong data being written by the parquet writer for the timestamp data. please help as it is urgent. below is the output of mapper snap Below is the data created by parquet file when using int64 activity_ts (TIMESTAMP_MILLIS) B...

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

SnapLogic - Integration Nation

Forum Posts

Handling timestamp in parquet file writer

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?

Data Validator Pattern error

Deleting multiple files at once from SFTP folder

SQS -pipeline stalling

Best Approach for Handling CSV Import with Truncat...

Fetch dashboard/monitor details via a pipeline

mapValues returns null when adding certain conditi...

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