Designing and Running Pipelines

How to read packed data from Mainframes Files

Hi All, I need suggestions on how to build a pipeline using SnapLogic where, the files are coming from Mainframe PC’s as a packed data. The following information I have, Host address, UserId & Password, Filename, Copybook layout. Which snaps should b...

Question about "Trust All Certificates" Option in REST GET Snap

Hi, Please forgive my ignorance in this subject matter, but I have created a few basic APIs in the APIM from existing pipelines. When I try to call them using a groundplex secure URL in a REST GET snap, the only way I can get a successful call is to ...

How to get max element of array and its corresponding index

How can we get the max element of the array with its corresponding index? Ex : “somefield” : [1,2,2,2,2,1,1,1,1] Max element is 2 and indexes are 1,2,3,4

How To Generate Rank with Partitions

Hi I need to generate the rank for the below data where data should be partitioned by No and Date order by value and want to get the top 3 ranked categories for each No and each Month. Input : No Category Date Value Rank 1 Dog 01-01-2022...

Replace a full word that starts with certain characters

Hi, I am trying to replace the words that starts with ‘Auft’ because somehow it changes the next two characters by �� Image Below: I’m not a professional in regex expressions so I am trying to learn it but I can’t come up with the solution. I always...

How to log request and response for a pipeline which has Rest api post and get calls?

I have a pipeline where i make a REST api call . I want to log the request body and the response body everytime the pipeline executes.How can this be achieved.Kindly help in this regard.

Resolved! API responses not working

Hello, So I created an API specification with these error responses. ‘400’: description: Bad request. ID must be an integer ‘401’: description: Authorization information is missing or invalid headers: {} content: {} ‘404’: description: Not found ‘50...

Length in using expression

Hi, I have a scenario where I need to filter out json based on length of a particular element. so in Source if json is like this:- [ { “SaleDatas”: { “DataId”: “”, “AmazonDataId”: “Sale.purchase_4”, “AmazonDataName”: “”, “Name”: “Sale.purchase_4”, “D...

SnapLogic - Integration Nation

Forum Posts

How to read packed data from Mainframes Files

Question about "Trust All Certificates" Option in REST GET Snap

How to get max element of array and its corresponding index

How To Generate Rank with Partitions

Replace a full word that starts with certain characters

How to log request and response for a pipeline which has Rest api post and get calls?

Resolved! API responses not working

Length in using expression

Help to parse Json data into csv

Updating Salesforce contact object and Account Loo...

Slicing Data from JSON

Connecting Confluent Kafka using OAuth

Hexadecimal to binary conversion

array.map if field1 meets criteria, I want field2

Filter Array data

How to create timestamps and out put them only usi...

Do JSON mapping in a single mapper

Problem with nested mappings