Designing and Running Pipelines

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

When I am trying to download a zip file , I am getting is not archive file invalid zip file when creating a zip file and writing it

I have created a pipeline and a trigger task (file writer) in the same project. But when I am trying to send the zip file using file writer / zip file writer snap in that api using REST PUT It is reflecting in manager and when I download it , it’s ge...

Oracle Execute Snap - Hangs

Hi, One of my Oracle Execute snap hangs in the pipeline execution. This is a straight forward Update command, this will update one record. If the pipeline is stopped and executed this will complete in few seconds. Not sure what causing the issue, del...

Reading data as soon as file is uploaded at a location using Snaplogic

I want to create a pipeline which reads a zip files uploaded at a location, so as soon as any new zip file is added the snap should pick it automatically ( so based on alert). And then I would like to unzip the file and put back the files at the same...

How to filter json data

Like below json structure, we want remove wd:Compensation_Element_Reference/wd:ID:@type=WID, and just leave wd:ID:@type=Compensation_Element_ID

How to bring API JSON text into REST Post Snap?

Hi all, I am trying to use a JSON file to feed in the body of a response that is working in Postman with curl code like this: In SnapLogic I added the raw body in a JSON generator and want to feed that into a REST Post Snap. My pipeline looks like t...

SnapLogic - Integration Nation

Forum Posts

Adding element to array

Insert a new dynamic record in JSON under array field

Oracle Account Validation - Network adapter could not establish connection

When I am trying to download a zip file , I am getting is not archive file invalid zip file when creating a zip file and writing it

Oracle Execute Snap - Hangs

Reading data as soon as file is uploaded at a location using Snaplogic

How to filter json data

How to bring API JSON text into REST Post Snap?

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