Designing and Running Pipelines

Resolved! Problem with copy and join

Hello, I am working on this pipeline The problem is with this part I copy my result set. I keep my first output And aggregate my second output And finally I want to take those aggregate results using a lookup. This make my pipeline run endlessly. A...

Multiple file loads in single pipeline

Hi Team, I have a usecase where I need to process multiple files (like A,B,C) and load it to tables like (X,Y,Z). I can setup this configuration as control table. Say when file A is available load it to X table, for B file load it to Y table, C file ...

Transform Array to New array

I have a requirement where I need to convert an array into new array . Below is the example . INPUT: { “cover”: [ { “needCode”: “abc”, “needKindName”: “abc xyz”, “autoBoostCoverAmount”: { “amount”: 25, “currencyCode”: “XAF” }, “coverAmount”: { “amou...

Issue in configuring REST OAuth2 Account

Hello All, I am facing an issue in configuring the REST OAuth2 Account in SnapLogic, I am getting the below error while I try to authorize it, {“http_status_code”: 500, “response_map”: {“error_list”: [{“message”: "Request to token endpoint https://lo...

Obtaining response from JSON Post command

Hi I have a pipeline which takes data from a SQL select command and posts to a Service Now API to create a task. Service Now responds with the ID’s of the tasks which I want to post back to the SQL. However when I run the POST command in Snaplogic, ...

Resolved! Kafka SSL account validation to confluent cloud

Hi, So I am trying to connect to my env in the confluent cloud using the kafka ssl account configuration. After doing everything step by step creating the keystore and truststore file and also creating api key secret in confluent cloud and also the r...

Snowflake bulk load snap is executing COPY INTO for each input document

I am working on building a pipeline to pull data from an OAUTH 2.0 API and load the data into snowflake using snowflake bulk load. I observed that for each output from REST Get snap, the bulk load is triggering a COPY INTO command in snowflake. So fo...

Rest Get Query parameter particular filter criteria not working

I am doing an API call by passing dynamic timestamp in Query Parameters section , here is the value I am passing “INSTALLED_SW_LAST_CHANGE_TIMESTAMP%20ge%20”+Date.now().toLocaleDateString()+“T15:00:00-05:00)”. I am getting status code error 400 But ...

SnapLogic - Integration Nation

Forum Posts

Resolved! Problem with copy and join

Multiple file loads in single pipeline

Transform Array to New array

Issue in configuring REST OAuth2 Account

Obtaining response from JSON Post command

Resolved! Kafka SSL account validation to confluent cloud

Snowflake bulk load snap is executing COPY INTO for each input document

Rest Get Query parameter particular filter criteria not working

Help to parse Json data into csv

Updating Salesforce contact object and Account Loo...

Slicing Data from JSON

Connecting Confluent Kafka using OAuth

Hexadecimal to binary conversion

array.map if field1 meets criteria, I want field2

Filter Array data

How to create timestamps and out put them only usi...

Do JSON mapping in a single mapper

Problem with nested mappings