Designing and Running Pipelines

Problem: SQL Server table to CSV Pipeline -mis- translating BIT field to a true/false string value

Problem: SQL Server table to CSV file Pipeline -mis- translating BIT field to a true/false string value when writing to CSV. Hi folks, I’m dealing with a frustrating issue on Snaplogic: I need to go from a Sql server table from a db warehouse to a CS...

Number of input documents received is more than 0

Hi All, I have attached a pipeline here and I am running into an issue “Number of input documents received is more than 0” while running this pipeline. However, I can see the number of documents passed in only one after the router. Can you please sug...

Resolved! Fetch data whose date is less than 10hrs from the existing date!

Hi Team, I’m trying to achieve a filter condition but haven’t found any luck so far. My data has a field as Last_Updated which has date stored in the format 2022-06-23 03:54:45 I want to consider only those records whose date is less than 10 hours th...

Resolved! Get apim (APIs in SnapLogic) metadata

Hello, I’m using the snaplogic Read and SnapLogic list snap to get all the metadata of snaplogic (accounts, pipelines and tasks) but know I want to get the metadata also from the apim (accounts, tasks and pipelines from the APIs). For know I only cou...

Reading JSON Format

Hi, How I can use an expression to read the below in a mapper to get individual values true or false? I am using as - $DocumentId.startsWith(“EBSPERSON_”) [ { "Content_ID": "EBSPERSON_547229" } { "Content_ID": "EBSPERSONAD_547229" } { "Cont...

Mapper: map to target path only if input path is not null

I’m building a pipeline to update some existing data, and I have a Mapper mapping from source input fields to destination target fields. The input data is incomplete – i.e., there are a lot of fields that can be null on any given input document. Fo...

SQL Insert from JSON change type and only type

Hi All, I have a Pipeline that takes data from a Rest API and converts it to a SQL database. This is all working and we are able to create the table without having to define the Schema in a mapper (we have hundreds of tables with thousands of fields...

Read SOAP Execute Response content which is in CSV and write into a DB table

I am trying to read the SOAP CSV response in Binary form and write each record into a table. The SOAP response in encoded in Binary for as “content” in one big “string” data type I want to write them into a table by breaking that string into multiple...

SnapLogic - Integration Nation

Forum Posts

Problem: SQL Server table to CSV Pipeline -mis- translating BIT field to a true/false string value

Number of input documents received is more than 0

Resolved! Fetch data whose date is less than 10hrs from the existing date!

Resolved! Get apim (APIs in SnapLogic) metadata

Reading JSON Format

Mapper: map to target path only if input path is not null

SQL Insert from JSON change type and only type

Read SOAP Execute Response content which is in CSV and write into a DB table

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