Designing and Running Pipelines
Discuss how to use the SnapLogic platform.
cancel
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

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

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

thilkip by New Contributor
  • 11401 Views
  • 25 replies
  • 4 kudos

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

clarrivey by New Contributor
  • 2676 Views
  • 5 replies
  • 0 kudos