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

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

How to dynamically update an account?

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