Designing and Running Pipelines

Resolved! How can you sort the Input Schema fields after dragging onto mapper?

I have a quite large excel file (>150 columns) and need to sort the mapped fields precisely for target destination. I use File Reader > Excel Parser > Mapper… At the moment the fields run A, B,C…BX,BY…GZ. However after dragging the Input Schema field...

Mapper help required

Hi team, How can I dynamically generate the mapper output. scenario is Name id email yash 1 Y suresh 2 in above example email id null for id 2 so I need to create key value accordingly to send to rest api post for 1st row {“Name” : “yash”, “id”...

Matching of JSON object and Array List and filtering output of matched values

Hi, I have an Array List telling me the fields in which changes have occurred. In the eg. below, I want the fields in changes to be matched with fields in temp and provide output such that only the matched fields appear in output. Input: [ { "...

Google spreadsheets account redirect_uri?

Apparently we need to know the redirect_uri for setting up a google Outh account for reading a client’s google sheets. I have been unable to locate that information in the docs (or the community). The closest reasonable value I can find is for a diff...

Opening a WebSocket connection for an external application?

We’re working with a third party application which has a REST API to submit requests to retrieve data. The API is asynchronous in the sense that the response doesn’t actually contain the requested data, but contains a job ID and status on the submitt...

Resolved! Check if all values of array are equal

I need to find arrays where all values are equal. What’s the fastest way to do this? Should I loop through it and just compare values? ['a', 'a', 'a', 'a'] // true ['a', 'a', 'b', 'a'] // false

Resolved! Child pipeline is only processing the first document from Pipeline Execute

I’m using a sub pipeline to submit individual documents to a web service. This was working, but after some changes I am only seeing a single document processed to the service. I have the re-use box unchecked, and pool size set to 1. I have tested ea...

Missing NetSuite Object: Customer-Subsidiary Relationship

Hi Team, I am using token-based authentication and trying to use ‘NetSuite Upsert’ snap to Upsert an object called ‘Customer-Subsidiary Relationship’. As per the NetSuite Upsert documentation(https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages...

SnapLogic - Integration Nation

Forum Posts

Resolved! How can you sort the Input Schema fields after dragging onto mapper?

Mapper help required

Matching of JSON object and Array List and filtering output of matched values

Google spreadsheets account redirect_uri?

Opening a WebSocket connection for an external application?

Resolved! Check if all values of array are equal

Resolved! Child pipeline is only processing the first document from Pipeline Execute

Missing NetSuite Object: Customer-Subsidiary Relationship

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