Designing and Running Pipelines

Resolved! Sort field names alphabetically in JSON source data

Hi Team, I have my source data coming in JSON format. I want to sort the fields inside the JSON format alphabetically. One way is to use a mapper and arrange them one-one alphabetically but it is a tedious task if the fields are more. Can we use an e...

Check array is empty or not

Hi Experts, I have a requirement where I need to check ‘group’ array is empty or not. Could someone help with the JSON path expression. Empty group array JSON looks like: [ { “group”: [ {} ] } ] Non empty group array json loiks like: [ { “group”: [ ...

Email Sender Snap - attach file from SharePoint

I have a pipeline that creates a file and posts it to a SharePoint document library. I want to use the email sender snap to send that file as an attachment. I currently have a pipeline that does it, but the file is stored on a network drive and we ...

Need counts of 20+ Tables from Source & Target into a .xls file

Hi - i am looking to capture counts of source and target tables into .csv file for data verification on a daily basics. My Question is i was able to get a table count into a csv file after designing a snap SQL Select ->Aggregate -->CSVFormater->Filew...

Resolved! Join Snap issue

I have output documents from join snap as follows next I have a Router Configured basically for checking for a particular variable “RowCount” in input…the scenario is I only want to check if “rowCount” is available in only 1 input document,but it r...

Resolved! Combine multiple arrays

hi there, I have following json [ { "docname": [ "Coupa_Supplier_SB_Tax_Cert_PO_4501923290", "Coupa_Supplier_SB_Tax_Cert_PO_450192323" ], "id": 16758, "docext": [ "pdf", "pdf" ], "IDOC": { "@BEG...

Resolved! Filter expression on arrays

hi there, I have this json [ { "filename": [ "Coupa_Supplier_SB_Tax_Cert_PO_4501923290", "Coupa_Supplier_SB_Tax_Cert_PO_4501888888" ], "id": 16755, "docid": [ "FOL18 4 EXT48000000000761", "FOL18 ...

Ultra Task Not Starting

We have an ultra task , we can see that we have documents to be processed but the ultra task isn’t starting also we cant see the task in the dashboard. Has anyone experienced similar issue recently ?

SnapLogic - Integration Nation

Forum Posts

Resolved! Sort field names alphabetically in JSON source data

Check array is empty or not

Email Sender Snap - attach file from SharePoint

Need counts of 20+ Tables from Source & Target into a .xls file

Resolved! Join Snap issue

Resolved! Combine multiple arrays

Resolved! Filter expression on arrays

Ultra Task Not Starting

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?

Remove XML duplicate key from JSON list in XML for...