Designing and Running Pipelines

Resolved! How to get few fields as separate rows in target in a same file

I have Record Identifier, Name, Record Identifier 1, Value coming from input. I want Record identifier and name needs to be written in Row 1 and Record Identifier 1 and Value needs to be written in Row 2. Like as below example. Any idea on how to ach...

Not returning output documents in Rest Pipeline

I’m currently exploring ways of building pipelines as a REST service using the training video, ‘Retrieving Documents Using REST GET’. When validated, the pipeline appears successful but its not showing me the desired data in the output preview connec...

Get problem using SQL Server Delete, delete successful but only first row completed

I build pipeline with json generator to build table list row. Then, SQL Server Delete snap use table name from each row to be executed. I tried validation. the result is success for each row. But only first row return number of record deleted. Other ...

Table Asset Schema for Data Catalog Snap

I wanted to create Data Catalog using Data Catalog snap, simple pipeline which generate the partition value and some custom Meta Data Now how to connect with Table schema as shown in the image below How to connect my Data Catalog output to Table ...

Resolved! Count number of records fetched/processed from a flat file/upstream system systems (snowflake, salesforce, oracle)/file writer without using a pipeline execute

Hi Team, I’m looking to count records on a couple of scenarios listed below: (1) Records fetched from a flat file (e.g. excel, csv) and writing the total counts of records into a new column e.g. File Reader --> Mapper (transformation rules here with ...

Resolved! Error management on JMS Consumer

Hello everyone, We are currently trying to improve our pipelines by adding error paths and are having problems with the JMS Consumer snap. Unlike other snaps, like the SQL Server snaps, where a connection failure is routed to the error path, a connec...

Resolved! Public API Basic Authentication

The SnapLogic public API uses basic authentication. How do I get the basic authentication token outside of SnapLogic? Is there an auth endpoint? How long is the token good for?

Generating wrong Json format for empty values

Hi All, I am creating a Json file by using the Json formatter but I am not getting the json in correct format for all the empty values. Below is the input for Json Formatter : Getting below output from Json Formatter. The output should look like be...

SnapLogic - Integration Nation

Forum Posts

Resolved! How to get few fields as separate rows in target in a same file

Not returning output documents in Rest Pipeline

Get problem using SQL Server Delete, delete successful but only first row completed

Table Asset Schema for Data Catalog Snap

Resolved! Count number of records fetched/processed from a flat file/upstream system systems (snowflake, salesforce, oracle)/file writer without using a pipeline execute

Resolved! Error management on JMS Consumer

Resolved! Public API Basic Authentication

Generating wrong Json format for empty values

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

Converting a string to JSON doesn't work

Rest Post for Multipart form type content type wit...