Designing and Running Pipelines

Resolved! Dynamic records generation

Hi, I want to generate dynamically n records, based on column value. Lets say based Number_Streams , I want to create n records having same values for other columns, except the name. In name column I want to append alphabets dynamically. Sample Input...

Is there a way to extract data from db which is accessible over telent?

Is there a way to extract data from some old db which is accessible over telent?

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

SnapLogic - Integration Nation

Forum Posts

Resolved! Dynamic records generation

Is there a way to extract data from db which is accessible over telent?

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

Nest the document under another document

optional field on mapper

Help to parse Json data into csv

Updating Salesforce contact object and Account Loo...

Slicing Data from JSON

Connecting Confluent Kafka using OAuth

Hexadecimal to binary conversion

array.map if field1 meets criteria, I want field2

Filter Array data

How to create timestamps and out put them only usi...