Designing and Running Pipelines

Pipeline Execute Calling Many Time Instead Of Once

Good day Snaplogic Community I believe this might be a simple solution but I have a few pipelines in our test environment close to promotion to production and notice that one of pipeline executes i.e. “Process Transactions” in the pipeline below is b...

Extracting XML data

Hi, I have created a pipeline that issues a REST Post and it successfully executes. Unfortunately, I do not know how to format and parse the result. Below, I am trying to move the results into a table. This is my desired output is this. I have tr...

Expression Library: Database DateTime Conversion

The expressions for database datetime conversions listed in the topic SnapLogic DateTime Conversion Guidelines can be updated as follows to build an expression library: { /* * Database DateTime Conversions * Sample conversions between the SnapLo...

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

SnapLogic - Integration Nation

Forum Posts

Pipeline Execute Calling Many Time Instead Of Once

Extracting XML data

Expression Library: Database DateTime Conversion

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

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

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