Designing and Running Pipelines

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...

Ultra Tasks takes more time to execute at each interval

Hi Team, I had created one ultra task that needs to be executed whenever there is any files in in sftp server directory. I had two queries :- a. The ultra tasks triggers the pipeline continuously even if there were no files in the directory. Can we ...

SnapLogic - Integration Nation

Forum Posts

Resolved! Remove json object conditionally

Resolved! Using the parsed Float value in string

Extraction of binary objects (BLOB) like images and pdf from Oracle table

SoapExecute Workday Read Get Course Sections fails with error message 'Course_Section_Reference is required' when it actually exists in the request

Describe table_name is not working in oracle execute snap

Issue: Mapper object array incorrect in to Workday Write output

Debugging Javascript - General Guidance

Ultra Tasks takes more time to execute at each interval

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...

Generating individual files based on 'n' records f...

Convert array with objects into object with key/va...