CSV-to-JSON Conversion & API Integration
Budget: €100 – €300 EUR
CSV-to-JSON API Sender is a lightweight and user-friendly Windows application designed to run in the system tray. The program regularly reads large CSV datasets (up to 7-8.000 entries), converts them to JSON format, and sends them to a specified REST API endpoint. It provides a simple configuration interface and logs API responses for tracking purposes.
Key Features:
1. CSV Data Processing:
- Users can import a CSV file formatted as follows:
Field1;Field2;Field3;Field4
10808; 5; 7.32; 9.25
Data Conversion:
Field1: The article number is padded to 8 characters with leading zeros (e.g., 10808 becomes 00010808).
Prices: Prices in euros are converted to cents (e.g., 7.32 € becomes 732 cents).
The converted data is formatted as JSON:
[
{
"pzn": "00010808",
"amount": 5,
"discountPrice": 732,
"price": 925
}
]
2. Automated API Transfer:
The application sends the converted data in regular intervals (adjustable between 5 and 60 minutes) using a POST request to a hardcoded API endpoint.
Primary and Fallback Endpoints: The program uses a primary API endpoint and automatically switches to a fallback endpoint if the primary one is unavailable.
Response Logging:
API responses (such as status codes, error messages, and success confirmations) are logged in a log file.
The log file is updated continuously, allowing for easy monitoring and debugging of API communications. Log entries should be deleted after 30 days.
Configuration Window:
A small configuration window is accessible via the system tray icon, offering the following options:
File Selection: Choose the CSV file to be processed.
Transmission Interval: Set the data transfer interval (5 to 60 minutes).
API Key (APIKEY): Enter the API key needed for authentication.
System Integration:
The program runs unobtrusively in the system tray, with status notifications for user awareness.
Autostart Feature: The application launches automatically with Windows, ensuring seamless and continuous data transmission.
sources and dependencies have to be included in the handover, payment after own compilation from provided sources
Key Features:
1. CSV Data Processing:
- Users can import a CSV file formatted as follows:
Field1;Field2;Field3;Field4
10808; 5; 7.32; 9.25
Data Conversion:
Field1: The article number is padded to 8 characters with leading zeros (e.g., 10808 becomes 00010808).
Prices: Prices in euros are converted to cents (e.g., 7.32 € becomes 732 cents).
The converted data is formatted as JSON:
[
{
"pzn": "00010808",
"amount": 5,
"discountPrice": 732,
"price": 925
}
]
2. Automated API Transfer:
The application sends the converted data in regular intervals (adjustable between 5 and 60 minutes) using a POST request to a hardcoded API endpoint.
Primary and Fallback Endpoints: The program uses a primary API endpoint and automatically switches to a fallback endpoint if the primary one is unavailable.
Response Logging:
API responses (such as status codes, error messages, and success confirmations) are logged in a log file.
The log file is updated continuously, allowing for easy monitoring and debugging of API communications. Log entries should be deleted after 30 days.
Configuration Window:
A small configuration window is accessible via the system tray icon, offering the following options:
File Selection: Choose the CSV file to be processed.
Transmission Interval: Set the data transfer interval (5 to 60 minutes).
API Key (APIKEY): Enter the API key needed for authentication.
System Integration:
The program runs unobtrusively in the system tray, with status notifications for user awareness.
Autostart Feature: The application launches automatically with Windows, ensuring seamless and continuous data transmission.
sources and dependencies have to be included in the handover, payment after own compilation from provided sources