Designing and Running Pipelines

Resolved! Map expression regex

Hi, A simple one for the people that are expert in regex. I’m still learning it. So, I have a key: notes that contains a value : “#IF:SLG-01-SL + some text here” My goal is to always get the 9 characters after an ‘#IF:’ My expression I tried in the ...

Null Values Not Written to Table

My Oracle input is address information similar to: STREET: 123 MAIN STREET CITY: ANYTOWN STATE: ANYSTATE ZIP: 12345 COUNTRY: USA STREET: null CITY: OTHERTOWN STATE: OTHERSTATE ZIP: 54321 COUNTRY: CAN STREET: null CITY: OTHERTOWN STATE: null ZIP: null...

Support Issue

Hi, I have sent multiple emails to support@snaplogic.com but nobody bothers to respond. Could you confirm what it takes to get a response from you?

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.

SnapLogic - Integration Nation

Forum Posts

Resolved! Map expression regex

Null Values Not Written to Table

Support Issue

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

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

Converting a string to JSON doesn't work

Rest Post for Multipart form type content type wit...