Designing and Running Pipelines

MySQL Insert Can't Insert Special Characters

Is there any way to encode strings or perform a MySQL insert on a special character like ł or Ł. I can’t get it working, but it works just fine using another ETL process. In my specific use case I’m trying to insert names that include special charact...

Converting String to Bigint

Good day SnapLogic Community Is there a function that accepts a string and converts it to a BigInt? An equivalent SQL statement is below, CAST(DRIVERPERMIT AS BIGINT) = 0 Thank you very much in advance, Andre

Mermory Utilization of Specific pipeline

I have a requirement of calculating total memory that it consumed by a specific pipeline during it’s run time. Can we use Public API with RuntimeId of that pipeline to figure out the utilization of total memory for a specific pipeline. Thanks!!

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

SnapLogic - Integration Nation

Forum Posts

MySQL Insert Can't Insert Special Characters

Converting String to Bigint

Mermory Utilization of Specific pipeline

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

Generating individual files based on 'n' records f...

Convert array with objects into object with key/va...

Converting a string to JSON doesn't work

Rest Post for Multipart form type content type wit...

Best way to perform multiple search and replace in...

Obtain Rest API curl to run in postman directly

CSV parser cannot parse data

Parsing XML using a Python script returns an encod...

multiple array objects

String replace method where pattern is dynamic