Designing and Running Pipelines

How to replace NULL value in Mapper

I have a file reader in my mapping. One of the column in the file contains NULL value. I am connection a mapper after the file reader. Is there any way to replace the NULL value with number? Tried using replace/replaceALL function but didn’t get the ...

How to obtain Unique records based on a column value not based on entire row values

Hi, I have a requirement where I need to obtain unique records based on a column.Unique snap doesn’t work here,as it looks on each unique record instead of a column for ex: My data looks like this e_no email country fi...

Get pipeline details for specfiied time

Hi All, I have been trying to use this query : GET https://elastic.snaplogic.com/api/1/rest/public/runtime/orgname?start=&end=> to get the pipeline summary for the specified time as per document of snaplogic, but i am not getting the results for the ...

Mapper autofill target path

Hi, Is there an easy way to populate all target path from the same name than variable as input (in expression)? This would be good instead of having to set them 1 by 1. Thanks,

Create Array from Flattened Docs

I could really use some help. I have flattened documents and for each distinct product-id value, I wish to create an array list of the variants that belong in the product-id’s family. My desired results should look something like this, but I’m not ...

Suppressing unwanted columns inside the Array

Hi, I have following json data. It has array of map with 3 different columns in it. Input: [{ “Phone”: [{ “Phone”: “3333333333”, “PhoneType”: “1”, “DonotCall”: “Y” }, { “Phone”: “1234567890”, “PhoneType”: “2”, “DonotCall”: “N” }] }] Expected Output: ...

Reading Custom Headers from a triggered Task

I have not been able to access any custom header parameter (not query or URI parameter) that I am posting to snaplogic after I setup a triggered task for a pipeline. I am able to get the JSON in the body successfully but havent been able to find a wa...

Batch Load Snap for calling RESTFUL API (HTTP GET)

Do we have Snap that can call RESTFUL API in batch of 50 or 100 @sinhavivek @kpatnala

SnapLogic - Integration Nation

Forum Posts

How to replace NULL value in Mapper

How to obtain Unique records based on a column value not based on entire row values

Get pipeline details for specfiied time

Mapper autofill target path

Create Array from Flattened Docs

Suppressing unwanted columns inside the Array

Reading Custom Headers from a triggered Task

Batch Load Snap for calling RESTFUL API (HTTP GET)

Send multiple files from file writer snap to http ...

Nest the document under another document

optional field on mapper

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