Designing and Running Pipelines

Resolved! How to add a custom Header in a file?

Hi, I am reading some table data from a SQL Server (‘SQL Server - Execute’ snap) and writing the output to a text file (‘File Writer’ snap) (using a ‘CSV formatter’ between he above snaps) ‘SQL Server - Execute’ → ‘CSV formatter’ → ‘File Writer’ Req...

How to use java script in snaps to replace accented characters?

Hi, I am trying to load data from snaplogic into workday. I have a requirement to remove the accented characters from some fields and replace them. For example - “á” changes to “a” or “Ê” changes to “E” and so on. I have found a java script which can...

Resolved! SSO login issues

Hi , We have multiple Snaplogic orgs created which are using same Identity Provider ( IdP). Today on one of the org i changed the IdP and when i tried to login back using SSO i received an error message “Single Sign On authentication failed.SSO login...

Help On Creating Pipeline To Output Errors

Good day Community I am building a number of pipelines to copy records from a number of tables to Azure storage and if a particular date value of “0000-00-00” is found in any date field in any table I need to output this in a separate error log file ...

Rest Post with attachment and form data

Hello Snaplogic gurus, Can any one give me pointers how I can convert this into snaplogic pipeline? Thanks Manohar curl -L -X POST ‘https://test.coupahost.com/api/purchase_orders/471/attachments’ -H ‘Accept: application/json’ -H 'X-COUPA-API-KEY: x...

Rest POST for --data-raw

How can I call below curl command in Rest POST snap curl --location --request POST ‘localhost:8086/api/v2/write?bucket=mydb&precision=s’ --header ‘Content-Type: application/x-www-form-urlencoded’ --data-raw ‘mem,host=test’ Pls advice?

Handling timestamp in parquet file writer

Hi team, I am getting wrong data being written by the parquet writer for the timestamp data. please help as it is urgent. below is the output of mapper snap Below is the data created by parquet file when using int64 activity_ts (TIMESTAMP_MILLIS) B...

Create JSON from CSV file

Hi, I am new to snaplogic and want to create a JSON structure from a CSV file. CSV file data “Name”,“AddressLine1” “Test1234”,“122 Test St” The structure i need is very specific like: [ { “attributes”: { “Name”: [ { “value”: “Test1234” } ], “Addresse...

SnapLogic - Integration Nation

Forum Posts

Resolved! How to add a custom Header in a file?

How to use java script in snaps to replace accented characters?

Resolved! SSO login issues

Help On Creating Pipeline To Output Errors

Rest Post with attachment and form data

Rest POST for --data-raw

Handling timestamp in parquet file writer

Create JSON from CSV file

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