Write File using FTP Adapter in OIC

[@RathoreFitnessAndNutrition]

Nice explanation 👍

[@TechSupper]

Thanks 🙂

[@abhishek-bb6vg]

Hello, Question1 :Please explain what is top level array . Question2: Please correct me if i'm wrong with below understanding. you map the values to repeat element(2 of 2) at time 7:57 instead of 1 of 2 since (1 of 1) is a header part in the CSV file and 2 of 2 is actual data. Top level array concept comes because the json file is in Array format. Question3: What are record set name and record name shown in FTP file content definition(as I can see the record set name and record name in the target window mapping at 7:57). I guess sample.csv that you uploaded only for structure purpose. please confirm. Question4: At 8:50 you hard coded the status value on the target but I could not see you map the source to target.Please confirm have you map it or not .If map it ignore kindly question 4

[@TechSupper]

Ans1) When you provide an unnamed array as sample json, it shows top-level array node by default which indicates it's node is an array type. Ans2) It's correct Ans3) That's correct. RecordSet Name becomes the parent node and Record name becomes the child node in target mapper. Ans4) Just hardcoded value as a response. We have mapped the actual data at 7:57

[@abhishek-bb6vg]

@@TechSupper Thank you so much Ankur Jain, for the clarifications.

[@TechSupper]

You're Welcome.

[@usiuelali]

Hi Ankur, I tried the steps mentioned in this video but I a getting error at the zip file stage activity saying "/temp" folder not found where we are downloading it to ICS temporary location.

[@TechSupper]

Which folder path you have given while writing the file on stage and what path you are using to zip the folder on stage.

[@jithintv]

Life saving video !

[@TechSupper]

Thanks

[@kostaresepe9418]

Hello ankur can we write .pdf file or any other adapter for .pdf file generation?

[@TechSupper]

You can't generate the PDF directory from OIC, but here is the approach: 1) Create a function in Oracle OCI that takes inputs (name, email address..) and generates pdf as expected and return the PDF output 2) Call the function REST API in OIC 3) Extract the pdf from function REST API and attach it to HTML Here is the sample reference blogs.oracle.com/integration/post/how-to-invoke-an-oci-function-from-the-oracle-integration-cloud.

[@omarc429]

Hi. When transferring files from cloud to an external sftp Linux server via the agent, what will the ownership and permissions of the files be set to once they have landed on the target sftp Linux server?

[@TechSupper]

If this is read only then I guess, read only permission is required.

[@omarc429]

@@TechSupper will files be automatically created as oracle user.

[@TechSupper]

I didn't check this, try this yourself and see the permission.

[@omarc429]

@@TechSupperThanks. Your uploads are very informative. If 3rd party triggers an integration through API which has 2 steps, 1. Create extract file & 2. Transfer file to 3rd party sftp server. Can we call a API to monitor the status of each of these steps and determine success or failure? Do you have any uploads for this content? Thanks

[@TechSupper]

No, there is no such API to montior things step by step.

[@MrVenkatesh182]

Can you please let me how the mapping should be done when I have more than 10 records in the source file. Should we repeat the node as you have shown in the video?

[@TechSupper]

Hi, Map the array element from source to target which will do for-loop automatically. Regards, Ankur

[@monicasosa3117]

@@TechSupper Example please

[@MohsinKhanSC]

What are the details you are giving in REST Conn? are you using any public API?

[@TechSupper]

Hi Khan, I'm using public REST API to create connection jsonplaceholder.typicode.com/

[@moumitasarkar8993]

Hi ankur, can you please let me know if I can read a file in OIC from my local machine? How do we do that? I have a sample file which i need to process and generate more files as an outcome.

[@TechSupper]

Hi Moumita, Yes you can do for sure. Install the connectivity agent on your local machine. Create a File adapter and use the file adapter to read/write on your local machine. Regards, Ankur

[@TechSupper]

Thanks. You can buy the Udemy course which will help you You can buyd Udmey course to learn Integration and VBCS in more detail www.udemy.com/course/oracle-integration-cloud-oic-in-depth/?referralCode=EE35C319CF22E23E7FD4 Apply coupon code "TECHSUPPER" and get flat 30 % discount Reards, Ankur

[@karthikMahadev01]

How to use XSLT date functions in Mapping

[@TechSupper]

as the normal function, you can drag and drop the date time function on the required target fields.

[@karthikMahadev01]

SAMPLE_YYYYMMDD(Current Date)_449012.txt How to do this function in mapper using concat

[@TechSupper]

concat('Sample_', current-DateTime','.txt'). Please see the exact function name.

[@karthikMahadev01]

@@TechSupper How to use XSLT date functions in Mapping