Designing and Running Pipelines

Create a reusable pipeline to dynamic apply default value

Here is the scenario: I want to apply default value to a table, and the column(s) which need to apply default value might be changed. What I am doing is to: Create a parameter csv file with the same column names as the source table.Join the source ta...

Snap Setting for sending one CSV file via REST POST Snap

Hi I need to know what snap setting do we need to configure to send one CSV file via REST Post snap, it would be great if you can share a screenshot or a sample pipeline that does that. (file need not be picked up from sldb, but to be created from in...

Snowflake Bulk Upsert Key Column Issue

Hello, I’ve had luck getting the snowflake bulk load to work. But that loads and duplicates records. I have been trying to get the Snowflake Bulk Upsert to work so I can use key ID columns. I can’t get past the error that I have an invalid column nam...

Query on Monitoring API

Hi Team, We are looking for a solution with Monitoring API where we can get the specific pipeline statistics for a day. It seems the API is not showing correct results. Please share us your solutions on this. Regards, Sindhu

File History

Hi All, I have a below requirement any suggestions will be great help. I want to log the file history into one log file for example when ever i read an input file I want to write an entry into the log file saying that file is read and if we are able ...

How to handle Null in Insert Snap?

Hi, My pipeline is running successfully when I have data in the source table. But when there is no data on the source then the Insert snap got failed with the message that the null value is not allowed in the table. We have mentioned the not null in ...

Adding element to array

Input json :-[ { “e_no”: “1”, “email”: “abc@gmail.com”, “country”: “India”, “firstname”: “A”, “last name”: “B”, “data”: [ { “e_no”: “12”, “email”: “abc4@gmail.com”, “country”: “India”, “firstname”: “A”, “last name”: “c” }, { “e_no”: “13”, “email”: “a...

Insert a new dynamic record in JSON under array field

Hi Everybody, Kindly help. Am trying to insert a dynamic value under the **value** array using extend function but unable to do so. [ { "entity": { "attributes": { "type":"CustomField","url":"A" } "Metadata": { "valueSet": { "value": [ { "color":nul...

SnapLogic - Integration Nation

Forum Posts

Create a reusable pipeline to dynamic apply default value

Snap Setting for sending one CSV file via REST POST Snap

Snowflake Bulk Upsert Key Column Issue

Query on Monitoring API

File History

How to handle Null in Insert Snap?

Adding element to array

Insert a new dynamic record in JSON under array field

Fetch dashboard/monitor details via a pipeline

mapValues returns null when adding certain conditi...

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