Designing and Running Pipelines

How we can schedule cron job which will run on last three working days? Aslo need to exclude holidays

Hi Team, Is that possible to make my job run only last three working days on month? Also, need to adjust working days if any of the last three days is a holiday.

Zipfilewriter - file name

Does ‘content- disposition’ function works with zipfile writer. I’m writing below exp concatenating with SFTP path but this is giving me error. $[‘content-disposition’].match(“filename="(.*)"”)[1] error: Failure: $[‘content-disposition’] is undefined...

Use multiple instance of same lookup

I have a source Oracle table(S) For Training data with following 2 Fields Instructor_Name Participant_Name I1 , P1 I1 , P2 There is another table(L) in a different DB having Id for both Instructor & P...

Multiple queries in Hive Execute

Hi, I want to execute multiple queries in Hive execute snap. See the below example I want to use the database name and create a external table in the particular database . I could not able to achieve it in single hive execute snap. Ex: Use temp Creat...

Push data to S3 using Parquet Writer

Hi All, I Have requirement to push data to S3 using parquet writer, when i tried to push, I am getting the below error PN: I am able to push data using parquet writer using Hadooplex, but not able to push using Groundplex Snaplex nodes Failed to init...

XML Column parsing

Hi, I have a table which contains the following columns: ActionID, DataTypeCD, Data, ActionDataID These columns have below values in it: ActionID = 123 DataTypeCD = DDV2 Data = LETR CROM MOBL IOSS SNTS DQLF ActionDataID = 456 Now I want to hav...

Groundplex nodes accessible over the Internet?

The Triggered Pipeline Access Control document (https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages/1438214/Triggered+Pipeline+Access+Control) states, “It is not recommended to make the Groundplex nodes accessible over the Internet.”. Why?

Split a binary string based on the length

Hi Say I have some binary content which is 12000 bytes long. I want to build a pipeline that chops the whole binary into different parts every 4000 bytes. so 1 to 4000 bytes will be in one column, 4001 to 8000 bytes will be in 2nd column and 8001 to ...

SnapLogic - Integration Nation

Forum Posts

How we can schedule cron job which will run on last three working days? Aslo need to exclude holidays

Zipfilewriter - file name

Use multiple instance of same lookup

Multiple queries in Hive Execute

Push data to S3 using Parquet Writer

XML Column parsing

Groundplex nodes accessible over the Internet?

Split a binary string based on the length

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

Best way to perform multiple search and replace in...

Obtain Rest API curl to run in postman directly

CSV parser cannot parse data

Parsing XML using a Python script returns an encod...

multiple array objects

String replace method where pattern is dynamic

Send Multiple HTML Tables in Email using XML Parse...