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?

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