Mapping
Discussion List
-
How to Receive Multi-Part Form Data Json File as Attachment and Insert Data to DB TableContent How to Receive Multi-Part Form Data Json File as Attachment and Insert Data to DB Table? Please advise if anyone has any pointers/blogposts/solution in transform…Shivakumar Ayyanagowdar-Oracle 16 views 4 comments 0 points Most recent by Shivakumar Ayyanagowdar-Oracle Integration
-
Do we have possibility to read and write an excel file in OICSummary Do we have possibility to read and write an excel file in OICContent We have 2 requirements: 1. To read an excel file, process the data 2.To write an excel file …
-
How to send response from global faultContent Hi All, I have build a one app driven integration where in the trigger rest connection i have provided the request and response payload.If some thing error occur…
-
Convert Comma Separated into OR delimiterSummary Convert Comma Separated into OR delimiterContent Hi, I am currently doing a logic on changing the data format from: "listOfAccountNumbers" : "0000001, 000002, 00…
-
Using lookup-xml in integrationsContent Hi, I've been trying to implement a solution which needs to join data from two different files. File A contains business data and File B(xml) contains reference …
-
How to lookup a value in one xml based upon some key in another xml in ICSSummary looking for example to use lookup-xml functionContent Hi ICS community, We would like to lookup a value from one xml (response received from a REST call) based u…
-
OIC - Create a "fault handler integration" - invoke an integration with a fault objectContent Hi, I have some common faults that may arise in different integrations or different scopes of a same integration. The way to handle these faults would be the sam…
-
Execute select statement on an Oracle Database using variables for limit and offsetContent Hello, I need to execute a select statement on an Oracle Database using variables for limit and offset, but trying to execute the select like in the attached ima…
-
ForEach ending before iterate all dataSummary Foreach ending on iteration 8 instead of 16 without showing errorContent Hello, I attached an excel file that is being interated in a for each composite in OIC..…
-
traversing the rest response in OICSummary reading rest response of particular attributesContent Hi Folks, I am working on a poc and getting rest response as below. My requirement is to read the AccountNu…
-
How To Schedule a Integration at the end of every monthContent Hi Expert, I want to schedule a integration at the end of every month.Can Anyone share me the steps and also the ical expression. Regards, Pritam
-
Migrating Integration to ICS to OIC one of Invoke adapter giving error and not saving.Summary Integration is working in ICS and that integration migrated to OIC . It is not giving configure option and having draft . When edit and save then it is giving er…
-
How to process multiple files in same directorySummary How to process multiple files in same directoryContent I have a directory in FTP called Student in which there are three files Programs, Courses and Terms. All t…
-
How to Convert date into YYYY/MM/DD HH24:MI:SSContent Hi All, I have a requirement where i need to change the source file date format into YYYY/MM/DD HH24:MI:SS in the mapper. Thanks ,
-
CASDK-0041: An error occurred while invoking the REST endpoint.Summary We are running OIC to push files from UCM to Azure. For some of the files we are getting this errorContent Fault Details :
-
How to get the AP invoice report that is generated in the fusion to send as attachment in email viaContent Hi All, Our Requirement is to get the AP invoice report that is generated in the fusion to send as attachment in email via OIC. so how we can implement the use c…
-
How transform application/x-www-form-urlencoded to JSON payload using stage file?Content Hello, An external system invoking OIC with the request content-type application/x-www-form-urlencoded. After decode the reference to string, how do I map to eac…
-
Get the node value from a repeted node.Summary I want to get the href value from a payload that have several href in the response. Is there a function to be used on the map operator to get just the first ocur…Rodrigo Leonel Sartorato-162426 26 views 9 comments 1 point Most recent by Rodrigo Leonel Sartorato-162426 Integration
-
Hanlde dynamic REST response in OICContent Hi Experts, I'm calling the external REST API in OIC which returns the dynamic response as below: Response-1 { "name":"Ankur", "age":1 } Response-2 { "contact":"…
-
Configure Trigger REST adapter to accept text/html response bodyContent Hello, I am trying to configure a trigger rest adapter to call an external API that returns a XML text as the response but with the content-type text/html. How s…
-
OIC mapping - XPath expression failureContent Getting back to working on this project after almost a year. Via this forum, Hemanth helped me create parent/child xsd's (attached) for a multi-namespace xml pay…
-
source ID not available in the database record, we have to collect the missing source ID and we haveSummary source ID not available in the database record, we have to collect the missing source ID and we have to send those IDs to the source.via email.Content Hi, I have…
-
How to return custom error response from default handlerContent Hi All, I have created an app driven integration for creating a requisition where end user will pass the request payload and in the response i am passing the req…
-
Lookup Table Column in ForEach ActivityContent We don't have any database, so storing list of eligible BU in the lookup with some other fields. I want to use this table column (lets say BU) as ForEach Rowset.…
-
How to skip mapping for a particular value in mappingContent Hi All,- I have a one requirement where i have to create requisition using SOAP web-service. The scenario is end user will send supplier item number and i am dir…
-
How to unzip the .iar file using WinZip softwareContent Hi All, After exporting the integration i want the mapping file so that i can edit the mapping the notepd++.How can i unzip the .iar file and get the mapping fil…
-
Assign JSON Array in MapperContent I have a requirement where I need to map JSON array to an object in Mapper. I am attaching the screenshots, please guide if there is any easy way or any workarou…
-
OIC substitution to SOA || Simple and Complex Integration || Oracle Service BusContent Hi team, I have three queries regarding integrations. Firstly, what do we mean by simple and complex integrations? I have seen in many blogs being mentioned that…
-
Parse a file with trailer in OICSummary Parse a file with trailer in OICContent Hello I am trying to parse a file with trailer in OIC. Since the format of the trailer line is different to the other dat…
-
Aggregation Using For-Each-Group in MapperSummary Aggregation Using For-Each-Group in MapperContent I have the following data input: AAA Line 1 1000 2020-04-01T00:00:00Z BBB Line 2 100…