dynamic condition on redshift delete
HiI need to delete certain mrf_version from the existing table, but it validate, but when I execute the pipeline, it didn't work well. What is wrong with my pipeline?Thank you
Forum Posts
$original.original.orginal.original.... How to avoid this?
I'm working on a long pipeline that calls a number of child pipelines and passes a lot of data. Is there some way that I can design the pipeline, so that my original documents values don't get buried in many layers of $original.original.original... ...
How to compare 2 JSON Bodies dynamically and Create a single JSON Body
Hello all,I'm trying to update a current JSON object with an alteration - The alteration is not always going to be known (the exact field).But essentially, I have JSON 1 (the original) and JSON 2 (the new).For all fields in JSON 2, they should overwr...
New Pipeline Catalog: Coming soon!
Hi all, Recently saw a post from someone asking about cataloguing and having the ability to search for a specific endpoint in pipelines. I have good news to share that, very soon, we'll announce new cataloguing capabilities that will allow you to do ...
Obtaining OAuth 2.0 Access Token to use in Spreadsheet Dynamic OAuth2 Account
I am following the instructions for obtaining an access token. When I enter the commend I get a DNS error message after I authenticate to my Google account.Network Error (dns_unresolved_hostname)Your requested host "canary.elastic.snaplogic.com" cou...
Filter nested object based on NULL/EMPTY or not
Hello,I have a nested JSON object that I want to divide in two streams. Filtering based on if "account-allocations" is NULL/EMPTY or not. Both streams coming from the same pipeline and eventually merging. See example:1) JSON OBJECT2) WHEN YOU EXPAND ...
Resolved! groupby field and count
The ouput I'm trying to produce is ....see the input data in json Generator. Any help would be appreciated.
Keep data "through" snaps which don't provide original input under $original in their output
SnapLogic isn’t consistent in how data is passed through various snaps. It’s often necessary to keep some data obtained early in the flow (e.g. from the source) for use later (e.g. when writing to target). However, some snaps, like the XML Parser, re...
