Designing and Running Pipelines

File Operation snap question

I want to do the file compare (DIFF) on two files but the name changes every day with a new date. On my File Reader snap, I have put the file names in like this “smb://xxxxxx.com/us_data/Shared/MM365/Clients/Small Market/Reporting/Non-Standard_Report...

Map input array issue

array mapping in mapper My json: “Employee”: [ { “name”: “Tom Cruise”, “name”: “Robert Downey Jr.” } ] I need Output { “item”: [ { “name”: “Tom Cruise”, “age”: 50, }, { “name”: “Robert Downey Jr.”, “age”: 50, } ] } Could you please help. Age is const...

LF's in CSV to result in a Multi-Line Cell in Excel

Could use some advice here. I am trying to take a string of data (a group of key/value pairs) that is comma delimited and insert it into a single Excel cell so that it shows as multiple lines within the cell. For example, I have a data string that lo...

Upload to sftp snap

I need to begin uploading files to an sftp site. I assume I must set up the account somehow in file writer. Can you advise on how to do that? I have looked at the doc but i dont know what the words mean. i have a site and a password–sometimes i will ...

Resolved! Ending document stream for some paths

Hello everyone, I have the need to let some stream paths end in “nothing”. Essentially I have a bunch of diff outputs that I will ignore, but eventually I will have to reduce the entire pipeline to a single output since it will be a triggered task. ...

Remove backslash in json response

Hello, I need help to remove backslashes from json SOAP response below. [{"id":"500001130581","workType":"test","total":7.000}] I tried replace function, but it is not working, Can someone help? -Thanks

Passing the expression as parameter

Hi Good day, Would like to check how to specify an expression statement as a parameter in the mapper. I identified specifying the expression directly in the mapper which evaluates to the boolean value depending on the evaluation but the same can not ...

Resolved! Reusable pipeline- Unable to fetch variable value in child pipeline -Snowflake Snap

Usecase- We are looking at creating a reusable pipeline to load data from table1 from source DB to table1 in target DB. Plan is to reuse the same pipeline for n tables. Option 1 - Created master pipeline and child pipeline. Master pipeline gets tabl...

SnapLogic - Integration Nation

Forum Posts

File Operation snap question

Map input array issue

LF's in CSV to result in a Multi-Line Cell in Excel

Upload to sftp snap

Resolved! Ending document stream for some paths

Remove backslash in json response

Passing the expression as parameter

Resolved! Reusable pipeline- Unable to fetch variable value in child pipeline -Snowflake Snap

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