Video: Extract Load Transform (ELT), August 2020
In this video, learn how you can push workloads to your favorite cloud data warehouse with the new ELT feature in the SnapLogic Intelligent Integration Platform.
Forum Posts
Resolved! Remove json object conditionally
I have the following document with question responses. When the response is “-”, I would like to remove the question and answer text. Is there a way to do this in a mapper or conditional step? Before: [{ “Questions”: [ { “answerText”: “John”, “Que...
Resolved! Using the parsed Float value in string
I have double value coming from the source as a string. Source value: “NTGEW” : “3.400” I am using parseFloat() function to convert the string into double value. parseFloat($NTGEW) ===> 3.4 The parseFloat function is working as expected when it is th...
Extraction of binary objects (BLOB) like images and pdf from Oracle table
Does Oracle Select Snap fetch the BLOB data from a table as actual document/image? I would like to fetch those docs from database and store them in FTP location. Here, I’m looking for specific example of pipeline. I’ve not seen any special mention...
SoapExecute Workday Read Get Course Sections fails with error message 'Course_Section_Reference is required' when it actually exists in the request
I am attempting to get a web service response from workday, but hitting an error which does not make sense to me error: Course_Section_Reference’ is required, on internal element 'Course Section Request References There is no ‘Course Section Request...
Describe table_name is not working in oracle execute snap
Hi, I am trying to execute the sql query “describe table_name” but it is not working in oracle execute snap. Getting an error like " Filed to execute query. Reason: ORA-00900: invalid SQL statement , Resolution: Please check sql query" Any suggestio...
Issue: Mapper object array incorrect in to Workday Write output
We are building a boomerang integration, which gets values from workday, adds/changes some of the data, and resubmits the data back to workday. In the mapper, I want to grab an entire section and rewrite it back to the submit without changes. this...
Debugging Javascript - General Guidance
I’m looking for General Guidance, not a solution to a specific problem! I have a lot of experience programming in server-side languages like C++, C#, T-SQL, PL/SQL, and others… but am very much a newbie at Javascript. (When my employers’ pipelines u...
