Designing and Running Pipelines

Resolved! Date.Parse() Function

I have an incoming file that has a date value of 00:00.00.000 as a value. I am trying to set it to null. Comparing the exit_date ==‘00:00:00.000’ fails. Checking Date.parse($exit_date)==’ ’ or Date.parse($exit_date==null fails. Date.parse($exit_d...

Resolved! Get Pipe Run Time ID

When I’m trying to insert data into the Teradata table, I also want to insert the pipeline run time id into a column to log as an entry. Can anyone suggest a way to get the id into a mapper when the pipeline is executing?

Cannot format date correctly to YYYY-MM-DD

Hi there, I’ve looked at other articles addressing this but non has helped me so far. Im looking to format a date in the DD/MM/YYYY to YYYY-MM-DD. The date will always be populated. I’ve tried the following expressions but they wont process correctly...

XML not getting populated with all Data from Source

Hi, I have run into an interesting situation where my XML generator is not populating entire CSV file I reading. Basically, I am reading CSV file and trying to send that as one batch to SAGE Intacct using XML generator. but, in turn the XML generator...

Py Script snap

I am building a pipeline which need to make recurring API call and consolidate the result. But when I call the API inside py script snap then it does not return result as the API default result. I tried to use two methods of get as get.getResponseBo...

How to Insert All Records but if there's an error then insert none

Hello, If I have 3 records that I want to insert into my database table, I use the “SQL Server - Insert” snap. However, if there’s 1 record that has an error (like let’s say one of the values has text in an int column), the 2 other records still cont...

Getting index value from an array value

Wondering if someone could answer this question for me. Given the below array, how would I get the index number of $arrayField.name ===“Alex”? I can easily get the index of true and false by respectively doing this: $arrayField.indexOf(true) and $ar...

Is there a way we can parameterize repartition snap in SnapLogic Extreme?

Hi, We’ve have Extremeplex child pipeline that runs on Iterations. Based on user inputs we want to dynamically generate the no of Output files for each iteration, rather than specifying static value in Repartition Snap. I’ve also uploaded a snapshot ...

SnapLogic - Integration Nation

Forum Posts

Resolved! Date.Parse() Function

Resolved! Get Pipe Run Time ID

Cannot format date correctly to YYYY-MM-DD

XML not getting populated with all Data from Source

Py Script snap

How to Insert All Records but if there's an error then insert none

Getting index value from an array value

Is there a way we can parameterize repartition snap in SnapLogic Extreme?

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?