Designing and Running Pipelines

Data transformation issue

Hello,I have a stored procedure that returns the following and i need that dataset transformed into the expected result. Thanks you for taking a look.Stored procedure result/input: [ { "RiskLevelCode": "High", "RiskLevelName": "High Risk", ...

Resolved! Issue using mapValues and mapKeys functions in Mapper Snap

I have data from salesforce that contain fields with a suffix of '__c' and the dates are formatted in UTC. I want to format the incoming data using the mapValue and the mapKey functions to remove the suffix and make all fields lower case AND format t...

do snaplogic mysql snap excute queries in multiple snaps in same session

I have one group_concat query that needs the group_concat_max_len to be increased to the higher values, we set it up in snap before and executed the query required in the connected snap just after it. will the group_concat_max_len apply to that query...

Create Excel files larger than 100MB

I need to create an Excel file which is larger than 100MB in file writer. I am receiving an error message in File Writer: Possible reasons can be failure in URL connection or file access denial, detail: SLDB does not support data larger than 100 MBI ...

Resolved! Connecting Confluent Kafka using OAuth

Hello AllWe have a use case to connect to Confluent Kafka only using OAuth. I guess SL Kafka connectors don't support OAuth. Can someone suggest if there is any other way to achieve this, apart from using Rest interfaces?Thanks

How to lookup against Google Directory email

So I have this scenario where before creating a new domain based email ID for new employees, the snap after generating the email ID has to check against the existing email IDs in Google directory and create the email ID if it is not a duplicate else ...

How to read cobol binary file

Input :צנקננפקננשנעעס –Pƒ\ @ @@@@ | ננץ@@@@@@@@@@@@@@@@@@@@@@@@@@@2 <נננננ@@@@@@@@@@@@@@@ @@@@@@@@@@@@@@@@0 yD\ @@@@סננסעע output:" 00000000000000000000000000000000000607.","0047026315"," 00000000000000000000000000000000000001."," 00000000000000000...

Unable to finish importing libraries

This is one of my child pipeline from my operation and in this, I'm having some issue when working with 1.5GB file(Operations - Read, Split, Validate, Write).1. Lost contact with Snapplex node while the pipeline was running Is this cloud rela...

SnapLogic - Integration Nation

Forum Posts

Data transformation issue

Resolved! Issue using mapValues and mapKeys functions in Mapper Snap

do snaplogic mysql snap excute queries in multiple snaps in same session

Create Excel files larger than 100MB

Resolved! Connecting Confluent Kafka using OAuth

How to lookup against Google Directory email

How to read cobol binary file

Unable to finish importing libraries

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

What account should be used for API with query par...