Designing and Running Pipelines

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

Repeat Target Path/ Header Name in a csv file

Hi, My CSV has headers which repeat themselves - BLANK2 , BLANK2, BLANK2 , NAME, BLANK2 Mapper gives me error saying that I can’t have same Target Path names. I tried adding header fields to CSV formatter and Binary Header, that didn’t work. I tried ...

SnapLogic - Integration Nation

Forum Posts

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

Repeat Target Path/ Header Name in a csv file

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