Designing and Running Pipelines

Append/Merge input fields into single field

I have list of fields with name like, amount_1amount_2amount_3amount_4… I need to map all the amount fields value into amount column in target. Example: Note: the fields is dynamic we can get “n” number of fields. Looking forward any inputs/suggest...

Resolved! BUG OR ERROR : Date UTC Method

Hi All, I am using Date.UTC() method to generate last month date & using below syntax which seems to be fine. Date.UTC(Date.now().minusMonths(1).getFullYear(),Date.now().minusMonths(1).getMonth(),0) And output preview is also fine. But while I am ...

Constraints of SnapLogic

Hi Team, Can you please provide the below information. Bulk Batch Load (File from Blob Storage) Max (XML canonical) file size could be ingested by SnapLogic at one timeMax number of records could be ingested by SnapLogic at one timeFile reading speed...

POST to a Salesforce REST endpoint using Basic Auth

Looking for best practices around using Basic Auth for making calls to a custom Salesforce REST class/method. Understand that there are solutions using oAuth through SFDC App registration and obtaining the client id/secret, but wondering if there we...

Create Custom API - JSON document as POST body

Hi - Does anyone have an example how to create a custom API which receives a JSON body in a POST. Also, how to do you specify a POST vs GET in the task? I found a couple examples but most use parameters which I want to avoid. Any help is appreciated....

Converting from String type XML to XML

Hi Team, I have a requirement to convert a string type xml to xml type. is there any way to do it? for example Input string : “<?xml version=“1.0”?> <ItemMasterSupplementRetailPro> <Affiliate>1190</Affiliate>” Output should be of type xml. Thanks and...

Expression Language - List of Elements

Hi Team, I am getting list of values for each CurrencyCode, But my requirement is to place single value for single field. (1001 for first record, 1002 for second one). Please find my Expression code in the above image. Can you please provide correct...

Expression Language - Array

Hi Team, I have below xml file. <Users> <User Id='N101'> <ContactList> <Contact> <Name>Jhon</Name> <City>New York</City> <PhoneNumber>123456</PhoneNumber> </Contact> <...

SnapLogic - Integration Nation

Forum Posts

Append/Merge input fields into single field

Resolved! BUG OR ERROR : Date UTC Method

Constraints of SnapLogic

POST to a Salesforce REST endpoint using Basic Auth

Create Custom API - JSON document as POST body

Converting from String type XML to XML

Expression Language - List of Elements

Expression Language - Array

Get MIN (oldest) or MAX (most recent) date from ar...

Line Break in Mapper

how to filter out spaces

Expression to extract values in nested JSON object...

groupby field and count

IF Statement in Expressions Library file

Create Expression Library from Excel data

Can't paginate using Post HTTP CLIENT Snap

How to formulate expresssion

Creating unique ID's and repeating