Designing and Running Pipelines

Expression Library: Start and end dates of previous month

The following expression library can be used to generate the start date and end date of the previous month in several formats. { // Convert the given Date-with-time object into a Date with only the year and month to_month_date: x => Date.UTC(...

Resolved! How to create multiple hierarchy sets in for API output

Hello, I am having issues structuring the API output i am working in. I have attached both the Source data and the JSON output structure expected in the attachment. I have attached the source file which is an extract of the SQL output. Typically my S...

Run a Informatica IDQ Mapping Task through SnapLogic

Can we call a Informatica IDQ job / Mapping task from SnapLogic? We are using Informatica IDQ to clean data based on business rules and want to incorporate kicking off the IDQ job through SnapLogic. We are trying to achieve the following, Write the d...

Is there a way to aggregate arrays from several objects in documents from the same source

I was asked to change a relatively complex pipeline in a few ways, and was trying to see if I coud do it without ANY scripting. I figured it might be possible, but I can’t figure out how to do the aggregation without a script object. Is there a way...

How to implement SCD type 2 in Oracle

I have seen snaps to implement SCD type 2 in Snowflake and Redshift but not for Oracle. How to implement SCD in Oracle ? Thanks

Triggered task showing wrong error message!

We have one pipeline which is used in a triggered task. But the problem here is we are concurrently hitting this task with some JSON data which is a valid JSON, and some of them are processed fine by the task and some of them failed with the followin...

HELP PLEASE - CSV Parser Advice Reading Delimiter In Data Fields

Good day SnapLogic Community I would greatly appreciate your help with the following. We have a cloud pipeline reading data from a REST service and returns the data in a comma delimited string. It send the data via a pipeline execute with label “Stor...

Pass a pipeline parameter to a SOQL

Is there a way to pass a pipeline parameter to a child pipeline which has a SOQL, and use that parameter in the SOQL? I am trying to output a date field from a parent pipeline and pass it into the SOQL which is a part of the child pipeline? Apprecia...

SnapLogic - Integration Nation

Forum Posts

Expression Library: Start and end dates of previous month

Resolved! How to create multiple hierarchy sets in for API output

Run a Informatica IDQ Mapping Task through SnapLogic

Is there a way to aggregate arrays from several objects in documents from the same source

How to implement SCD type 2 in Oracle

Triggered task showing wrong error message!

HELP PLEASE - CSV Parser Advice Reading Delimiter In Data Fields

Pass a pipeline parameter to a SOQL

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