Designing and Running Pipelines

How to send output data as JSON from script snap

Hi, I am doing some transformation in script snap and some of the objects I want to send as is to downstream to store them as json in redshift, but when they are loading in redshift they are storing like {abc:234,pqr:[1,2,3]} i.e. they are not proper...

How to make a Pipeline wait during execution

This can be achieved using Python script for making a pipeline to wait in the flow during execution. Change the value in line number 22 in the script time.sleep(120) Here 120 is the seconds which defined to make the pipeline wait. Note: The value n...

Where clause in Oracle Merge Snap

Hello all, Is it possible to add a where clause the an oracle merge snap? Thank you! Jenny Nguyen

Managing Versions and Deploying Pipelines

Is there a best practice document or can someone provide an example of how you’re managing pipelines from development, through a test/QA phase and into Production? We have two orgs crated, one for dev/qa and one solely for production. I’m interested ...

Delete an asset via API

After retrieving a list of assets a user has created via the log API, I would like to make another API call to delete them. Is this possible using public or private APIs?

Stuck in Nested Array object Elements transformation

Hi, I have seen a discussion in this community about the difficulty in transforming nested XML Array elements. I don’t think that is limited to XML. I guess it is also for nested JSON Array object elements. Pardon me if my knowledge is limited and re...

XML Parser Error After Validation against XSD

Hi Team, I am reading an xml file and validating against xsd in the parser. I am getting below mentioned error even there is is correct data is present in the MarketCode element. “error”: “cvc-complex-type.2.4.a: Invalid content was found starting wi...

Unzip and read the file

My input file is zipped. Inside the zip file, there are 3 fixed width file. I have to unzip the file and read each file(one at a time) and load into table. The input file will be in S3. Can someone advise to handle this scenario Earlier when there wa...

SnapLogic - Integration Nation

Forum Posts

How to send output data as JSON from script snap

How to make a Pipeline wait during execution

Where clause in Oracle Merge Snap

Managing Versions and Deploying Pipelines

Delete an asset via API

Stuck in Nested Array object Elements transformation

XML Parser Error After Validation against XSD

Unzip and read the file

Change all Keys in JSON structure to lowercase

How to read .xlsb file

Append input data vertically

Difference between 2 dates

Find unmatched data using join

split target csv file into more smaller CSV's

How can I edit/update my community posts?

Http Client Snap vs REST Post snap

Parsing CSV file

Data Validator Pattern error