Designing and Running Pipelines

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

Post EEO Data to Workday

I have an existing pipeline that posts an applicant’s job application data to Workday. This is basic information like the applicant’s first name, last name, address, and the job requisition id. I need to add EEO data (Equal Employment Opportunity) to...

SnapLogic - Integration Nation

Forum Posts

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

Post EEO Data to Workday

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