Designing and Running Pipelines

Replace parts of string with values from array of objects

I need to replace portions of a string with values from an array of objects: Input String: $string1 = 'SELECT * FROM TABLE A WHERE COL1 = #1 AND COL1 = #2;' In the following example I need to replace #1 and #2 with their correlated value from the gi...

Can we pass the "pipe" object as a parameter to a child pipeline?

I’m using this for an error handler. The executing pipeline hits an error that sends it to the error pipeline. The error pipeline writes the details to a db table or flatfile. I was hoping I wouldn’t have to send all the pipe details as parameters i...

Howto delete pipeline version you no longer need?

I’ve got several pipelines where we created multiple pipeline versions, and now it would be problematic if someone reverted to an old version? How do you delete a prior version of a pipeline? Like if we created version 1 to 10, and only wanted to ke...

Howto: Fix windows node service that fail to start

There has been issues where GroundPlex nodes has failed to start on Windows hosts, usually connected to applied OS patches. It has not been consistent in it’s behavior as of when it fails nor has the trigger of the issue been identified. When the ser...

Remove unwanted characters from keys or column headings

I have a pipeline which reads zip files which contain csv files and loads the files into sql table. The zip files contain csv files with column headings which contain spaces, ()/ etc and I would like to remove these fromt he column headings dynamical...

Resolved! Batch Number From Group By N

Hi, I am building a pipeline where i am using Group by N. I would like to know if there is a way to get the batch number of each document. For example lets say i have 100 records in source and my group size is 10. Now this 100 records are divided int...

How to Enter Request body for OAuth2 POST Snap

Hello, In the Below Snapshot, I am trying to enter the Body Parameters for the REST POST snap for Oauth2 refresh token. I have all the necessary parameters stored as variables and pass them as below. I have the content type as “application/x-www-form...

Insert empty records of a file

This is my file while insering to table i expect it to have 6 records But it only inserts 4 records PIPELINE: Thanks in Advance

SnapLogic - Integration Nation

Forum Posts

Replace parts of string with values from array of objects

Can we pass the "pipe" object as a parameter to a child pipeline?

Howto delete pipeline version you no longer need?

Howto: Fix windows node service that fail to start

Remove unwanted characters from keys or column headings

Resolved! Batch Number From Group By N

How to Enter Request body for OAuth2 POST Snap

Insert empty records of a file

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

Converting a string to JSON doesn't work