Designing and Running Pipelines

Unable to execute stored procedure (Redshift) using Redshift Execute

SQL: CALL get_result_set(1, ‘mycursor’); FETCH ALL FROM mycursor; Failure: SQL operation failed, Reason: A result was returned when none was expected., error code: 0, SQL state: 0100E, Resolution: Please check for valid Snap properties and input data...

Mapper target schemas went missing "No schema available."

I built a pipeline with a Mapper, and a SoapExecute. The mapper had a target schema upon validation, but now the schema is blank which also results in null values in the resulting soap. I have tried moving the snaps around, adding a copy, removing ...

Resolved! Snaps to copy data to Google Storage

I have a requirement to move/copy many files (1000s of files) to Google Storage. I did some reading in SnapLogic documentation and saw that we might have to use “Google BigQuery Bulk Load (Cloud Storage)” for this. Is this correct understanding? Any...

How to keep first row in a set?

I have a requirement where I need to capture the first record with a given field needs to pass through and all subsequent records with that field value are stripped and written to a different file. In the example below, only the first row for each ID...

Deployment of pipelines to different Orgs

Hi Team, I need to deploy a pipeline to two different Orgs and the account configurations differs for each Org. I would like to pass the account credentials dynamically to the pipeline but I can see that the accounts for Rest and Soap snap pack does ...

Oracle update snap update condition giving error

Hi Team, In above expression i tried to update oracle table using oracle update snap on date condition column and facing above timestamp error. in target data in date datatype and format mm/dd/yyyy

How to pass parameters from JSON to Rest POST snap

Hi All, I am trying to send the following JSON values to Rest POST snap. In the JSON the first element is the body to POST and second element is token. Can someone suggest me how can i handle this. Thanks in advance. Following is my JSON document. [ ...

Days manipulation in Mappers

Hi all, I am facing now an issue manipulating the Dates in expressions. I am trying to generate, within a mapper: Get the date of first day of previous month (eg: for now : 01/11/2019)Get the date of last day of the previous month (eg: for now: 30/11...

SnapLogic - Integration Nation

Forum Posts

Unable to execute stored procedure (Redshift) using Redshift Execute

Mapper target schemas went missing "No schema available."

Resolved! Snaps to copy data to Google Storage

How to keep first row in a set?

Deployment of pipelines to different Orgs

Oracle update snap update condition giving error

How to pass parameters from JSON to Rest POST snap

Days manipulation in Mappers

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