Designing and Running Pipelines

Change datatypes dynamically of every column

Hello everybody, Need help creating a pipeline. The data am working on looks like below: Header Datatype Data Data Data This is a CSV file so every column comes as a string. I want to create a pipeline which will look at the first row and change the...

Final Mapper response is generating [] to it

Hi All, I’m stuck with this small problem where I’m trying to send the response(received from Rest Post Snap) via mapper after extracting the required tags form the response but the final Mapper output is coming with hence the receiver system is not...

Resolved! How to write an expression?

Hi, I am using Directory Browser snap to try to do following with Expression Builder but I do not know how: Check if the files in a directory contains any of the following extension (.txt, .csv) If not give errorCheck if the filesize of each file is ...

JSON containers

I have a data set which is the following format: [ {“version_id”:“1660”}, {“version_id”:“1639”} ] and I would like to put the data into the following format; [ {“CurrentValues”: {“version_id”:“1660”}, {“version_id”:“1639”} } ] Any help would be much ...

How to extract pipeline details from asset search?

how to extract pipeline details from asset search and save in CSV? thanks

Discard empty rows while writing an excel file

I am trying to write an excel after comparing a database with salesforce data, I want to ignore the null rows after comparison is done in a mapper post Join. The data I am getting is perfect, only issue is with the way excel looks like. Please advis...

Sample for Mapper and Workday Writes that include multi instance fields and nodes

Does anyone have any samples or tips for mappers and using the Workday Write snap for Multi instance fields? In XSLT, we use apply-templates to copy this…but would like to see how this is done within SNAP. Thanks in advance Jeromy

Moving from Get response to post

Hi, I’m still relatively new to snaplogic but i’m really enjoying the learning process on it as I work through my assigned task. I’ve been able to build out a pipeline that: Starts with a csv file on a shared servermaps the required values to a REST ...

SnapLogic - Integration Nation

Forum Posts

Change datatypes dynamically of every column

Final Mapper response is generating [] to it

Resolved! How to write an expression?

JSON containers

How to extract pipeline details from asset search?

Discard empty rows while writing an excel file

Sample for Mapper and Workday Writes that include multi instance fields and nodes

Moving from Get response to post

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