Designing and Running Pipelines

Designing a pipeline to route depending if there is or is not data in an initial query

Hi, I am trying to design a pipeline where it initially will pull in a query result set. I am trying to create a route that identifies whether the query result set returned records or did not return records. Any idea on how to design this pipeline?

How to create zip with multiple xml file

Hello Experts, I’m trying to create zip file which will have 2-3 xml file. for eg abc.zip zip file will contain a.xml,b.xml,c.xml. b.xml,c.xml are constants file that i have to add to abc.zip file. a.xml is created through snaplogic pipeline. Regards...

Filter and Edit a JSON with a touch of data manipulation

Hi, I need to amend some data for a specific table flowing through one of my pipelines This specific json contains multiple values for example: L_TYPE “A” L_TYPE “A” L_TYPE “A” L_TYPE “B” L_TYPE “B” L_TYPE “B” L_TYPE “C” L_TYPE “C” L_TYPE “C” L_TYPE ...

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

SnapLogic - Integration Nation

Forum Posts

Designing a pipeline to route depending if there is or is not data in an initial query

How to create zip with multiple xml file

Filter and Edit a JSON with a touch of data manipulation

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

Fetch dashboard/monitor details via a pipeline

mapValues returns null when adding certain conditi...

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