Designing and Running Pipelines

NetSuite Attach Operation

We are building a pipeline where we create a vendor record in NetSuite using NetSuite Create Snap. We also have some attachments related to vendor that we would like to attach to the vendor when it is created in NetSuite using NetSuite Snaps. Based o...

How to remove / in the data extraction

Hi Team, can anyone help me how to remove / from the data. for some i am getting / for some i am getting data as expected

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

SnapLogic - Integration Nation

Forum Posts

NetSuite Attach Operation

How to remove / in the data extraction

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

Transpose columns(Dynamic) into rows.

Is migrating of REST Snap to Http Client still man...

Change all Keys in JSON structure to lowercase

How to read .xlsb file

Append input data vertically

Difference between 2 dates

Find unmatched data using join

split target csv file into more smaller CSV's

How can I edit/update my community posts?

Http Client Snap vs REST Post snap