Designing and Running Pipelines

Resolved! Ingesting multiple AWS S3 files into a database

I have a Amazon S3 bucket containing multiple files that I’d like to extract and read into a database. The files are all .GZ (gzip) files. The file names will change each day but will all have the same format/contents once unzipped. I was thinking ...

Illegal character due to | symbol

Hi Team, We are facing issues in the salesforce upsert snap while using External Id for the operation. The external Id is of the format “TH10-2023|0100044213|000086|3010” So the snap interprets the ‘|’ as logical AND and throws the error. Is there an...

Replacing many special characters using one function one time

Hi All, I want to replace the following special characters : > % ? \ with space . I do not want to use multiple replace function. Is it possible to do with one replace function. Thanks for your time.

How to connect a feedmast to a JCC Node

Hello, I am running a Feedmaster node now. While I try to execute a pipeline pointing to Feedmaster node, it gvies me an error - no “cc” node found. Could you please guide, where in Feedmaster I need to configure, the JCC nodes who will handle my pip...

File Size Differences

Hi, Why File Reader and File Writer size variation in the Pipeline? I have make a simple pipeline to check my reader output file size and writer output file size and I have observed that reader and writer output size us not matching. Could anyone pl...

Resolved! Route the Pipeline based on the location (Cell range) of a Column in the Source excel file

We have two different version of Source file in one version the CashInvoicePaymentTerm table is available on Cell 88-B as shown in the below screen shot. Again, in another version the CashInvoicePaymentTerm table is available on Cell 117-B as shown ...

Check if the element in the array is empty or not

[ { “test”: [ { “group1”: “”, “id”: 1 }, { “group1”: “test”, “id”: 2 } ] } ] How can i check if group1 is empty or not?

Fields are auto appended at the end

Hi Good day, I am stuck at an issue where I happened to find there is an extra string getting appended at the end of the field name. We are filtering the Japanese field name based on certain conditions. I am processing the field name (バイオの選択) While p...

SnapLogic - Integration Nation

Forum Posts

Resolved! Ingesting multiple AWS S3 files into a database

Illegal character due to | symbol

Replacing many special characters using one function one time

How to connect a feedmast to a JCC Node

File Size Differences

Resolved! Route the Pipeline based on the location (Cell range) of a Column in the Source excel file

Check if the element in the array is empty or not

Fields are auto appended at the end

Fetch dashboard/monitor details via a pipeline

mapValues returns null when adding certain conditi...

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