Stack Overflow
Stack Overflow

Questions tagged [snaplogic]

For issues relating to the SnapLogic Enterprise Integration Cloud.

The SnapLogic Enterprise Integration Cloud is a

simple, fast, and intelligent platform that empowers enterprise IT organizations and lines of business to connect.

57 questions
1
vote
2 answers

How do you establish an order of events, or steps, in a snaplogic pipeline

I'd like to establish an order of events in my snaplogic pipeline. I'd like to perform (for example) a SQL Execute snap, and then after that, another different snap. There's no input/output data relationship between these snaps. I just want one to…
John DeHope
  • 31
  • 6
1
vote
2 answers

Snaplogic: How to join two tables with a condition other than equals (like, >, <)

I am trying to join two tables in which column from table 1 "contains" data from one of the columns in table 2 i.e. consider below hypothetical: Table error_log: id| description 1 | this is right, bla bla, bla 2 | this is , bla bla, bla, wrong 3 |…
Manish Mishra
  • 12,163
  • 5
  • 35
  • 59
1
vote
1 answer

snaplogic - from single record to multiple rows in csv

How I can build a pipeline that gets a input as below and then needs to split this into 2 records in CSV file as in the image? Yes Scraper Equipment …
cloudit
  • 23
  • 4
1
vote
2 answers

Workday: Submit_Customer_Invoice returning an error - The task submitted is not authorized

I'm using Snaplogic to load records into workday. Trying to load invoices into workday using the object Submit_Customer_Invoice of web service Revenue_Management. I'm getting the following error: "error": "Processing error occurred. The task…
Bilesh Ganguly
  • 3,792
  • 3
  • 36
  • 58
1
vote
1 answer

How to set x-www-form-urlencoded in the REST POST snap of Snaplogic?

I'm trying to create a pipeline which given the client ID and client secret, gets the access token for PayPal. I'm able to do it using Postman but I'm unable to do the same using Snaplogic. In the above picture, you can see that I have to set…
Bilesh Ganguly
  • 3,792
  • 3
  • 36
  • 58
0
votes
0 answers

Snaplogic bulk load into snowflake

I am pulling data from an API and trying to bulk load it into snowflake. The API used OAUTH2 protocol. The bulk load is executing "COPY INTO" once command for each row of input. This is not an efficient way to bulk load. I want the "COPY INTO" to…
Anand Rajakrishnan
  • 148
  • 12
0
votes
0 answers

How to use join snap to get NOT a match data

I’m using join snap to with a condition NOT, surprisingly the validation is giving me output, but when i’m running the pipeline it is giving me an error, Can someone please help me understand what i’m doing wrong ERROR message: Not comparable…
bongboy
  • 147
  • 1
  • 15
0
votes
0 answers

Snaplogic Remote Python Executor on AWS Linux AMI

I've started up an AWS Linux AMI with a snaplogic DS RPE docker. It is working just fine it seems. When i use the public DNS from my AMI as the hostname for my remote python account on snaplogic, it doesn't seem to work. I can't seem to get…
JmPearl
  • 11
  • 2
0
votes
0 answers

Snap Logic to Snowflake Connection using Key Pair Authentication

We used to have below field for OAuth2 in snapLogic while connecting to snowflake. Authentication parameter value: refresh_token session:role: However, while using key pair authentication, there is no field to put the functional role. Hence, if the…
Shruti
  • 105
  • 1
  • 10
0
votes
1 answer

SnapLogic join snap not returning results

I am new to SnapLogic and I am using the join snap but for some reason, it doesn’t find any matches but I know there are matches. I have outputted both streams to a file and I confirmed that they have matching IDs but when the join snap runs it…
user11281116
  • 11
0
votes
1 answer

How to check if column is present in Excel file while parsing in snaplogic

I have an Excel file and I want to insert the data into a database. I need to know if all the columns are present in the excel file. I used the required constraint of the data validator snap to be notified if a column is missing. But no error occurs…
Min_jay
  • 19
  • 4
0
votes
1 answer

Snaplogic - Expression Language Syntax - unique array value

I am using following EL jsonPath($, "$array.map({id: value.get('id'), type: value.get('type') })") which produces the next variable ... But the key(id) is not kept unique ?! [{ "id": "1", "type": "1" }, …
owsata
  • 1,105
  • 1
  • 11
  • 24
0
votes
1 answer

Passing json body with Postman in mapper with REST POST - Snaplogic

How do you access the data sent from REST POST with Postman if you have an open mapper in Snaplogic? For example, I have inserted some JSON code with key and values like this: And I want to work with it and transform it in a Mapper snap but I can't…
userdev1407
  • 23
  • 2
0
votes
1 answer

How can I take the name of a pipeline dynamically using the Email Sender snap in SnapLogic?

I want to take the name of a pipeline coming from the input stream directly so I can use the values to generate an HTML table in the Email Sender snap and write a report without having to generate a file first, so it can be more convenient.  My code…
tee_thesee
  • 9
  • 1
  • 4
0
votes
2 answers

Is there a way to capture the name of a task that has been executed in SnapLogic?

We have a lot of triggered Tasks that run on the same pipelines, but with different parameters. My question regarding this - is there a possible way, like a function or an expression to capture the name of the triggered task so that we could use the…
tee_thesee
  • 9
  • 1
  • 4
1
2
3 4