Designing and Running Pipelines

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

Anyone got SOAP execute for Salesforce working?

I am getting error: Failure: An exception occurred while executing the SOAP request, Reason: Could not send the SOAP request, Resolution: Verify that the template is correct, the substituted values are valid and the provided envelope matches the name...

SnapLogic - Integration Nation

Forum Posts

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

Anyone got SOAP execute for Salesforce working?

How can I edit/update my community posts?

Http Client Snap vs REST Post snap

Parsing CSV file

Data Validator Pattern error

Deleting multiple files at once from SFTP folder

SQS -pipeline stalling

Best Approach for Handling CSV Import with Truncat...

Fetch dashboard/monitor details via a pipeline

mapValues returns null when adding certain conditi...

What account should be used for API with query par...