Designing and Running Pipelines

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

Oracle Account Validation - Network adapter could not establish connection

Good day community, I’m getting the error below when trying to validate an Oracle account. I can successfully connect to the database using SQL Developer and the same credentials. I am also able to ping the Oracle instance from our Groundplex server...

SnapLogic - Integration Nation

Forum Posts

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

Oracle Account Validation - Network adapter could not establish connection

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

Converting a string to JSON doesn't work

Rest Post for Multipart form type content type wit...