---
title: "Automatic Custom Code Upload via Middleware"
slug: "how-to-set-up-automatic-custom-code-upload-using-middleware"
updated: 2022-05-26T06:59:22Z
published: 2022-05-26T06:59:22Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://success.panaya.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Automatic Custom Code Upload via Middleware

This article explains how to how to set up automatic custom code upload using Middleware For other methods, [click here](/v1/docs/how-to-implement-automatic-custom-code-upload-using-api)

**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](/v1/docs/check-out-panayas-support-portal) 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](/v1/docs/how-to-download-panayas-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](/v1/docs/check-out-panayas-support-portal) 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