Designing and Running Pipelines

Snaplogic connect to MS-Access MDB database

You can use the JDBC snap to access the MS-Access MDB database by using 3rd party JDBC driver. The example here is using the JDBC driver from UCanAccess. Note that the JDBC driver will have no idea on how to access an SLDB:// location. The databas...

How to generate primary key column for each row in a document

Hi All , I wanted to load from csv to anaplan and need to generate a id column using sequence number . lets see if i have 100 rows in one document so , anaplan id column should be loaded through snaplogic with id as CS1,CS2,CS3 and so on and next tim...

Pipeline Execute Calling Many Time Instead Of Once

Good day Snaplogic Community I believe this might be a simple solution but I have a few pipelines in our test environment close to promotion to production and notice that one of pipeline executes i.e. “Process Transactions” in the pipeline below is b...

Extracting XML data

Hi, I have created a pipeline that issues a REST Post and it successfully executes. Unfortunately, I do not know how to format and parse the result. Below, I am trying to move the results into a table. This is my desired output is this. I have tr...

Expression Library: Database DateTime Conversion

The expressions for database datetime conversions listed in the topic SnapLogic DateTime Conversion Guidelines can be updated as follows to build an expression library: { /* * Database DateTime Conversions * Sample conversions between the SnapLo...

Expression Library: Start and end dates of previous month

The following expression library can be used to generate the start date and end date of the previous month in several formats. { // Convert the given Date-with-time object into a Date with only the year and month to_month_date: x => Date.UTC(...

Resolved! How to create multiple hierarchy sets in for API output

Hello, I am having issues structuring the API output i am working in. I have attached both the Source data and the JSON output structure expected in the attachment. I have attached the source file which is an extract of the SQL output. Typically my S...

Run a Informatica IDQ Mapping Task through SnapLogic

Can we call a Informatica IDQ job / Mapping task from SnapLogic? We are using Informatica IDQ to clean data based on business rules and want to incorporate kicking off the IDQ job through SnapLogic. We are trying to achieve the following, Write the d...

SnapLogic - Integration Nation

Forum Posts

Snaplogic connect to MS-Access MDB database

How to generate primary key column for each row in a document

Pipeline Execute Calling Many Time Instead Of Once

Extracting XML data

Expression Library: Database DateTime Conversion

Expression Library: Start and end dates of previous month

Resolved! How to create multiple hierarchy sets in for API output

Run a Informatica IDQ Mapping Task through SnapLogic

split target csv file into more smaller CSV's

How can I edit/update my community posts?

Http Client Snap vs REST Post snap

Parsing CSV file

Data Validator Pattern error

Deleting multiple files at once from SFTP folder

SQS -pipeline stalling

Best Approach for Handling CSV Import with Truncat...

Fetch dashboard/monitor details via a pipeline

mapValues returns null when adding certain conditi...