Designing and Running Pipelines

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

How to convert XML arry file to CSV

Hi all, I am getting xml file in array format which i want to conavert to the CSV formate. lease gud me here for same; my sml formalt is like : Name ROll Number CLass 0000000000 `

SnapLogic - Integration Nation

Forum Posts

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

How to convert XML arry file to CSV

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