Richard
New Contributor III
Joined 5 years ago
User Profile
User Widgets
Contributions
Passing custom value to Error pipeline
Hi, I have search the community and Google for that matter but I cannot find a sample of how I can pass a custom value to an error pipeline. When we start a pipeline we consume message information from a RabbitMQ queue and when we have an error in our pipeline I need to pass that message information from the queue to the error pipeline. Can somebody please tell me how to do this or is it possible at all because I have tried days to get this working from the samples I found on the internet but to no avail? Thanks you for your help.2.6KViews0likes2CommentsRe: Some json strings questions
Richard: [ { transactionId:“F59AE026-8AEA-4F69-BE97-F7AB981AC3BF”,LineCreationSequenceNumber:1,ItemNumber:“99999999991”,OrderedSalesQuantity:1,SalesPrice:120,AVAPromotionCode:null,SalesUnitSymbol:“UN”,SalesProductCategoryName:null,AVALaserText:null,AVAWrappingText:null }, { transactionId:“F59AE026-8AEA-4F69-BE97-F7AB981AC3BF”,LineCreationSequenceNumber:2,ItemNumber:“99999999994”,OrderedSalesQuantity:2,SalesPrice:80.93,AVAPromotionCode:null,SalesUnitSymbol:“UN”,SalesProductCategoryName:null,AVALaserText:null,AVAWrappingText:null } ] Thanks for you answers, really appreciate it. The above lines will have to put in an array if possible. Further I did try to do your way of removing the original but in my case it worked once but the strange thing is that further on in the pipeline when I tried to do the same thing again it gives me an error that it cannot find the original, even though I can see it in he input schema. Have you seen that before? Thanks3.4KViews0likes1CommentSome json strings questions
Hi We are just starting off with SnapLogic and we wonder if somebody can give us some answers to the following questions. We have the following input [ { transactionId:“F59AE026-8AEA-4F69-BE97-F7AB981AC3BF”,LineCreationSequenceNumber:1,ItemNumber:“99999999991”,OrderedSalesQuantity:1,SalesPrice:120,AVAPromotionCode:null,SalesUnitSymbol:“UN”,SalesProductCategoryName:null,AVALaserText:null,AVAWrappingText:null, original:{erpOrderNumber:“JEM-99999”,clientOrderNumber:“00118204”} }, { transactionId:“F59AE026-8AEA-4F69-BE97-F7AB981AC3BF”,LineCreationSequenceNumber:2,ItemNumber:“99999999994”,OrderedSalesQuantity:2,SalesPrice:80.93,AVAPromotionCode:null,SalesUnitSymbol:“UN”,SalesProductCategoryName:null,AVALaserText:null,AVAWrappingText:null, original:{erpOrderNumber:“JEM-99999”,clientOrderNumber:“00118205”} } ] I have the following questions How do we remove the “original” object from the lines with expression language? How can we remove key "transactionId"and value from the lines with expression language? Once the original object is removed how can we convert the lines into an array with name “orderLines” with expression language? Thanks for your helpAlternative for group by Field snap in Ultra task
Hi, Can somebody tell me if there is an alternative for the group by field snap? I need to use that functionality in an ultra task and I know that the group by field snap is not compatible. What I need to get at is the following: Input: [ {“$id”:“1”,“company”:“es”,“accountNumber”:“4351”,“productCode”:“a000000011”,“productDescription”:“prod1”,“netPrice”:0.0,“currency”:“EUR”,“resultMessage”:“”}, {“$id”:“2”,“company”:“es”,“accountNumber”:“4351”,“productCode”:“a0000021a47”,“productDescription”:“prod2”,“netPrice”:190.630,“currency”:“EUR”,“resultMessage”:“”} }] Target: [{“prices”: [{“materialCode”:“a000000011”,“unitPrice”:0.0,“currency”:“EUR”,“priceType”:“MSD Price”}, {“materialCode”:“a0000021a47”,“unitPrice”:190.630,“currency”:“EUR”,“priceType”:“MSD Price”} }] }] Hope that somebody can help me? Thanks in advanced.3.8KViews0likes6Comments