Dheeraj
Employee
Joined 9 years ago
User Profile
User Widgets
Contributions
Re: Value increment for each execution
@pjanapati Please refer to this post Pipeline expression building Designing Pipelines Hi In Database i have field called “Product_ID” i need to update the field with ‘P-00001’ when i execute the first time and Second time when i execute the field should be updated with ‘P-00002’ please give me an solution how to implement using which snap. Thanks in Advance !!2.6KViews0likes1CommentRe: Reading JSON Format
@amit.saroha I have copied the JSON Splitter to a JSON Generator snap and the following expressions works fine in a mapper jsonPath($, "$[?(value['ns0:IntegrationName']=='EBSPERSON')]['ns0:ContentId']") Also, attaching the pipeline just in case you need it for reference Test Expr - Community_2022_06_29.slp (4.9 KB)1.5KViews0likes1CommentRe: Reading JSON Format
@amit.saroha Hope this helps jsonPath($, "$[?(value.Document_ID.startsWith('EBSPERSON_'))].Document_ID") The idea is to use the filter operator. It will select all the element/s in the Array that match the given expression. In the above example, my filter condition is based on the value of ‘Document_ID’1.4KViews2likes7CommentsRe: Reading JSON Format
@amit.saroha I won’t be able to validate your pipeline as it needs accounts to connect to the systems. In scenarios like this, it would be great if you can export the data to a JSON generator snap and work on the expressions it would be a lot simpler and easier to debug. I am attaching a sample pipeline where I tried to replicate your data and worked on the expression. Test Expr - Community_2022_06_28.slp (3.6 KB)1.7KViews0likes1Comment