Designing and Running Pipelines

Mapping in mapper from file

I have a requirement where i need to map 200 columns from source to target and source and targets names doesn’t match. Also window of mapper component is very small and it is very tedious to map in snap if columns are large. Is there a way that i can...

Rest PUT - Error when using upload files field

Hi everyone, I am able to upload incoming data into blob storage with the below pipeline but not the format I am expecting. I need to do it this way: Get Data ->CSV Formatter->File Writer-> Upload to SLDB → Rest PUT (use the file as an expression in...

Resolved! Cannot work out correct WHERE CLAUSE Expression

I have a Salesforce Read Snap and attempting to write a where clause that is dependent on a boolean field. This is my current expression: ' CUSTOM_FIELD__c = '+"'" + TRUE + "'" The error is as follows: Where Clause: TRUE is undefined. Perhaps you mea...

Resolved! Creating two tables in single mail

Can we create two separate tables in a single mail? Can anyone provide me the logic as to how it can be achieved?

Records not marrying up based on Email

I have a pipeline which is pulling data from 2 salesforce orgs. These data sets are then combined and matched based on the email address using a sort and join (left outer) snap. The end result is an upsert operation is in 1 of the orgs. When executed...

Resolved! Cumulative sum of a value in an array

Hi Everyone, I need help on an expression solution. The “sum” should be the sum of the value(s) of “key2” from previous records till the current record within the array. I’m trying to make it using the “reduce” function. Input: [ { "key1": "val...

Resolved! Group by fields with specific group size

Hello All, Is there a way we can use group by fields limited to a group size? Group by fields snap doesn’t let us specify a group size, so if we try to create groups based on a field, whether the occurrence of the field is 5 times or 500 times, outpu...

Resolved! Merge objects into first element of the group

Hello All, I have stumbled upon a scenario where we need to map all the elements within an array to the first element of the object or if we have to simplify the use case based on a certain field we have to merge all the elements together. The exampl...

SnapLogic - Integration Nation

Forum Posts

Mapping in mapper from file

Rest PUT - Error when using upload files field

Resolved! Cannot work out correct WHERE CLAUSE Expression

Resolved! Creating two tables in single mail

Records not marrying up based on Email

Resolved! Cumulative sum of a value in an array

Resolved! Group by fields with specific group size

Resolved! Merge objects into first element of the group

Transpose columns(Dynamic) into rows.

Is migrating of REST Snap to Http Client still man...

Change all Keys in JSON structure to lowercase

How to read .xlsb file

Append input data vertically

Difference between 2 dates

Find unmatched data using join

split target csv file into more smaller CSV's

How can I edit/update my community posts?

Http Client Snap vs REST Post snap