Designing and Running Pipelines

Running multiple SQL statements from a JSON file

I am new to Snaplogic and seek advise from the experts here. I have a JSON file which has array sections for Truncate, Insert , Update and Select Update (where I have to select from one table and use the selected values to update in another staging t...

How do you know what is wrong

Hi, I wonder how many people have seen this when developing a pipeline

REST GET API + OAuth2 to call Microsoft Graph when no native Snap is available

Is there any specific documentation on how to call Micrsoft graph API’s using the REST GET snaps with an OAUTH2 Account. i have been trying to authorize the account and so far no luck with that. I keep getting “http_status_code”: 500 which is very ge...

Resolved! Azure MySql Database connection

While trying to connect to Azure MySql Database we are getting the following error: Failed to validate account: Failed to retrieve a database connection. Cause: The TCP/IP connection to the host port 3306 has failed. Error: "The driver received an un...

Excel columns to xml using paticular xsd

Hi All, I had parsed the excel sheets which is required and got the columns and rows need to convert to xml with xsd as shown below B & C are columns of one excel sheet after parsing pls could any one help how incoming data should be structured/fr...

Salesforce to Netsuite Integration Customer Payment Pipeline

Hi Guys, I’m trying to create a pipeline for Salesforce to Netsuite under Customer Payment object but I’m receiving this error: NetSuite Upsert[6229cd6941e91eb70ab295de_f05dc31f-cf24-44a8-bbd5-edce8bb8bae2 – 17235f10-139d-4e11-854c-0a96387c9b98] `com...

Resolved! Using Mapper to flatten my JSON with Array

I’m trying to flatten my object using a Mapper Snap before I export it to CSV. But I have been unable to map the fields coming in from the child records. Attached is a sample JSON file that represents my input. Script_output0.json (2.8 KB) I have tri...

Downloading files stored in Google Drive

Dear Community, I have a use case wherein I need to download a file from Google Drive. I followed this guide and the authorization is working fine: Connecting SaaS providers with SnapLogic's OAuth-enabled REST Snaps | SnapLogic Then, I configure RE...

SnapLogic - Integration Nation

Forum Posts

Running multiple SQL statements from a JSON file

How do you know what is wrong

REST GET API + OAuth2 to call Microsoft Graph when no native Snap is available

Resolved! Azure MySql Database connection

Excel columns to xml using paticular xsd

Salesforce to Netsuite Integration Customer Payment Pipeline

Resolved! Using Mapper to flatten my JSON with Array

Downloading files stored in Google Drive

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