Designing and Running Pipelines

Filter grandchild based on value in grandchild field

hi there, I have the attached json message thats coming in this structure shown below. I need to filter the list in the Orderlines array if the status has “soft_closed_for_receiving” or “soft_closed_for_invoicing”. And if after filtering, if the arra...

Why does Azure Blob Storage return 201, but not upload?

I was so excited I got a 201 status code from Snaplogic PUT snap that I jumped to the Azure Portal. Unfortunately my file was not there. The same request is uploading file successfully to Azure from PostMan Here is the details i’m using to upload a f...

Active Directory group with more than 1,500 members

It appears that the LDAP Search snap is unable to return attributes with more than 1,500 (member) records. Is this limitation resolvable without custom coding?

AD snaplogic limitations to 1500 members

If an AD group contains more than 1500 members,the attribute member has “No Values” and an attribute member;range=0-1499 is returned which has first 1500 members. Is there a way to return the rest of the users or all the users in one call? I have use...

hasPath within List

Hi there, I am trying to check if json list has a node within. in below json checking if IDOC.E1EDP01 has E1EDPT1; which works fine. then when I am trying to look for E1EDPT2, thats when its failing. I have below expression. $IDOC.E1EDP01.filter(x=>x...

Resolved! How to map multiple target path to single field name

Hi all, I have a sample data as below: “TRANSCU2”: “T1” “TRANSCU3”: “T4” “TRANSCU4”: “T8” “TRANSCU6”: “T90H” “TRANSCU7”: “T67” “TRANSCU8”: “T653” But i wanted to map all source field to single target path like below: “CU”:“T1” “CU”:“T4” “CU”:“T8” “CU...

Resolved! To get sum of value present in between special character like '|'

Hello Community, I need to get the sum of value present in between special character ‘|’. Length of input may vary, one such scenario is attached. Please suggest. Output getting after aggregate : “NEUTSUM”: “261.02||697.13|359.22” I need to get sum ...

Ternary operation to handle diff date formats

The source file contains Reporting Period value in diff date format. Aug-2022 Aug-22 AUG 2022 August-2022 I am using the below ternary expression to handle the above mentioned date pattern. isNaN(Date.parse($RPT_MONTH,‘MMM-yyyy’)) || isNaN(Date.parse...

SnapLogic - Integration Nation

Forum Posts

Filter grandchild based on value in grandchild field

Why does Azure Blob Storage return 201, but not upload?

Active Directory group with more than 1,500 members

AD snaplogic limitations to 1500 members

hasPath within List

Resolved! How to map multiple target path to single field name

Resolved! To get sum of value present in between special character like '|'

Ternary operation to handle diff date formats

Best Approach for Handling CSV Import with Truncat...

Fetch dashboard/monitor details via a pipeline

mapValues returns null when adding certain conditi...

What account should be used for API with query par...

How to dynamically update an account?

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?