Designing and Running Pipelines

SQL Server Merge Snap - Issues with Date as Null

Hi, I have developed the pipeline which reads the data from the incoming stream and send to SQL Merge. My pipeline looks like below. My Input JSON is as follows: [ { “member_id”: 13000561, “intervention_id”: 1000034495, “sentiment”: null, “last_upd...

Insert error with JDBC insert and PGSQL

I have a pipeline that reads from Oracle and writes to PGSQL. When inserting to PGSQL, I get this error Batch entry 0 insert into “pg_temp”.“crmi002b_ut_pprs001” (“end_date”, “opportunity_type”, “sales_person”, “opportunity_status_type”, “sr_partitio...

Ultra Pipeline URL Can't Be Reached; Request Times Out

I have created a pipeline that runs while using a triggered task but when I re-create the same pipeline but with using an ultra task I am unable to reach the HTTP endpoint due to timeout. My pipeline starts with an XML formatter, as the content of my...

Creating a Nested Json for a REST API Post Request

I am running into a very weird issue. Big Picture - doing a bunch of operations but finally have to make a REST API call {"field1": "random_values", "field2": [ { "field5": "451037", "field6": "d1"} ], "field3": "test", "field4": "True" } I have ...

Snaplex Node Freezing with High Memory

One of our SL Nodes freezes on high memory and won’t start any new pipelines or accept any webhooks. The only way we’ve found to fix this is a manual reboot. Memory will be going between 70-85%, and CPU between 10-60%… everything will be working fine...

Count of written Documents

Hello All, I’m trying to get the count of files written by the File Writer Snap and want to write the number into a mapper. If it’s possible can anyone suggest me how to achieve this? Thanks

Resolved! In-memory lookup workaround

Hello all, I faced with issue with in-memory lookup. According to snaplogic documentation, [https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages/1439008/In-Memory+Lookup] it does not supported structured JSON path like '$customer.address. It can...

Resolved! ZipFile Writer - Subdirectory Support

I would like to store a large number of files into a single compressed zip file and in order to help with organization I would like to group the files into nested subdirectories. I have paired a Document To Binary Snap with a ZipFile Writer Snap and ...

SnapLogic - Integration Nation

Forum Posts

SQL Server Merge Snap - Issues with Date as Null

Insert error with JDBC insert and PGSQL

Ultra Pipeline URL Can't Be Reached; Request Times Out

Creating a Nested Json for a REST API Post Request

Snaplex Node Freezing with High Memory

Count of written Documents

Resolved! In-memory lookup workaround

Resolved! ZipFile Writer - Subdirectory Support

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