viji28
New Contributor
Joined 5 years ago
User Profile
User Widgets
Contributions
Array data into SQL script
Hello, I have sample data which looks like this The flow that I would like to achieve is, first I would like to dump the “Number” data in table1 , next I want to get the data number within the data array and put it in a SQL script, so that I can insert it in the DB. I have already tried the json splitter on the “data” array which does the job but I would like to avoid the splitter. we have 1 document as input but when we split the lines, number of output would be more than 1. If we use a SQL script to achieve the same functionality , we can achieve 1 input 1 output. Any help?1.2KViews0likes0CommentsRe: Invocation of Ultra task fails
Thank you! I tried using a json formatted and tried writing the input content to the file. The incoming json structure is indeed different. Though we may think that we are sending json structure but when the ultra receives it, the JSON is under $content.2.1KViews0likes0CommentsInvocation of Ultra task fails
Hello Team, I have created a test pipeline, where using Rest post I am invoking an Ultra pipeline. The ultra pipeline is simple, it expects the $test input and sends the result back. This is only for test purpose. Here is the input that I provide to the Rest post snap: [ { “url”: “https://URL/api/1/rest/feed-master/queue/Reece-Dev/-Project/Test/Test%20Task%20Ultra”, “token”: “xyz”, “test”: “1” } ] Here is a test pipeline : The Rest post gives an error: I fail to understand why does the ultra pipeline throw an error when I am passing $test object to it. Here is the snap of Ultra task : Can someone help here please?SolvedJMS Consumer design
I am using a JMS Consumer snap where the Queue name is derived from the pipeline parameter. In such a case , the queue name must always be entered in the parameter. I would like to fetch the queue name from the dynamo DB, along with other values, and pass it to the JMS consumer snap. When the JMS consumer gives an output, it only gives me the message retrieved from the AWS queue but it does not give me any additional values like what was passed to the JMS Consumer snap. I am expecting a kind of expecting pass-through functionality. Any thoughts ?JMS Consumer vs AWS SQS Consumer
In JMS Consumer , we have a setting named “Message Acknowledge Mode*” which we set it as ClientACknowledge or dupsAcknowledge Comparing it with AWS SQS Snap , it does not have any acknowledge mode. In our prod environment, we have JMS consumer where client acknowledge is enabled. Now if i have to replace it with AWS SQS snap , how can i achieve the same configuration as JMS ?Solved3KViews0likes1CommentREST GET snap
Hello Team, I would like to know about a capability. Explaining below: Lets assume i have a json object : {“country”: “US”, “event”: “CREATED”, “OrderNumber”: “1125” } From the above JSON, i would like to pass the OrderNumber to REST GET snap. The REST API is an inhouse API and is designed in such a way that , if we pass an order number , it send backs all relevant details like invoice date , billed by , billing number , order number etc but when it does not find any match , it does not send any output . I would like to build a case where if the match is found through the API , we would pass the billing number but when the match is not found , we will provide a default number. My issue is when the order number is not matched in the API , i do not get any output. Is there a way where we can enable pass through ?so that i get the original order number or schema passed ?2.3KViews0likes2CommentsTriggered task response
We have a snaplogic pipeline which is designed to load data into the table and have created a triggered task to invoke the pipeline. This task is being called by another application. In the recent execution , this task was invoked successfully and I do not see any issue in loading data but I see some error in the dashboard: Encountered an error while sending response to triggered task client Reason: Close SendCallback@6b8420[PROCESSING][i=null,cb=org.eclipse.jetty.server.HttpChannel$SendCallback@627a7819] in state PROCESSING Resolution: Check network connection and make sure the client is fully reading the response Can someone help with in decoding this error please? Thanks