Designing and Running Pipelines

How to fetch value from array?

Hello Team, I have the below array and I need to fetch the filename where active=1. Please can you help me on this. “array” : [ { “active”: 0, “fileName”: “test.pdf” }, { “active”: 1, “fileName”: “test1.pdf” } ] Thanks in advance!

Snaplogic supported for Oracle Autonomous Database (ADW) as a target?

Hi Experts, does Snaplogic support Oracle ADW (Autonomous Database) as a target? As per below link it is supported for 19c but no mention of ADW which is oracle DB on Cloud (OCI). https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages/1438106/Orac...

Invalid input data - Aggregate snap

I am building a pipeline that joins some data and then aggregate downstream. However, one of the fields that I am grouping by contains nulls and it gives me this error: Invalid input data. Failure: Invalid input data, Reason: Missing field in the inp...

Resolved! Custom Header for a CSV file

Hello All, I am looking for an approach to add a custom header before writing into a CSV file. I have referred the below link and developed one, but the issue is double quotes appended at the start and end of the content. So, when I open the CSV file...

Json conversion to new object

Hi All, Good morning, I have a requirement for converting json into xml with attributes. So, I understood in order to make the XML with attributes from json, I have to have below structure of json to be feed to xml formatter for final conversion. Req...

Data integration from SAP ECC to SQL server using Snaplogic

Dear Team, There is a requirement to integrate SAP ECC to SQL server (in cloud) to extract data from SAP standard extractors like 2LIS_11_VAITM using Snap logic?. Is this feasible with Snap logic?. Thanks for the inputs.

Resolved! Date.now() but with current timezone

Is there a way to get the current time in the snapplex’s timezone? (or could this be filed as important platform enhancement?) using date.now() returns the date in UTC, but i’d need it in “my” timezone (or in a random timezone, really). The closest i...

Dynamically process json files from sftp to snowflake

Hello everyone, I’m new to snapLogic and I have this business need to process json files everyday or even every hour from a SFTP server. The 1st difficulty: Files aren’t stored in the root folder, but in Year → Month → Day → Hour folders (so 4 subfol...

SnapLogic - Integration Nation

Forum Posts

How to fetch value from array?

Snaplogic supported for Oracle Autonomous Database (ADW) as a target?

Invalid input data - Aggregate snap

Resolved! Custom Header for a CSV file

Json conversion to new object

Data integration from SAP ECC to SQL server using Snaplogic

Resolved! Date.now() but with current timezone

Dynamically process json files from sftp to snowflake

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