Designing and Running Pipelines

Create xml segment only if condition is met

Hi, I am trying to convert xm1 into xml2. In order to that I have used XML Parser, Mapper,XML Formatter. There is one logic, I need to create a segment only if value of a particular repeatable segment is either jsonPath($, “$Z_RDGD102.IDOC.DKA1[].PAR...

Resolved! No schema available(Input Schema) for Mapper

Hi, Pipeline design is like below:- File Poller , file reader,XSLT, XML parser, mapper, XML Generator. In the XML parser and XML Generator, I have provided xsd but I am only getting output schema and not the input schema in Mapper. XML parser xsd is ...

Delete a folder

Is there any snap available to delete folder with 2 options? empty folderfolder with subfolder and files

To remove trailing zeros after decimal or adding trailing zeroes for camparison

hi there, I need to compare 2 values, example as below. either adding zeroes or removing zeroes. 44.5500 44.55 how can I achieve this? Thanks Manohar

Resolved! Need to convert yyyymmdd to yyyy-mm-dd

Hi, I have a element as:- jsonPath($, “$Z_ORD.IDOC.DK02[].DATE") and value is coming as 20210521(yyyymmdd). I need to convert it to 2021-05-21 and map it to target ml element. I am using mapper. Tried like below:- Date.parse(jsonPath($, "$Z_ORD.IDOC....

Blank pipe.ruuid returned from unbounded mapper

Hello All - In order to monitor our pipelines, I have placed a unbounded snap(mapper) at the start of the pipeline that “most of the time” returns the pipe.ruuid once the job kicks off. For some of our shorter jobs, I had to put a script at the start...

Record Count per file

Hi, I am reading multiple csv files from a SFTP location. I need to get the # of records per file, so I can put that info in a summary email. Any ideas on how I can retrieve the filename and # of records for each file? Thanks! Dawn

CSV data fields is greater than Header size

Hi Gooday, I tried reading a csv file from smb server through csv parser . The parser throws the error like “Error parsing at record 6478, content-The number of CSV data fields is greater than the number of header columns in the input data: number of...

SnapLogic - Integration Nation

Forum Posts

Create xml segment only if condition is met

Resolved! No schema available(Input Schema) for Mapper

Delete a folder

To remove trailing zeros after decimal or adding trailing zeroes for camparison

Resolved! Need to convert yyyymmdd to yyyy-mm-dd

Blank pipe.ruuid returned from unbounded mapper

Record Count per file

CSV data fields is greater than Header size

Best Approach for Handling CSV Import with Truncat...

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?