Designing and Running Pipelines

TRIM spaces for DB2 select

Hi, we are migrating DB2 tables into AWS Aurora MySQL database. I am using Generic JDBC select SNAP to select the data from the DB2 database .we had an issue with data migration for the DB2 char fields . The Char fields selected from DB2 has the trai...

Resolved! Row to comma-separated conversion

Hi There, I need some help in converting the row-wise data to comma-separated. I provide sample data below. Here the values are combined together based on the unique cust_id. Thanks

Options for triggered task

Does anyone know of a way to trigger a pipeline task without sending the Authorization header? Can you pass the token in a parameter? What other options are there?

File Operation - Move gives error after file is moved

Hi, I am trying to use File Operation snap with Move operation to move file with Ground Plex. It works fine by functionality and moves the file.But it also fails with error that source file could not be found. Has anyone seen similar behavior ? Do I...

Merging two arrays and sending it via Email

Below are the input and the output of the data i require: INPUT [ { "group": [ { "Response": { "IT_DATA": [ { "LID": "LOA-1", "LVOL": 2150000.0, "LGM": 0.15, ...

How to restart a failed task using the public API

Hi, I’m going to design a pipeline that gets all the failed scheduled tasks information from this API " GET /runtime/{org}" and then restart the ones that are safe to restart (I have a list of pipelines that are safe to restart)! My first question is...

Is it possible to capture the name of the task that executed a pipeline at runtime?

We often send an email in our pipelines have certain errors, and we also have a lot of Tasks that drive the same pipeline(s) but with different params. So it would be very helpful if when could send the name of the Task that started a failed pipeline...

How to put string concatenation inside the JSON Generator snap body?

Hi Guys , My scenario is following : I need to pass the whole Json inside the JSON generator snap .I have checked the velocity documnets that concate works by just appending ,like $a$b will concate the content of $a and $b . But in this case it is no...

SnapLogic - Integration Nation

Forum Posts

TRIM spaces for DB2 select

Resolved! Row to comma-separated conversion

Options for triggered task

File Operation - Move gives error after file is moved

Merging two arrays and sending it via Email

How to restart a failed task using the public API

Is it possible to capture the name of the task that executed a pipeline at runtime?

How to put string concatenation inside the JSON Generator snap body?

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