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.

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...

Salesforce.com account

When I try to create salesforce.com account, I am getting error “invalid_grant” on Validation. I tried with resetting the Security Token, but it does not work.

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

Dynamically process json files from sftp to snowflake

Salesforce.com account

What account should be used for API with query par...

How to dynamically update an account?

Execute each child pipeline multiple times

Routing files from S3

Clean duplicated lines in CSV datasource

How to get all values of a key from objects in a l...

The "Pipeline execute" is changing data types?

Remove XML duplicate key from JSON list in XML for...

Generating individual files based on 'n' records f...

Convert array with objects into object with key/va...