How to check SQL status code after performing a 'Select' ?
How can I check if an 'Oracle 'select' snap returned any results? I need this to determine if I should set the output to "Customer not found" when results are null.
Forum Posts
AI Pipeline from Integreat 2023
HiDoes anyone have the pipeline from the London Integreat 2023 afternoon session technical demo: “Automating Business Proceses using Generative AI”.The one where there was a HTTP request made to the Bedrock API in AWSThanksClinton
Resolved! Invalid Snap Output
Please I am trying to understand the behavior and difference between these two snap set-ups. Any explanation will be appreciated. What exactly is the function of the tail snap? Thanks.
Resolved! REST Get delay between making calls as documents come in (not pagination or retry)
Hello, For the REST Get snap, there’s a feature to set a delay interval between Pagination and Retry calls, but what about just between regular calls as documents come in? All calls to REST can be rate limited, not just pagination calls. Do I have ...
Performing an Action when there is no data
A common integration pattern is to do something when no data is received. For example, we might read a file, parse it, and find that no records meet some filter criteria. As a result, we might send an email, or insert a ticket into a ticket managemen...
In XML Document how to replace \\ by \
Hi,The Input data is in XML format, There are multiple array and inside that in some of field contains double slash and need to replace it with single , we tried to build json expression like below in mapper:Can anyone help with this.if anyone have a...
Join array of Objects
Hi ,I have a requirement to join the array1 with array2 in the same document and fetch one column from array 2 into array1 if condition matches. I can do it by splitting the arrays and join them back again. I would like to to know if i can do it in m...
Resolved! Changing the key names dynamically
Hi,I have a requirement where we need to read 50 tables from oracle and put the data to postgres. there is no transformation logic in between . But issue is while loading to target the column names are slightly changing. for an instance , src_table1{...
