Designing and Running Pipelines

Removing [] from JSON array

Hey Everyone, I’m currently receiving data from an API and inserting the data into a MySQL database. Here’s an example of one of the columns that are coming over: [“5bb1614c4fd80200018e33c4”,“5ca500003aaf6000014dbc98”,“5b5f558add2f28000151e88d”] Is t...

Resolved! Splitting Json value

My requirement is whenever I pass a filename, the relevant node_id should be displayed for example: when the file name " 82755-6-012019-55.pdf" is passed node id 1021953 should be filter out.

Snaplex API (monitor Node mem_used and cpu_used)

I am trying to get how much Machine memory is used (memory and CPU) average per day, but from the API I am getting the results in decimal numbers. My question is what format are the numbers in bytes, kilobytes… etc. or percentages as I need to compa...

REST POST without input content only url with parameters

please kindly sent me pipeline example where i need to post to rest without any content. i just need to send url to REST post to merge account in marketo e.g: https://test-mktorest.com/rest/v1/leads/1934/merge.json?access_token=TOKEN]&leadIds=1888,18...

Upload files to ADLS Gen2 Using Rest API

Our Requirement is to write csv files to ADLS Gen2 Blob Storage We do not have Hadoop snap pack licences to use HDFS Writer We are checking other options to write files to Azure ADLS Gen2 Are there any sample snap using REST Put which upload files to...

Resolved! Securing exposed API endpoint for triggered task

It is my understanding that when we create a Triggered Task for a pipeline there are only two ways of securing the API endpoint, 1) the bearer token and 2) basic authentication in the endpoint URL as a parameter. I know others that use SnapLogic that...

After using a JSON splitter and a filter, how do you put the object/array back together?

Hi, we needed to filter on a JSON input. We managed to get that working by using a JSON splitter on the element and then piping that to a filter snap. Our issue is now the input that looked like this: "allLocations": { "location":...

Send email notification to specific users using schema data

We have a SQL table which contains the user mail ID and the comments/approval submitted by the user on a given date. Now I require to send out mail notification to dynamic user with details to notify them towards their pending actions. I am new to sn...

SnapLogic - Integration Nation

Forum Posts

Removing [] from JSON array

Resolved! Splitting Json value

Snaplex API (monitor Node mem_used and cpu_used)

REST POST without input content only url with parameters

Upload files to ADLS Gen2 Using Rest API

Resolved! Securing exposed API endpoint for triggered task

After using a JSON splitter and a filter, how do you put the object/array back together?

Send email notification to specific users using schema data

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