This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
FAQ
Designing and Running Pipelines
Discuss how to use the SnapLogic platform.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

Start a conversation

Resolved! Find a specific word in Json Object

In the router i am trying to route data based on below criteria if any of the value in statusC.contains("T’) route to view1 if any of the value in !statusC.contains("T’). (does not contains) route to view2 How can i best achieve from below data [ { ...

npise by • New Contributor II
  • 3784 Views
  • 4 replies
  • 1 kudos

Joining two files without a common value

I want to join two files based on a field of file 1 containing the value of a field in file 2. What would be the best way to do this? e.g. File 1: $district_name='ABC School District". File 2: $district: ‘ABC’. So if $district_name.contains($distr...

SnapWizard by • New Contributor III
  • 1125 Views
  • 1 replies
  • 0 kudos

ServiceNow Query snap Performance

My usecase is to ingest data from ServiceNow into Snowflake, with no tranformation. I’m creating simple pipeline with 2 snaps - ServiceNow Query and Snowflake BulkLoad The service now table has 2.5 M rows, it is taking about 7hrs to read this data fr...

Resolved! Failed to execute pipeline

Hi, I am getting error while running the child pipeline with larger files. There is no error with smaller files. I have a mapper at the starting of child pipeline. Below is the error:- Failed to execute pipeline Reason: Snapi request failed: {“respon...

Sahil by • Contributor
  • 2933 Views
  • 2 replies
  • 0 kudos

Formatting excel data

I have an Excel sheet with with below format: In this Excel, column 1,2 and 3 remains common, and the data which i am suppose to send is in below output csv format: Output: QWE;1234;567890;1111;20212021 (Row 1: Column 1,2 and 3 is common with fields...

Resolved! Jsonpath begins with

Below is my input, i am trying filter for id where type == file and name begins with “Send Email” expression i used in mapper jsonPath($, “entity.entries[?(@.type == ‘file’ && @.name =~ /Send Email.*?/i)].id”) but i am getting error Please check exp...

npise by • New Contributor II
  • 3133 Views
  • 3 replies
  • 1 kudos
SnapLogic Trust Site
Visit Trust.SnapLogic.com for real-time visibility into system performance and availability.
SnapLogic Documentation
Visit our documentation for detailed information on functionality and features.
  • New site
  • Original documentation site
    • New solutions
    Find More Solutions