Table from the API to Postgresql once a hour
Apply simple - I will download access in a personal message.
The script must be written in Python and installed on the VPS on the yupunt. To update the table it will have to be in a live database.
First, you will need to extract all the data from the App table that was uploaded before the script began to work.
Also, an algorithm should be developed that will ensure that even if the script could not be launched and was launched in a few hours - the data collected during that time will be loaded into the table.
It is also necessary to send a warning if the script has fallen.
Client's review of cooperation with Eduard Karpets
Table from the API to Postgresql once a hourThank you ! It’s not the first time we work, it’s all fine.
Freelancer's review of cooperation with Mar R.
Table from the API to Postgresql once a hourPleased with cooperation.
I recommend it.
Current freelance projects in the category Databases & SQL
Need a Power BI specialist to build management reporting based on BAS Accounting CORPAbout the CompanyWe are a distributor of international sports brands in Ukraine. Accounting is maintained in BAS Accounting CORP.We are looking for a specialist who can help build a management reporting system for the company's management based on Power BI.Important: we are… Databases & SQL, Accounting Services ∙ 9 hours 29 minutes back ∙ 3 proposals |
Excel Specialist / Process Automation (Excel + preferably programming)We are looking for a specialist with ADVANCED knowledge of Excel to optimize the existing file and automate processes. It will be a great advantage if you also have programming skills / VBA / Power Query / Power Automate or experience in creating complex logic in Excel. Project… Python, Databases & SQL ∙ 11 hours 20 minutes back ∙ 29 proposals |
Technical task: Integration of Telegram chatbot with BAS1. General Description It is necessary to implement the integration of the chatbot with the BAS system for the transfer and recording of data about products (orders). 2. Input Data (sent by the chatbot): Group ID Product name (with product code) Product price 3. Logic of… Enterprise Resource Planning (ERP), Databases & SQL ∙ 12 hours 27 minutes back ∙ 16 proposals |
1C data integrationOrganize quality preparation and data transfer from 1C to BigQuery for further use in Looker:Organize the data according to the required fields.Prepare a clear structure of tables and intermediate datasets on which dashboards will be built.Set up data loading, gather key… Databases & SQL, Data Processing ∙ 2 days 3 hours back ∙ 9 proposals |
Development of a simple controlling and management record system in Google Sheets "turnkey"Task name: Development of a simple controlling and management record system in Google Sheets "turnkey" for a construction company in Poland (+ online training and implementation assistance) About the company, context, and my main problem Hello, I am looking for an experienced… Databases & SQL, Accounting Services ∙ 3 days 8 hours back ∙ 35 proposals |