Designing and Running Pipelines

How to add New Column data in to S3 Bucket

Hi, I have 3 Fields in S3 Bucket(eid,dname,dob) and SLDB Having 4 Fields( eid,dname,dob,ename). i have to load newly added Field data into S3 bucket. Thanks M SATHISH

Resolved! Join two arrays , one array with same unique ID

Hi, So I am trying to join two arrays, but one array contains multiple unique IDs and the other one not. Let me explain below: One array from sql select with these objects: { “personid”: 433817, “customernumber”: 10796670, “firstname”: “Jens”, “lastn...

Resolved! Selecting columns from the payload dynamically

Hi Team, I’m uncertain of the no. of columns in the payload that I would be receiving from upstream system, how can I ensure that I’m fetching all those columns dynamically? Rationale behind this is that I need to ingest this dynamic payload into a d...

HTTP Client Snap - How to replace/override Raw entity value for next iteration (pagination)

Hello, In Snaplogic I am connecting to Elasticsearch API 7.17 via Apikey using HTTP Client Snap to read aggregate data Below are the settings of the Snap Request Method: GET URI: https://elasticsearch-instance/_search Entity Type: raw Raw Entity: { ...

JSON input to a REST POST call failing

Hello All, I am trying to send a json document as input in the body of a REST POST call. The configuration of the REST Snap is in the image attached below. I am getting a 401 error, “REST API service endpoint returned error result: status code = 401,...

Resolved! Json object

I need help to get below output. [ { “key1”:“value1”, “key2”:“value2” }, { “key3”:“value3”, “key4”:“value4” } ] expected result { “item”: [ { “key1”:“value1”, “key2”:“value2” }, { “key3”:“value3”, “key4”:“value4” } ] } Thanks for your help.

How to automatically disable and enable Ultra task through api's

Hello, We have a requirement to automatically recycle ultra task threads on every day at a certain time. Are there any api’s to disable and enable ultra task ? or any alternative to recycle threads when ultra task is hung. Thank you in advance. Haris...

Resolved! Transforming JSON Output to Payload for Slack App

I have a pipeline that outputs a json file that I would like to reformat into a payload for a Slack webhook app. It’s for an outlist and the json output list a person’s fullName with startDate and endDate and duration for the absence. The payload wou...

SnapLogic - Integration Nation

Forum Posts

How to add New Column data in to S3 Bucket

Resolved! Join two arrays , one array with same unique ID

Resolved! Selecting columns from the payload dynamically

HTTP Client Snap - How to replace/override Raw entity value for next iteration (pagination)

JSON input to a REST POST call failing

Resolved! Json object

How to automatically disable and enable Ultra task through api's

Resolved! Transforming JSON Output to Payload for Slack App

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