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

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