Contents x
    Automatic Custom Code Upload via Middleware
    • 1 Minute to read
    • Print
    • Dark
      Light
    • PDF
    Contents

    Automatic Custom Code Upload via Middleware

    • 1 Minute to read
    • Print
    • Dark
      Light
    • PDF
    Article Summary

    This article explains how to how to set up automatic custom code upload using Middleware
    For other methods, click here

    Prerequisites

    • TLS 1.2 protocol support 
    • Oracle EBS DB version 12.1.0.2 and above

    Before you continue

    • It is highly recommended to set up the Middleware connection on a demo Panaya system.
      Contact Panaya Support to set up a Panaya demo system. 

    Important

    • Use a Panaya administrator user with the API Execute and Code Box - Upload ETL permissions
    • Retrieve your system ID from Panaya Support or by using an API Call command
    • Use Postman, CURL, or another similar tool to test the upload before configuring your Middleware
    • The API upload limit is 2 per day. When performing connection tests, request Panaya Support to increase the limit to up to 20 calls per day
    • File upload is done in multipart/form-data
    • Postman/Curl automatically retrieves HTTPS certificates, if your system requires manual installation of certificates, download the Panaya certificate and install it prior to initiating any calls.
    • In case Proxy is defined for your server, your Middleware should include the user/pass/URL:port of the proxy in order to reach the Panaya site.

    Good to Know

    • After a file has been uploaded to Panaya and begins processing, a new file cannot be uploaded until the first upload has been processed.
    • If you try to upload a new file during the processing of a previous upload, you will receive the following error message -
       "status":"401", "error":"Unauthorized", "cause" :"ETL is currently processed on Panaya server.", "panaya_code":"4019"
    • If you see this message, contact Panaya Support in order to reset the automatic upload process

    The process of uploading an extraction file to Panaya consists of the following steps - 

    1. Generate an extraction file by running the extraction process
    2. Scheduling the extraction process - this automates the creation of the extraction file on schedule (e.g. Once a week)
    3. Authentication - the middleware will authenticate with the Panaya account via the login API method and receive a token
    4. Upload the middleware will fetch the file from its location and upload it via the upload ETL API method


     

     

    What's Next