Designing and Running Pipelines

Join preview data different than the actual raw data

Hi Team, I’m joining 2 tables (one from snowflake and another from salesforce), I do have the raw data so that it helps me with my validation while designing a pipeline on snapLogic. While I use a left outer join, even though the data should have bee...

How to read base 64 data from a SOAP snap body

Hi, I want to read the SOAP snap response which I think is Base64 decoded data and insert it into a table. Could you please help me with the process of reading the data from the SOAP snap output body?

Read Expression File

Hi All, I have attached the expression file and I want to read the below from the file. Could you please suggest how to do it? Generic_Soap_WSDL_URL: ‘/idcws/GenericSoapPort?WSDL’, HCM_Flow_Service_WSDL_URL: ‘/hcmService/FlowActionsService?WSDL’, HCM...

POSTGRESQL_ Execute

Hi, I am trying to alter the primary key , but i am unable to do that. Can you please check my query and confirm , whether the syntax is correct or not as per snaplogic. Alter table snaplogic.tbl_audit_log drop primary key Alter table snaplogic.tbl_a...

How to add multiple file filter to a file poller

I want my file poller to poll all txt and xml files how can I specify the same in the file filter property? *.txt && *.xml is only selecting txt files.

Resolved! CSV Parsing Inputs

Hi All, I have a tab-separated CSV file with let us say 10, 000 records and I am using CSV parser snap to parse the file. The process works fine when there is no data issue but when there is a data issue the whole file fails. Could you suggest if the...

Merge multiple documents to an array in ultra pipeline

We need to merge multiple documents to single array and looking for help. Since it is ultra task, we are running out of options… Input data: [ {“Record”: “1”}, {“Record”: “2”}, {“Record”: “5”}, {“Record”: “4”}, {“Record”: “6”} ] Expected Output: [ “r...

Using union in Execute SQL snap

I have an Execute SQL where I wan to add column names to my output file before adding the data. For example: select ‘Last_Name’||chr(09)||‘First_Name’ from sys.dual union select rtrim(spriden_last_name) from spriden||chr(09)||select rtrim(spriden_fir...

SnapLogic - Integration Nation

Forum Posts

Join preview data different than the actual raw data

How to read base 64 data from a SOAP snap body

Read Expression File

POSTGRESQL_ Execute

How to add multiple file filter to a file poller

Resolved! CSV Parsing Inputs

Merge multiple documents to an array in ultra pipeline

Using union in Execute SQL snap

Append input data vertically

Difference between 2 dates

Find unmatched data using join

split target csv file into more smaller CSV's

How can I edit/update my community posts?

Http Client Snap vs REST Post snap

Parsing CSV file

Data Validator Pattern error

Deleting multiple files at once from SFTP folder

SQS -pipeline stalling