Designing and Running Pipelines

Get unique original input file name before file delete

Hi, I have a requirement where I need to split batch input xml and process it and at the end delete the input batch xml from the directory. Everything is working but at the end since it is creating multiple xml and I do a join to get original input x...

Reading BLOB data from SQL and write it to file share

Dear Community, I am successful in creating a pipeline that read blob data from SQL server and writing the file in SLDB. Now, I wanted to write the file on an SFTP server using File Writer - validation is okay but failed during execution. protocol: ...

Time format Conversion changing the date

I am doing date conversion. But not sure why it is changing the date. Input Date is : “29-JUN-21 10.07.35.000000 AM” Output date is becoming :“2020-12-27 10:07:35” The conversion I am using is : Date.parse($OrderDetailCreateDate,“dd-MMM-YY hh.mm.ss....

Resolved! Snaplogic Redshift Copy Command

Hi Team, When I read data from a file/csv and do a bulk load, into redshift I know that at the backend it’s trying to copy the data and tries to do the bulk load. Here…I need to know what was the full set of options the Snaplogic code used for the Re...

Unable to connect to SnapLogic MySQL to AWS MySQL instance but able to connect to that instance in AWS environment

Hi Team, When tried to connect to mySQL select in Snaplogic with instance in AWS account getting below mentioned error. Failed to validate account: Failed to retrieve a database connection. Cause: Communications link failure The last packet sent succ...

Read File Name from SFTP

Hello , How can we capture the name of the file picked up from the SFTP if we are reading multiple files at a time? I dont want to use child pipeline but want to capture file name to be used at very end to pass onto email snap? Thank you in advance!!

SCD 2 in snaplogic with snowflake as target table

hi team, would like to implement scd type 2 in snaplogic and target dw is snowflake table. scenario : 1) Need to select sample txt / json file from local drive 2) process file into snowflake table 3) what are the snaps and how it links in pipeline ...

Data not passing through Salesforce Create Snap

I am trying to build part of a pipeline here which checks salesforce to see if a reqestor (contact) is created. If it is not in Salesforce, it routes to a branch to create the contact. I then want this new contact id inserted back into the pipeline f...

SnapLogic - Integration Nation

Forum Posts

Get unique original input file name before file delete

Reading BLOB data from SQL and write it to file share

Time format Conversion changing the date

Resolved! Snaplogic Redshift Copy Command

Unable to connect to SnapLogic MySQL to AWS MySQL instance but able to connect to that instance in AWS environment

Read File Name from SFTP

SCD 2 in snaplogic with snowflake as target table

Data not passing through Salesforce Create Snap

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