Designing and Running Pipelines

Stopping pipeline execution when REST snap fails in pipeline

I have a pipeline that retrieve data from an external REST API, performs some data transformations and returns the resulting data. Part of the data transformations require looks that rely on the inbound payload so I have a copy snap to enable the loo...

Python Dictionary Conversion in Script Snap

Hello, I am trying to run a python script in the script snap that mocks up some test data for unit testing pipelines. The script relies on python data types such as list and dictionary to iterate through the incoming JSON document and manipulate it. ...

Looking for sample API pipeline

I’m tasked to build a pipeline for API service. This pipeline will accept API calls for GET/PUT/POST/DELETE to a database table. I am lost at how to get started. Please show me your example. Thank you

Standard python packages in the Script snap

Hi guys, Can anyone supply a list of the available python packages for usage via the Script snap? Thanks in advance - Igor

Oracle Stored Procedure Snap with DBMS_OUTPUT

Greetings, I have an Oracle stored procedure that produces DBMS_OUTPUT in the SQL server. How can I capture the output in the pipeline so that I can produce a CSV file from said output? Thanks.

How to Sort an Array Based on Key/Column name

Hi , I have an array which i want to sort it by the keys/column. { array1:[ { " Width":“4” " Length":“5 " " Item Desc”:"Black ", " Item ":"Pen " }, { "Width":"5" " Length":"7 " " Item Desc":"Blue ", " Item ":"Pen " , } ] } Output:- { ...

Group by N is not working in child pipeline

Hi , I have a requirement to combine the 4 JSON document into 1 document using the group by N snap. But group by N snap is not working as expected. Below are screen shot of pipeline.

How to Covert date in the JSON data

Hello, I am trying to work with the date (timestamp to be precise) and getting into trouble. My requirement is below. I have a stage table where the data is stored as JSON in a Variant Column and the data looks like below in that column. { “message_b...

SnapLogic - Integration Nation

Forum Posts

Stopping pipeline execution when REST snap fails in pipeline

Python Dictionary Conversion in Script Snap

Looking for sample API pipeline

Standard python packages in the Script snap

Oracle Stored Procedure Snap with DBMS_OUTPUT

How to Sort an Array Based on Key/Column name

Group by N is not working in child pipeline

How to Covert date in the JSON data

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

How to create timestamps and out put them only usi...

Do JSON mapping in a single mapper

Problem with nested mappings