E9.2 Integration of Media Files (PDF) - Orchestrator / Without Orchestrator using REST API

coolkl

Active Member
Hello All,

For Orchestrator I understand doesn't support media files such as PDF for integration as per Doc ID 2554263.1 .

After going through Oracle, I find there is an alternative - E1: AIS: How to Upload a Media Object Attachment Using Javascript and the /file/upload AIS REST API (Doc ID 2720570.1). I am trying to explore this alternative as we need it for one of our requirements.

Requirement - To embeded Invoice from 3rd party application saved on FTP into JDE Order

Does anyone have experience doing media object integration with / without Orchestrator i.e JavaScript ?

Any help is appreciated.

Thanks.
 

lfurino

Member
I have done this using a regular REST call using Talend API Tester (you could use POSTMAN, SOAPUI, etc.)

I think you should be able to do this in Orchestrator with and FTP connector that gets the file and then passes that to a REST Connector in Orchestrator. In theory that should work, but I have not specifically tried that use case yet.

-Larry
 

coolkl

Active Member
Thanks Larry. I am working to try this out. Just clearing my thought process. This is what are understand.

1. So the FTP connector will read the file,
2. Do we save the file to fileserver or some location ?
3. REST API, I understand is as below will upload to media objects.

Upload File Attachment v1

POST
/file/upload
Upload a file type media object for the given structure and key. The 'moAdd' parameter takes a JSON string in the form of the MediaObjectUploadRequest class

Request​

 

lfurino

Member
Yes. Your thinking is correct, but I would recommend working backwards. Start with the API call to upload a local PDF file using an external REST client. When you use the FTP connector it will save the file in a temp folder on the AIS server.

Regards,
Larry
 
Call Orchestrations From Excel – The Easy Way to Make the Orchestrator Work for You.

coolkl

Active Member
Yes. Your thinking is correct, but I would recommend working backwards. Start with the API call to upload a local PDF file using an external REST client. When you use the FTP connector it will save the file in a temp folder on the AIS server.

Regards,
Larry
Thanks Larry for your reply. I am testing this out and will get back with my findings.
 

sheeba

Reputable Poster
Thanks Larry for your reply. I am testing this out and will get back with my findings.

Coolkl - were you able to get this requirement to work? We have a similar or rather same requirement where business wants to attach PDFs from a folder onto the AP voucher ( PDF has voucher number and key values on the file name )

if you were able to get this to work - can you please outline the steps that worked for you . Would appreciate your help with this a lot .
 

sheeba

Reputable Poster
Yes. Your thinking is correct, but I would recommend working backwards. Start with the API call to upload a local PDF file using an external REST client. When you use the FTP connector it will save the file in a temp folder on the AIS server.

Regards,
Larry
Larry - would you be able to outline the steps for me please ?

Here’s what we have
1. Pdf files with voucher number on their file names
2. We can parse those file names and get the voucher numbers
3. We are trying to find out the best way to attach the PDFs onto AP vouchers

we are on JDE 9.2 TR 9.2.4.3 ( we have just started using orchestrations )

Would appreciate help from anyone who’s tried something like this in the past .

thanks in advance to both Larry and coolkl - hope you guys will help me on this .

thanks
Sheeba
 

coolkl

Active Member
Larry - would you be able to outline the steps for me please ?

Here’s what we have
1. Pdf files with voucher number on their file names
2. We can parse those file names and get the voucher numbers
3. We are trying to find out the best way to attach the PDFs onto AP vouchers

we are on JDE 9.2 TR 9.2.4.3 ( we have just started using orchestrations )

Would appreciate help from anyone who’s tried something like this in the past .

thanks in advance to both Larry and coolkl - hope you guys will help me on this .

thanks
Sheeba
I replied to your other post. Ability to use variables is in 9.2.5.x.

9.2.4.3 has limited ability. Let me know if any other details required.
 

sheeba

Reputable Poster
I replied to your other post. Ability to use variables is in 9.2.5.x.

9.2.4.3 has limited ability. Let me know if any other details required.
Noted thanks - I was able to find a workaround to get this done without the Orchestrator for the time being by using API to insertMOobj file into the MODAT. Thanks for your response thou. Appreciate that
 
Top