Designing and Running Pipelines

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

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

SnapLogic - Integration Nation

Forum Posts

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

Triggered task showing wrong error message!

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