Designing and Running Pipelines

Redshift queries with multiple create and 1 select

Hi All, Is it possible to run multiple create statement first to create multiple temp tables and select statement (redshift query) which has to then fetch columns from those temp tables and need to run in one session i tried executing using Redshift ...

String text in JSON output incorrectly using csv parser/formatter to csv

I’ve got the following text in a description field in my raw JSON file, where the double quotes are obviously escaped. How can I change settings in the JSON formatter and/or the CSV parser/formatter to fix this problem? The snaps are at their defau...

How to create an Ultra Task to expose my Pipeline as a REST API which uses No Authentication

Hi, I have created a Pipeline and an Ultra task for the pipeline. I read in Snaplogic Documentation that Ultra task supports - Token Auth and No Auth. I know, how to use Token Auth in Ultra Task by using the Bearer token which is auto-generated. But ...

How to format the lines and spaces coming as JSON

Hi All, I need some help with formatting the incoming JSON data eg. comments , which would have some lines and spaces. I want the spacing in the same way how it was posted

Permissions of a user/group

Hi, I have users grouped into groups and permissions to each of the project folders are assigned to groups. Is there a way to query the list of folders a user / group has access and the permissions they have? Best, Rajesh

Resolved! Maria DB Connection from Snaplogic

Hi Team, We are trying to establish connection to MariaDB. Has anyone used the configuration with JDBC connector and was successful. Thanks in advance. Best Regards, Vamsi

How to add data type

We have Json file as input source which some random data for that values we need to add datatypes. Sample data: { “Id”: “1076”, “jobTitle”: “Software engineer”, “firstName”: “David”, “lastName”: “villey”, “fullName”: “Davidvilley”, “email_N”: “Davidv...

Date Timestamp error while trying to use the "sql server update" snap?

Hi All, I’m trying to update the target sql server table using “sql server update” snap with the where condition “INSERTTS = $INSERTTS” (INSERTTS is the insert date timestamp) but I’m getting the error Failure: Type class org.joda.time.LocalDateTime...

SnapLogic - Integration Nation

Forum Posts

Redshift queries with multiple create and 1 select

String text in JSON output incorrectly using csv parser/formatter to csv

How to create an Ultra Task to expose my Pipeline as a REST API which uses No Authentication

How to format the lines and spaces coming as JSON

Permissions of a user/group

Resolved! Maria DB Connection from Snaplogic

How to add data type

Date Timestamp error while trying to use the "sql server update" snap?

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