Designing and Running Pipelines

SQL Server Insert and Update

Hello All, We are developing a solution in which the data from an excel sheet is required to be inserted in the SQL Server. This excel may contain updates for previously inserted rows and may contain net new rows to be inserted, which can be determin...

How to validate the basic authentication details sent in header using a REST call

I have a scenario where I need to validate the user authentication sent as part of header by validating against the Snaplogic account details. How I can retrieve the incoming authentication details from header. The idea is to achieve this using a bas...

How to decrypt the Basic auth account password

Hi, When I use Snaplogic Read snap to retrieve the Basic account details which was created already, I can see the password is in encrypted form. How to decrypt the password and retrieve? What is the default encryption method which is used for encrypt...

Using the ServiceNow Insert Snap and need to know what permissions the account needs in ServiceNow

So I have to pickup a file from a folder and push that file into ServiceNow as an attachment. I have a pipeline setup to do that using the ECC Queue. My issue is that it only works if the account has the admin role in ServiceNow. If the account do...

Error Pipeline

Hi, I am new to SnapLogic. i need help on how to pass the snap error code values (error reason, error resolution, etc) to the error pipeline from parent. In document i am able to see only one value i.e. “value_from_parent”. so that i will save the er...

Parquet Writer error handling

Good day community, I’m trying to use the Parquet writer to Write data in Parquet format (this works fine, once there are no errors)Route the errors to an error view and generate a CSV file with it. See screenshot of the pipeline. The pipeline valid...

Redshift -SCD2 snap

Has someone used Redshift SCD2 snap? I am looking for some sample pipeline to setup a SCD2 on one of my Redshift tables. Requirement is to insert a new row and in case of an existing row ,expire the old row and insert a new row.

Resolved! Mapping flat incoming documents to object output

Hi, I have a csv file containing rows with customer orders which I want to map to an XML invoice object which generates an invoice containing all the customer orders. The incoming data looks like this: CustomerIdPriceQuantity4201420253015302 The targ...

SnapLogic - Integration Nation

Forum Posts

SQL Server Insert and Update

How to validate the basic authentication details sent in header using a REST call

How to decrypt the Basic auth account password

Using the ServiceNow Insert Snap and need to know what permissions the account needs in ServiceNow

Error Pipeline

Parquet Writer error handling

Redshift -SCD2 snap

Resolved! Mapping flat incoming documents to object output

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