Designing and Running Pipelines

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

Diff snap strange thing

Guys, a silly question, want to compare two data, One is like email, full_name, title, licenses, uid. One is like email, full_name, title. Sorted by email. When I check the modified output, found the user with same email, full_name and title, do you ...

SnapLogic - Integration Nation

Forum Posts

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

Diff snap strange thing

Send multiple files from file writer snap to http ...

Nest the document under another document

optional field on mapper

Help to parse Json data into csv

Updating Salesforce contact object and Account Loo...

Slicing Data from JSON

Connecting Confluent Kafka using OAuth

Hexadecimal to binary conversion

array.map if field1 meets criteria, I want field2

Filter Array data