For partners that build or integrate commercially available applications and service solutions with the Oracle Cloud Platform
For partners that provide implementation or managed services around Oracle Cloud Applications
I am already using the "throw new fault" element, but the exception that this element is throwing is a system exception not a business exception.
As we can see in the next image, I checked so that only system exceptions follow this flow (see figure 1)
But when I run the process and it calls the integration that has a global fault handler where a system exception is throwing through the "throw new fault" element and not a business exception as mentioned earlier here in the forum. We can see this in the following images of process and integration tracking: (see figure 2 and 3).
How do I set the "throw new fault" element to throw a business exception?
The only possible settings on the element are these: (see figure 4)
Clear, many thanks.
Much appreciating your continouns support.
The incoming response will be a JSON only and not XML, it's just soapUI that shows in the format. Look at the raw tab as I said earlier, that is how the response will be streamed.
You just map the element status from the invoke response to the request element of next invoke. You will see the data passing through.
I need to have the response as application/json, so that I can assign the response directly to the calling application. The calling application can parse and assign json only, not xml.
I mean, can I have the response as:
{ "status" : "1"}
instead of:
<data contentType="multipart/mixed; charset=UTF-8" contentLength="390"><![CDATA[{ "status" : "1"}]]></data>
So what exactly is the question here? Look at raw tab of your SoapUI, you will see both JSON and attachment and that is how multipart/mixed works.
I've already done so. Please check the screenshots.
The configuration looks correct. The actual content type is multipart/mixed for your response and the chosen option is correct. Upload the sample JSON seen in response
{ "status" : "1"}
in the enter sample JSON and adapter automatically handles it - both attachment and response.
Many thanks
Hi Hemanth,
Sorry, I missed to provide the info:
000PAM222604659MOWBRAY, SWATHY 101456 050 20191208 005
000PAM222604659MOWBRAY, SWATHY 101456 050 20191208 006
000PAM181621801BOYER, LACEY 103958 075 20191208 001
In the above data: POSITION 46 i.e column with data 101456, 103958 are person number, i need to get the unique person number with the latest ID field: i.e. 006
In the above i need to get the record 101456 with 006 id
Not enough information. How would I know which records to compare to pick the latest ID? What's the filter criteria here?
Also please provide what you tried, to understand and help if it contains any flaw to fix.
The response from the REST API is appended to StageWrite activity of csv.
Where is the stage file created first? Inside loop? You should first create empty stage file and then append it or create a variable before loop, assign the file reference within loop to the variable and then use it after loop.
Share the updated iar, icsflow logs for the tested instance to look at.
Hi Hemanth,
I was able to identify the issue:
1. List file feature was working, the issue was i was doing, for-each action, where i missed the current file.
2. List file allows to put the file name in the mapper, while wirte file lets us only to put the file name in the write adapter and not in the mapper.
Did the same and LOOP now stopped working at all.
Use the exact same payload response you get in SOAP UI and apply for-each on items.