Hello Ankur! Many thanks for these tutorials. I am learning OIC too. These videos are life saver. I wish to do certifications too. Have sent you a request on LinkedIn :)
Hi ankur, I have one query i am using rest adapter and return response where in json I am getting one URL That url having zip file i want to read that file and upload that files into sftp Which adapter is helpful for this
Hi Ankur, many thanks for the video. I would like to invoke a SOAP provider from OIC and I expect to receive an attachment in response but looking at the wizard mapping it does not appear. Does OIC have the capability to handle it or maybe there are missing parts in uploaded WSDL?
@@TechSupper yes, from SOAPUI I can see the xml payload response and the attachment too, but can't see it in OIC mapping. Are we sure that OIC is able to accept this kind of content-type from a SOAP invoke?
Hi Ankur, I am trying to create a REST API that will return the file as an attachment and it will be exposed to external services. Can you please help me with the approach?
Hi Ankur, 1>>Is this something we can say uploading a file at run time instead of uploading a file manually through configuration wizard at OIC integration level .Please confirm.. 2>>what is that element called "Name" under the Parameter list -> Parameter -> Name In tracking variable assignment at 8:44 , I assume it is the file name which you have hard coded i.e, "temp.csv" in the writefiletostage at 3:57. Please confirm. 3>>I assume the writefiletostage does not worry about the file name as we just pass the sample.csv (at run time) to just dump it on the staging location "/temp" with the name "temp.csv".please clarify.
Hi Abhi, 1) Yes, you can consume this service from anywhere and upload the file into the service. 2) You can provide the parameter list along with the attachment. The name refers to the parameter name. 3) temp.csv file will be created at the staging area of OIC. See 6:31 where I using the same filename uploaded on the staging area. The filename parameter will contain the file name as "temp.csv"
very informative video. only a quick question... for executing the rest url in browser.. is there any specific setting. "test" and validate works for me.. but unable to call in browser
Hi I am getting unsupported media type error in OIC when trying to send json attachment to rest api. If I am using the same json attachment in postman it works fine. Could you please help me with it.
Hi, Please check the trace and see the Content-Type header value. What value is going there. You must send the correct media type. The error generally comes when you don't set the correct value Content-Type header. See in the postman what value you are sending in Content-Type header.
Hi Ankur... when I’m trying to run in postman. I’m getting “Internal Server Error”. I followed exact steps but Still I’m facing this issue. What could be the possible mistakes?
You can attached a file which is more than 10MB. See this docs.oracle.com/en/cloud/paas/integration-cloud/rest-adapter/rest-adapter-capabilities.html Please subscribe to my channel th-cam.com/users/Techsupper to get regular updates.
Hi Ankur, I am trying to upload a file but the rest api also needs some other QueryParameters such as token, username,pwd etc. The file is one of the parameters. Can you please tell me how to achieve this?
Hi Partha, If you want to pass username and password as a json payload then select and attachment, select the "Send Attachment in request" option from the REST adapter Request page and then select "Json Sample" option from the next drop down and give sample json. Regards, Ankur
Hi Ankur, Thanks for the information. I am looking for the requirement, where I need to send the zip format of csv file to a rest API. Can this be done as form-data or it should be binary only?
You can map attachmentReference to attachmentReference in the mapper. Just for your information, I have below Udemy courses that will help you to learn Oracle Cloud step by step. 1) Oracle Integration Cloud in Depth: The online course will help you to enhance your skillset with Oracle Integration Cloud with lot of real-time examples: www.udemy.com/course/oracle-integration-cloud-oic-in-depth/?referralCode=EE35C319CF22E23E7FD4 2) Process Cloud Service: This course is dedicated to the Process Cloud Service and will help everyone to learn PCS end to end with several good real-time examples: www.udemy.com/course/oic-oracle-process-cloud-service/?referralCode=21C3195B0C0E37817042 3) Oracle API PCS Cloud: The course is designed to teach you Oracle API PCS with a lot of examples. All concepts are covered in very depth end to end. www.udemy.com/course/oracle-api-pcs-platform-end-to-end/?referralCode=F55B56F964C25334E2EC 4) Oracle Visual Builder Cloud Service: With the help of this course, you will be able to build web and mobile applications that will help you and organization to extend SaaS applications. www.udemy.com/course/oracle-visual-builder-cloud-service-vbcs/?referralCode=BA1BCA38C23181358B15 5) 1Z0-1042-20: Oracle Cloud Platform Application Dumps: The course will help you to crack your OIC certification. Answers have been verified via different documentations and documentation links have been provided to verify the answer yourself. www.udemy.com/course/1z0-1042-20-oracle-cloud-platform-application-dumps/?referralCode=8EA851F35C2474C29C27
Glad it was helpful! Just for your information, I have below Udemy courses that will help you to learn Oracle Cloud step by step. 1) Oracle Integration Cloud in Depth: The online course will help you to enhance your skillset with Oracle Integration Cloud with lot of real-time examples: www.udemy.com/course/oracle-integration-cloud-oic-in-depth/?referralCode=EE35C319CF22E23E7FD4 2) Process Cloud Service: This course is dedicated to the Process Cloud Service and will help everyone to learn PCS end to end with several good real-time examples: www.udemy.com/course/oic-oracle-process-cloud-service/?referralCode=21C3195B0C0E37817042 3) Oracle API PCS Cloud: The course is designed to teach you Oracle API PCS with a lot of examples. All concepts are covered in very depth end to end. www.udemy.com/course/oracle-api-pcs-platform-end-to-end/?referralCode=F55B56F964C25334E2EC 4) Oracle Visual Builder Cloud Service: With the help of this course, you will be able to build web and mobile applications that will help you and organization to extend SaaS applications. www.udemy.com/course/oracle-visual-builder-cloud-service-vbcs/?referralCode=BA1BCA38C23181358B15 5) 1Z0-1042-20: Oracle Cloud Platform Application Dumps: The course will help you to crack your OIC certification. Answers have been verified via different documentations and documentation links have been provided to verify the answer yourself. www.udemy.com/course/1z0-1042-20-oracle-cloud-platform-application-dumps/?referralCode=8EA851F35C2474C29C27
Thanks Ankur for this wonderful series. While specifying flle, we can either give reference or name/directory. Is their any difference while choosing it or both works same way?
Hi Bhusan, Can you please let me know which step you are referring and please specify the time of video so I can move there and provide you specific answer.
Hi Smita, If you don't know the structure of data then opaque.xsd will help you to read such data. FYI, You can buy the below Udemy course to enhance your skillset. 1) Oracle Integration Cloud in Depth: The online course will help you to enhance your skillset with Oracle Integration Cloud with lot of real-time examples: www.udemy.com/course/oracle-integration-cloud-oic-in-depth/?referralCode=EE35C319CF22E23E7FD4 2) Process Cloud Service: This course is dedicated to the Process Cloud Service and will help everyone to learn PCS end to end with several good real-time examples: www.udemy.com/course/oic-oracle-process-cloud-service/?referralCode=21C3195B0C0E37817042 3) Oracle API PCS Cloud: The course is designed to teach you Oracle API PCS with a lot of examples. All concepts are covered in very depth end to end. www.udemy.com/course/oracle-api-pcs-platform-end-to-end/?referralCode=F55B56F964C25334E2EC 4) Oracle Visual Builder Cloud Service: With the help of this course, you will be able to build web and mobile applications that will help you and organization to extend SaaS applications. www.udemy.com/course/oracle-visual-builder-cloud-service-vbcs/?referralCode=BA1BCA38C23181358B15 Regards, Ankur
The video is not there as of now. If you want to learn you can buy my course that will have lot of use-full examples: www.eduonix.com/learn-oracle-integration-cloud Apply coupon code “ OICLEARN5” to avail discount.
Hi Ankur, It's very nice.. Many thanks for the sessions. I am trying to build INT for File Upload, but getting below error while execution from POSTMAN. Please do the needful. ERROR: { "type": "10.4.1", "title": "exception occurred while translating the request from native to xml.", "detail": "oracle.cloud.connector.api.CloudInvocationException: java.lang.ClassCastException: oracle.xml.parser.v2.XMLDocument cannot be cast to java.util.HashMap", "o:errorCode": "TRANSLATION-ERROR-00", "o:errorDetails": [ { "type": "NA", "instance": "NA", "title": "NA", "o:errorPath": "NA", "o:errorCode": "NA" } ] }
Hi Ankur, Thank you for the videos..... I am getting Error While reading file from Stage.... Can you pls help me in resolving the same.... faultName: {{schemas.oracle.com/bpel/extension}runtimeFault} messageType: {{schemas.oracle.com/bpel/extension}RuntimeFaultMessage} parts: {{ summary=Error while translating message to the mentioned format. Please make sure that the file content conforms to the schema. ,code=java.lang.RuntimeException ,detail=Error while reading and skipping native data. [Line=1, Col=108] Expected "${eol}" at the specified position in the native data, while trying to read and skip the data for "schema", using "headerLines" as "1" and "headerLinesTerminatedBy" as "${eol}", but not found. Ensure that "${eol}", exists at the specified position in the native data. } cause: {Error while reading and skipping native data. [Line=1, Col=108] Expected "${eol}" at the specified position in the native data, while trying to read and skip the data for "schema", using "headerLines" as "1" and "headerLinesTerminatedBy" as "${eol}", but not found. Ensure that "${eol}", exists at the specified position in the native data. }
Hello Ankur! Many thanks for these tutorials. I am learning OIC too. These videos are life saver. I wish to do certifications too. Have sent you a request on LinkedIn :)
Thanks Deb
Hello Ankur, Where is the staging file resides? Is it similar to FTP? Can you please help me with this.
On temp location of OIC server which you don't have access to.
Hi ankur, I have one query
i am using rest adapter and return response where in json I am getting one URL
That url having zip file
i want to read that file and upload that files into sftp
Which adapter is helpful for this
REST and FTP adapter
Hi Ankur, many thanks for the video.
I would like to invoke a SOAP provider from OIC and I expect to receive an attachment in response but looking at the wizard mapping it does not appear.
Does OIC have the capability to handle it or maybe there are missing parts in uploaded WSDL?
There would be in response. Are you able to download attachment if you invoke this SOAP api from SOAP UI?
@@TechSupper yes, from SOAPUI I can see the xml payload response and the attachment too, but can't see it in OIC mapping.
Are we sure that OIC is able to accept this kind of content-type from a SOAP invoke?
Hello Ankur, Could you also upload a video of downloading Supplier attachments and placing it in SFTP ?
Hi Ankur, I am trying to create a REST API that will return the file as an attachment and it will be exposed to external services. Can you please help me with the approach?
While you configure the REST adapter at Trigger, you need to choose the File attachent in response.
Hi Ankur,
1>>Is this something we can say uploading a file at run time instead of uploading a file manually through configuration wizard at OIC integration level .Please confirm..
2>>what is that element called "Name" under the Parameter list -> Parameter -> Name In tracking variable assignment at 8:44 , I assume it is the file name which you have hard coded i.e, "temp.csv" in the writefiletostage at 3:57. Please confirm.
3>>I assume the writefiletostage does not worry about the file name as we just pass the sample.csv (at run time) to just dump it on the staging location "/temp" with the name "temp.csv".please clarify.
Hi Abhi,
1) Yes, you can consume this service from anywhere and upload the file into the service.
2) You can provide the parameter list along with the attachment. The name refers to the parameter name.
3) temp.csv file will be created at the staging area of OIC. See 6:31 where I using the same filename uploaded on the staging area. The filename parameter will contain the file name as "temp.csv"
Hi Ankur ! Many thanks for the tutorials . I just have a doubt that is which credentials you are using while sending the request through POSTMAN?
Hi Sweta,
That will be OIC credentials
Subscribe to my youtube channel th-cam.com/users/techsupper if you have not subscribed yet.
HI Ankur, How can we handle the scenario where the attachment size is more than 10MB?
You can upload attachment up-to 1 GB.
Please subscribe to my TH-cam channel th-cam.com/users/Techsupper if you have not subscribed yet.
very informative video. only a quick question... for executing the rest url in browser.. is there any specific setting. "test" and validate works for me.. but unable to call in browser
Because you need to add attachments so can't be tested using browser.
Hi I am getting unsupported media type error in OIC when trying to send json attachment to rest api. If I am using the same json attachment in postman it works fine. Could you please help me with it.
Hi,
Please check the trace and see the Content-Type header value. What value is going there. You must send the correct media type. The error generally comes when you don't set the correct value Content-Type header. See in the postman what value you are sending in Content-Type header.
Hi Ankur... when I’m trying to run in postman. I’m getting “Internal Server Error”. I followed exact steps but Still I’m facing this issue. What could be the possible mistakes?
Can you send me the iar file.
Hi Ankur,
Our requirement is , we want to send the file as attachment but the file sometimes coming of more than 25 MB in size. How to deal with it?
You can attached a file which is more than 10MB.
See this docs.oracle.com/en/cloud/paas/integration-cloud/rest-adapter/rest-adapter-capabilities.html
Please subscribe to my channel th-cam.com/users/Techsupper to get regular updates.
Hi Ankur,
How to upload file in OIC instead of postman
During test you mean? If yes, you can test your interface from oic console and will give you an option to upload the file.
Hi Ankur , Thanks for the video. Can you please make video on how to download file from UCM using REST / SOAP ?
Sure, I'll try and update you.
Hi Ankur,
I am trying to upload a file but the rest api also needs some other QueryParameters such as token, username,pwd etc. The file is one of the parameters. Can you please tell me how to achieve this?
Hi Partha,
You want to expose a API or you are calling an API which required all these parameters.
Regards,
Ankur
Hi Ankur,
I am calling an API inside my scheduled integration. This api needs username, password and file.
Hi Partha,
If you want to pass username and password as a json payload then select and attachment, select the "Send Attachment in request" option from the REST adapter Request page and then select "Json Sample" option from the next drop down and give sample json.
Regards,
Ankur
Hi Ankur,
Thanks for the information. I am looking for the requirement, where I need to send the zip format of csv file to a rest API. Can this be done as form-data or it should be binary only?
Try with form-data
Hi Ankur, how we will pass attachments from one application to another application ex : oracle & salesforce
You can map attachmentReference to attachmentReference in the mapper.
Just for your information, I have below Udemy courses that will help you to learn Oracle Cloud step by step.
1) Oracle Integration Cloud in Depth: The online course will help you to enhance your skillset with Oracle Integration Cloud with lot of real-time examples:
www.udemy.com/course/oracle-integration-cloud-oic-in-depth/?referralCode=EE35C319CF22E23E7FD4
2) Process Cloud Service: This course is dedicated to the Process Cloud Service and will help everyone to learn PCS end to end with several good real-time examples:
www.udemy.com/course/oic-oracle-process-cloud-service/?referralCode=21C3195B0C0E37817042
3) Oracle API PCS Cloud: The course is designed to teach you Oracle API PCS with a lot of examples. All concepts are covered in very depth end to end.
www.udemy.com/course/oracle-api-pcs-platform-end-to-end/?referralCode=F55B56F964C25334E2EC
4) Oracle Visual Builder Cloud Service: With the help of this course, you will be able to build web and mobile applications that will help you and organization to extend SaaS applications.
www.udemy.com/course/oracle-visual-builder-cloud-service-vbcs/?referralCode=BA1BCA38C23181358B15
5) 1Z0-1042-20: Oracle Cloud Platform Application Dumps: The course will help you to crack your OIC certification. Answers have been verified via different documentations and documentation links have been provided to verify the answer yourself.
www.udemy.com/course/1z0-1042-20-oracle-cloud-platform-application-dumps/?referralCode=8EA851F35C2474C29C27
Thank you so much. Very useful!
Glad it was helpful!
Just for your information, I have below Udemy courses that will help you to learn Oracle Cloud step by step.
1) Oracle Integration Cloud in Depth: The online course will help you to enhance your skillset with Oracle Integration Cloud with lot of real-time examples:
www.udemy.com/course/oracle-integration-cloud-oic-in-depth/?referralCode=EE35C319CF22E23E7FD4
2) Process Cloud Service: This course is dedicated to the Process Cloud Service and will help everyone to learn PCS end to end with several good real-time examples:
www.udemy.com/course/oic-oracle-process-cloud-service/?referralCode=21C3195B0C0E37817042
3) Oracle API PCS Cloud: The course is designed to teach you Oracle API PCS with a lot of examples. All concepts are covered in very depth end to end.
www.udemy.com/course/oracle-api-pcs-platform-end-to-end/?referralCode=F55B56F964C25334E2EC
4) Oracle Visual Builder Cloud Service: With the help of this course, you will be able to build web and mobile applications that will help you and organization to extend SaaS applications.
www.udemy.com/course/oracle-visual-builder-cloud-service-vbcs/?referralCode=BA1BCA38C23181358B15
5) 1Z0-1042-20: Oracle Cloud Platform Application Dumps: The course will help you to crack your OIC certification. Answers have been verified via different documentations and documentation links have been provided to verify the answer yourself.
www.udemy.com/course/1z0-1042-20-oracle-cloud-platform-application-dumps/?referralCode=8EA851F35C2474C29C27
Thanks for such kind of videos. Could you please explain how can we get both attachment and payload.
Hi Arya,
See the video starting from 2:17. You will get your answer.
Regards,
Ankur
Thanks Ankur for this wonderful series. While specifying flle, we can either give reference or name/directory. Is their any difference while choosing it or both works same way?
Hi Bhusan,
Can you please let me know which step you are referring and please specify the time of video so I can move there and provide you specific answer.
@@TechSupper He is mentioning the mapper window at 6:28, I too have the similar question. please help us understanding this.
Hello Ankur !! how can we upload file into file storage using java program?
Try to explore the storage REST APIs.
What is the exact use of opaque.xsd?
Hi Smita,
If you don't know the structure of data then opaque.xsd will help you to read such data.
FYI, You can buy the below Udemy course to enhance your skillset.
1) Oracle Integration Cloud in Depth: The online course will help you to enhance your skillset with Oracle Integration Cloud with lot of real-time examples:
www.udemy.com/course/oracle-integration-cloud-oic-in-depth/?referralCode=EE35C319CF22E23E7FD4
2) Process Cloud Service: This course is dedicated to the Process Cloud Service and will help everyone to learn PCS end to end with several good real-time examples:
www.udemy.com/course/oic-oracle-process-cloud-service/?referralCode=21C3195B0C0E37817042
3) Oracle API PCS Cloud: The course is designed to teach you Oracle API PCS with a lot of examples. All concepts are covered in very depth end to end.
www.udemy.com/course/oracle-api-pcs-platform-end-to-end/?referralCode=F55B56F964C25334E2EC
4) Oracle Visual Builder Cloud Service: With the help of this course, you will be able to build web and mobile applications that will help you and organization to extend SaaS applications.
www.udemy.com/course/oracle-visual-builder-cloud-service-vbcs/?referralCode=BA1BCA38C23181358B15
Regards,
Ankur
Hi Ankur
Can you plz provide BIP reports using oic integrations
The video is not there as of now. If you want to learn you can buy my course that will have lot of use-full examples:
www.eduonix.com/learn-oracle-integration-cloud
Apply coupon code “ OICLEARN5” to avail discount.
Hi Ankur, It's very nice.. Many thanks for the sessions.
I am trying to build INT for File Upload, but getting below error while execution from POSTMAN. Please do the needful.
ERROR:
{
"type": "10.4.1",
"title": "exception occurred while translating the request from native to xml.",
"detail": "oracle.cloud.connector.api.CloudInvocationException: java.lang.ClassCastException: oracle.xml.parser.v2.XMLDocument cannot be cast to java.util.HashMap",
"o:errorCode": "TRANSLATION-ERROR-00",
"o:errorDetails": [
{
"type": "NA",
"instance": "NA",
"title": "NA",
"o:errorPath": "NA",
"o:errorCode": "NA"
}
]
}
Hi Venkat,
Not much clear from the error. Please update the complete stack trace to look into it.
Regards,
Ankur
Hey Ankur....can we use this method for uploading zip file??
Yes you can
@@TechSupper So what I will Give in schema definition for zip file??
Hi Ankur, Thank you for the videos..... I am getting Error While reading file from Stage.... Can you pls help me in resolving the same.... faultName: {{schemas.oracle.com/bpel/extension}runtimeFault}
messageType: {{schemas.oracle.com/bpel/extension}RuntimeFaultMessage}
parts: {{
summary=Error while translating message to the mentioned format.
Please make sure that the file content conforms to the schema.
,code=java.lang.RuntimeException
,detail=Error while reading and skipping native data.
[Line=1, Col=108] Expected "${eol}" at the specified position in the native data, while trying to read and skip the data for "schema", using "headerLines" as "1" and "headerLinesTerminatedBy" as "${eol}", but not found.
Ensure that "${eol}", exists at the specified position in the native data.
}
cause: {Error while reading and skipping native data.
[Line=1, Col=108] Expected "${eol}" at the specified position in the native data, while trying to read and skip the data for "schema", using "headerLines" as "1" and "headerLinesTerminatedBy" as "${eol}", but not found.
Ensure that "${eol}", exists at the specified position in the native data.
}
What you have mapped while writing on the stage ? Is this Filereference ?
subtitulos por favor