#Oracle to API using POST: This project retrieves data from an Oracle database table using Python with the pyodbc library. It processes the information using Pandas, converts the Oracle data into a CSV file, and inserts this CSV file into an API using the POST method. The insertion logic also takes into account holidays and datetime adjustments.

This project is useful for automating the continuous insertion of data into an API.

#Configuration: Create a .env file in the root directory of the project with the following environment variables:

'DATABASE' = 'CENTRAL' 'DB_USER' = 'age' 'DB_PASSWORD' = 'age' 'API_KEY' = '2e16d30c-13a8-4019-91f3-d716b8d82894'

#Usage: Run the script to collect data from Oracle and insert it into the API using POST:

python main.py