Designing and Running Pipelines

Resolved! JSON data size fix

My source data has more than 1M record which is in a csv format. All those records had error , hence were routed to error view. Now , All those records needs to be logged in a S3 folder. Also i send an email to the team which contains the file name ...

Filename.replace(/^.*[\\\/]/, '') -: explain the expression

Hi can anyone make me understand the below expression. FileName.replace(/^.*[\/]/, ‘’)

Passing Parameter to OAuth2 Account

We are working on an integration here and we´re having problems while trying to pass parameters to an OAuth2 Account. We read an account with Client ID, Client Secret, Auth Endpoint and Token Endpoint already set. Then we map it, using metadata to ad...

Mapping the columns matching from the Array

Hello SnapLogic Experts, I require your help in mapping expression to map the keys(columns). I need to change the column names in the incoming data according to the mapping list that I have and load it into the database. I’m trying to achieve it usin...

Resolved! Retrieve the key value by passing another key value in json

My Json looks like this { “main” :[ { “CM”: “T”, “TM”: “” }, { “CM”: “100000”, “TM”: “9999” }, { “CM”: “200000”, “TM”: “” } ] } This is stored in an test.expr file. I have the CM values coming from the previous snap. What i would like to achieve is ...

SOAP Snap Issue

Hi, I am facing some challenges using the SOAP SNAP. The SOAP envelop is as below without any “legislativeDataGroupName” but when trying to validate the pipeline it always throws the error shown below. Could you suggest what could be the issue here? ...

How to set the execution user

I am deploying projects to QA and developer stacks so that they can have their own copies of projects for testing and developing. I’m using the SnapLogic metadata snaps to delete and create pipelines and tasks. I need the executions of these pipeline...

Resolved! Fetching 1k records from table using "Snowflake select snap"

I’m planning to fetch the data from a table using “Snowflake select snap” while putting the condition of getting 1k records ONLY in WHERE clause however it is not getting any results. I can put the entire query in “Snowflake execute snap” as well but...

SnapLogic - Integration Nation

Forum Posts

Resolved! JSON data size fix

Filename.replace(/^.*[\\\/]/, '') -: explain the expression

Passing Parameter to OAuth2 Account

Mapping the columns matching from the Array

Resolved! Retrieve the key value by passing another key value in json

SOAP Snap Issue

How to set the execution user

Resolved! Fetching 1k records from table using "Snowflake select snap"

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?