Designing and Running Pipelines

Can AZURE SQL database be used with ELT snappacks

Can we use azure sql as database type in ELT snappacks I am not getting option to select AZURE sql in account setup getting different options like AZure synapse,snowflake etc. Anyone please if knew the answer

Compare DateTime against a point in time (in local time zone)

Hi, I’m having a hard time trying to figure out a way to compare a DateTime property (which is stored in UTC) to a point in time i.e. Today midnight (in the current local time zone which is US/Eastern -05:00)… The closest thing came to find is Date.p...

Resolved! Get current JSON document being inserted

I have a pipeline with a oracle insert snap and a error pipeline. Everything works. When something in the pipeline fails I am passing variables to the error pipeline and storing in a table. I want to pass the current JSON document that failed? W...

Tell SnapLogic to do Nothing

If data doesn’t meet a certain criteria (e.g. evaluated through a router snap), we want SnapLogic to do nothing i.e. avoid routing to an error pipeline/no further action required

Resolved! [solved] Add decimal zeros to integer for double

Hi, I get as JSON input { "amount" : 1000 } I would like to convert 1000 to 1000.00 { "amount" : 1000.00 } How? I do not want to convert to “1000.00” which toFixed(2) does. thank you.

Resolved! Raw Text into Body on REST Post

We have an API that’s expecting raw text as the body of the call and I’m not clear on how to get SnapLogic to pass the data as raw unformatted text. If I map my text into $content and then pass that to the API The problem is that when I look at how...

Issue (or bug) with mapper snap

Hello, I have found something like bug. I cannot understand the strange result of the following pipeline. When I run validation of this pipeline, I see following results. As expected count of the input documents in the Gate output equal zero. You ca...

Resolved! Expression Library evaluates to ArrowFunction

Hello, i’m trying to nest a function in a map within an expression library, however what i get returned just the ‘callstack’ of the function. Here’s the outcome: [ { "test": "/* ArrowFunction @ line 5:10 */ () => __parent__.salesRegionMapper('account...

SnapLogic - Integration Nation

Forum Posts

Can AZURE SQL database be used with ELT snappacks

Compare DateTime against a point in time (in local time zone)

Resolved! Get current JSON document being inserted

Tell SnapLogic to do Nothing

Resolved! [solved] Add decimal zeros to integer for double

Resolved! Raw Text into Body on REST Post

Issue (or bug) with mapper snap

Resolved! Expression Library evaluates to ArrowFunction

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