Cnet deploy sql express databaseงาน

1.พัฒนานะบบ IOT ดึงข้อมูลจาก PLC แล้วนำมาแสดงผลในรูปแบบ Web Site โดยแสดงข้อมูลเป็น Real Time 2.สามารถใช้อุปกรณ์ของของบริษัท (Embedded PC) มี SIM ออก Internet ได้ หรือสามารถใช้อุปกรณ์ที่ผู้พัฒนาถนัด แต่ต้องเป็นอุปกรณ์ที่ทนต่อสภาพการใช้งานในโรงงานครับ (ความร้อนและฝุ่น) 3.สามารถใช้ Server ของบริษัทได้ สามารถเลือกได้ตามความถนัดแบบ Windows / Linux และ Database SQL , MySQL, MogoDB , InfluxDB เลือกได้ตามความถนัดครับ 4.เก็บข้อมูลไว้ดูย้อนหลังได้ 90 วัน

ทำระบบการเลี้ยงปศุสัตว์ (Livestock Management) นำเสนอเบื้องต้นของ Development Tools: Front-end: Angular JS Language: .Net Core (Web responsive) Database: SQL Server/Azure SQL Database Operation System: Windows Cloud Solution :Hybrid Azure

ต้องการสร้างแอพ Xamarin (Cross Platform) เชื่อมต่อฐานข้อมูล Mssql ดึงข้อมูลจาก แสดงข้อมูลจากฐานข้อมูลพร้อมรูบ และ ทำระบบ Login

...เป็นงานระยะยาว ระยะเวลา 6 เดือน – 1 ปี c. การเชื่อมต่อกับระบบเดิม เชื่อมผ่าน MS SQL Server และ REST Api รูปแบบข้อมูล JSON ทั้งหมด d. การแก้ไข ระบบเดิม จะทำโดย programmer คนเดิม ไม่เกี่ยวข้องกับระบบใหม่ e. Source code และสิทธิ์ใน source code ทั้งหมด เป็นของผู้ว่าจ้าง f. ผู้ว่าจ้าง ต้องการเข้าถึง repository ของ source code ด้วย เพื่อประโยชน์ในการ review ป้องกันการสื่อสารผิดพลาด g. Platform NodeJS และ deploy บน Docker หรืออื่นๆ ที่เป็นรูปแบบที่คล้ายกัน h. แยกส่วนแสดงผล (client javascript) และส่วน Api (REST Api อย่างชัดเจน) 2. ระบบเดิม เป็น program บน Windows เป็นภาษา C# .Net framework และ MS SQL server a. เมื่อสั่งซื้อสินค้า จะสร้างข้อมูลการสั่งซื้อใน MS SQL Server และมีใบ PO ออกมา b. เมื่อรับออเดอร์แล้ว จะสร้างข้อมูลใน MS SQL Server และพิมพ์ใบงานส่...

ต้องการ programmer สามารถเขียนคิวรี่ SQL และทำ report ระยะเวลาจ้าง 1 เดือน มานั่งทำงานร่วมกับ Programmer ของบริษํท ที่ทำงานตั้งอยู่ที่ปากซอยเพชรเกษม69 Victoria Garden ติดต่อที่ คุณท็อป [Removed by Freelancer.com Admin]

โปรแกรมสามารถแสกนลายนิ้วมือได้ โดยเชื่อต่อกับ SQL Server เมื่อลงเวลาออกสามารถ auto export file เป็น text ออกมาได้ (ต้องมีการคุยรายละเอียดกันอีกที)

Application ที่องค์กรใช้ มี ระบบ Database ใช้ MS SQL

- พัฒนาโปรแกรมโดยใช้ภาษา ASP.NET C# , Microsoft SQL Server - พัฒนาระบบเป็น web base application โดยมีเพียงส่วนของ UI และ Call Method ผ่าน Web Service - ไม่มีส่วนของ database design ,database create , database retrieve, database update , database delete - Design Web Page เรียบง่าย ใช้งานสะดวก ไม่เน้นลูกเล่น มี Concept , มีรูป ให้ 1. รถยนต์มือสอง 1.1 Download excel file format การกำหนดราคา รถยนต์มือสอง 1.1.1 Download excel file ใน Format ของการกำหนดราคา โดยเลือกเงื่อนไขได้ 2 วิธี 1.1.1.1 เลือกตามยี่ห้อ สามารถเลือกได้มากกว่า 1 ยี่ห้อ 1.1.1.2 เลือกตาม segment เลือกได้ครั้งละ 1 segment 1.1.1.3 ถ้ามีราคาที่เคยกำหนดในระบบให้แสดงด้วย 1.1.2 แสดงรุ่น รุ่นย่อย...

การทำงานตามคลิปที่ส่งให้ดูครับ เรื่องการออกแบบก็ประมาณนี้ -สามารถสมัครสมาชิกได้ (แยกระหว่าง user และ owner / loginด้วยfacebook ได้) -ทำงานเสร็จสามารถส่งไฟล์ทั้งหมดเช่น sql api apk อื่นๆ เพื่อการพัฒนาต่อไป -เพิ่มร้านค้าและเมนูเองได้ทีหลัง

...เดิน , วิ่ง ,เอฟเฟ็คตอนใช้สกิล , ฟันมอนสเตอร์ , เปลี่ยนแปลงอาวุธของตัวละคร 2. ใช้ Unity Network 5 , Javascript , C# ในการเขียน (หากใช้ Tools อื่นก็ลองเสนอมาได้ครับ) 3. สามารถกำหนดจุดเกิดมอนสเตอร์ได้ และผู้เล่นคนอื่นเห็นมอนสเตอร์เหมือนๆกัน 4. กำหนดการดรอปของไอเทมเวลาฆ่ามอนสเตอร์ได้ และผู้เล่นคนอื่นเห็นไอเทมเหมือนๆกัน 5. ระบบ Inventory สามารถดึงข้อมูลไอเท็มของตัวละครแต่ละคนได้ ใช้ database mysql หรือ ms sql ครับ 6. ระบบแชททั่วไป และแชทส่วนตัว 7. ระบบปาร์ตี้ ให้สามารถมองเห็นหลอดเลือดของคนในปาร์ตี้ และตำแหน่งปาร์ตี้ในแผนที่ 8. ทำคู่มืออธิบายวิธีการใช้งานสิ่งที่ทำมาคร่าวๆครับ ใครสนใจเสนอราคาค่าจ้าง และประวัติผลงาน มาด้วยนะครับ

ค่าจ้างตามตกลง Programmer C#.Net MS SQL HTML etc.

ต้องการ Implement ระบบ OPENERP ODOO ตอนนี้องค์กรณ์ต้องกรใช้ระบบดังนี้ Warehouse สามารถเชื่อมต่อระบบคลังสินค้ากับ Prestashop ได้ และ สามารถสร้าง SO มายังระบบ Odoo ได้ ปัจจุบันใช้ระบบดังนี้ 1.โปรแกรมบัญชี Express CRM Prestashop สิ่งที่ต้องการ 1.ทำ Work flow หรือ Standard Work สำหรับงานแต่ละแผนก 2.ย้ายข้อมูลจากระบบ Express แลพ CRM มายัง Odoo 3.เชื่อมต่อข้อมูลกับระบบ Prestashop และ สอยวิธีการเชื่อมต่อข้อมูลเนื่องจากมีหลายเว็บไซต์

Build a Easy website with codeigniter+sql. Built it as easy as you can. สร้างเว็บไซต์ด้วย codeigniter+sql.

Software and Application OCR Scan or Take Photo of Document OCR TO SQL

ต้องการซื้อ database ท่องเที่ยวในประเทศไทย

รับเขียน ออกแบบ แก้ไข software ทุกประเภท ทั้งงานทั่วไป และ ในโรงงานอุตสาหกรรม ประสบการณ์ใน บริษัท และ โรงงานอุตสาหกรรม มากกว่า 10 ปี -VB -Delphi -MS SQL -Oracle -MS Access -Barcode reader, RFID - อุปกรณ์เชื่อมต่อกับระบบคอมพิวเตอร์ I/O Card, Machine controller และ อื่นๆ เรามีความเป็นมืออาชีพ ทำงานเร็ว คุณภาพเยี่ยม คุ้มค่า คุ้มราคาแน่นอน ติดต่อเรา

ต้องการข้อมูลที่ติดต่อได้จริง ของร้านสปา และร้านขายส่งผลิตภัณฑ์เกี่ยวกับสปา ทั่วประเทศไทย (มากที่สุด) ข้อมูลที่ต้องการ -ชื่อร้าน -เจ้าของ/ผู้ดำเนินการ -หมายเลขโทรศัพท์ -หมายเลขแฟกซ์ -หมายเลขโทรศัพท์มือถือ (ถ้ามี) -อีเมล์ -ที่อยู่จัดส่งเอกสาร ***เป็นข้อมูลที่ update ใช้ได้จริงเท่านั้น

Application code to implement Roomio as a web application in python. You will use the table definition posted at the end of this document.

... All the tables are fed from the main large table (secondly rate table - real time table). Details about the models: ML Model Development: Anomaly Detection Model: Develop a model using Random Forest algorithms to detect unusual patterns in energy usage. SARIMA Forecasting Model: Implement SARIMA models to forecast daily energy requirements, considering seasonal variations. Database: A cloud SQL real time database is preferred. Front end: After analyzing the data, I want to display the results to the user in Flutter with a very simple UI. I want to display: - Total energy consumption. - A graph for the total energy consumption by hour. - Energy consumed for each device. - Energy consumption compared to yesterday's. - Estimated energy consumption by end of t...

MUST USE ANGULAR, CSS, and any other framework. Must develop using git (I have git account and digital ocean account) and deploy using continuous development to web server. and use mysql for the db backend Once the project is awarded we can work these out before starting development The project should be a simple tasks application. Users should be able to create a task, modify task, delete task, mark task as complete. The user can create as many task as needed. Tasks should have the following: Task Name, Task Detail, Priority (High, Low) , StartDate, EndDate

I need a talented VB.net developer with a strong background in SQL Server. Key Responsibilities: - Develop software applications using VB.net - Efficiently manage databases - Designing, coding, testing, and debugging software applications using VB.NET. - Calling third-party API - Payment gateway integration - Stored Procedure Ideal Candidate: - Proven experience in VB.net development - Strong familiarity with SQL Server - Good problem-solving skills - Ability to work independently and meet deadlines. Please provide relevant work samples in VB.net development and describe your experience with SQL Server.

I need an expert in SQL Server Report Builder 3.0 to help rejuvenate some lab reports. I require some amendments to be made to the current reports I have. Key Tasks: - Altering the way data is presented within the reports - Incorporating new fields to the current reports In the end, I need the same data results but with improved visibility and understanding. Ideal Skills: - Appropriate familiarity with SQL Server Report Builder 3.0 - Strong grasp of data visualization principles - Detail-oriented and precise to ensure report data remains accurate. Individuals that can deliver these changes precisely and quickly are highly preferred.

...create an Android Internet Radio app that features a mix of content, including talk shows, music, and news and sports. This is what I require: - Development of the app solely for the Android platform - It would be a bonus if the app can support offline listening, but this is not a definitive requirement – I am open to discussion on this point. I provide access to my play store for the person to deploy the app. I will also submit the online radio link Ideal skills and experience: - Proven experience in mobile app development, especially in creating high-quality Android applications - Strong knowledge and experience with internet radio app creation would be highly advantageous - Exceptional understanding of the Android development environment and tools Freelancers who ...

I am seeking a skilled Network Administrator to convert my computer into a gaming server. My interest lies in hosting multiplayer strategy games, therefore, the professional should have a strong understanding of server setup specific to these game types. Important considerations for this project are: - Support for multiple game sessions running conc...understanding of server setup specific to these game types. Important considerations for this project are: - Support for multiple game sessions running concurrently. - Capable of handling a maximum of 50 concurrent players. The ideal candidate will demonstrate proven experience in similar projects and possess detailed knowledge in network administration, particularly in gaming server setups. Please express your expertise in your bid...

I'm looking for a skilled software developer to create a Windows application that focuses on generating data reports from a SQL database. Key Requirements: - The application must be compatible with the Windows platform - The main functionality of the application should be the generation of data reports. - The reports should be sourced from SQL database. Ideal Skills and Experience: - Proficiency in Windows application development - Strong knowledge and experience with SQL database and report generation - Previous experience with data reporting software would be a plus.

I'm in need of a Junior Full Stack Engineer who is proficient with Java, with beginner level experience. The primary task will be to work on implementing Go Live for an assigned project. Ideal skills for the job: - Understanding of Java programming language - Ability to work collaboratively on a team - JSON - XML - SQL - Data Mapping Some experience with project implementation is a plus. Dedicated beginners are also welcome to take their first steps in a real project.

I'm looking for a proficient developer who can add a page to my website that interfaces smoothly with my MySQL database. The website already has formatting etc, so I'm not looking for that. The database stores a variety of exercise data, and the webpage needs to display this data in an intuitive and user-friendly manner. Key webpage features include: - Display of exercise data: Each exercise's description and its difficulty level should be displayed. There's also a column in the database containing YouTube URL links, so another important feature the webpage needs is the ability to watch these exercise videos directly from the webpage. It is a simple database with only one table. - Users should be able to select the exercise they want from ...

I need an expert in Ionos Cloud platform to help me deploy a project which mainly requires web server setup. For the deployment, the project would require specific server configurations or software installations on Ionos, including React, FastAPI: - Expertise in Ionos cloud platform - Setup of web server - Software installations for FastAPI and React Ideal freelancers should have extensive experience in cloud deployments, specifically with Ionos, and should be well-versed with web server setup and software installations for FastAPI and React.

...calls, manage image and data storage, and ensure efficient data flow throughout the application. Frontend Development: Design and develop a user-friendly e-commerce website where customers can browse and purchase generated images. Database Management: Set up a database to manage user data, transaction details, and maintain associations between prompts and generated images. Quality Assurance and Testing: Ensure the application is reliable, performs well, and provides a seamless user experience across different devices and browsers. Deployment and Maintenance: Deploy the application to a cloud environment and ensure its ongoing operation, including updates and troubleshooting. Required Skills: Proficiency in web development technologies (e.g., HTML, CSS, JavaScript, ...

We are seeking female bikini models aged between 18-60, for a casual yet enticing yachting photo shoot from different yachts and various sizes to take place ...female bikini models aged between 18-60, for a casual yet enticing yachting photo shoot from different yachts and various sizes to take place in the stunning Mediterranean area. The theme of the shoot is predominantly casual holiday. You'll be embodying the spirit of sea life in a laid-back, casual manner. Ideal Skills and Experience: - Experience in modeling, preferably swimwear - Ability to express 'nautical' theme convincingly - Must be comfortable with outside shooting in a yacht environment - Age 18-60 - Comfort and confidence in front of the camera. I look forward to working with you and creating...

Looking for a Google Cloud Platform (GCP) expert who can assist with Cloud Functions and Vision API integration and deploy function on google cloud - Your main focus will be integrating Vision API for images batch processing and setting up Cloud Functions. The urls of images will be in excel file in google cloud. The parse result to be placed in columns next to url column. - The data primarily processed with text detection. Ideal Candidate: - Proficient in GCP services, specifically Cloud Functions and Vision API. - Experienced in setting up GCP services for one function. - Skilled in implementing Vision API for image processing. - Strong understanding of data processing in GCP.

I am looking for a skilled and experienced Full stack developer with Hands-on experience in Java Hands-on experience in Angular/ REACT Hands on experience on AWS RDS/AWS S3/Oracle/AWS Athena/ SQL In-depth knowledge in Core Java, Spring framework and RESTful API Services, Apache Camel, CI/CD Jenkins, Containerization Experience with AWS Cloud and its services like EC2, Athena, Lambda, S3, SQS and Cloud Formation Experience in writing JUnit test cases Problem-solving abilities

...handle data export processes, model and create tables and entity relationships, and develop an efficient and scalable database within a tight one-month deadline. ### Responsibilities: - Data Integration: connect and streamline data from multiple sources including ad platforms (like Google Ads, Facebook), website analytics tools (e.g., Google Analytics), CRM systems (e.g., Salesforce), and MAPs (e.g., HubSpot). - **Accelerated Database Design:** Design and implement a robust and scalable database that supports efficient data aggregation and analysis, within a short timeframe. - Entity-Relationship Modeling: Develop and finalize a comprehensive ER diagram that illustrates the database structure and supports urgent marketing analytics requirements. - Efficient ...

I'm seeking a highly skilled flutter developer possessing in-depth experience with Laravel to contribute their expertise to my social media ap...highly skilled flutter developer possessing in-depth experience with Laravel to contribute their expertise to my social media application. Here are the key features expected: - Main UI is completed with flutter. - Laravel backend is almost 70%. - to be implemented: integrate the API into the current UI. social login(FB, twitter, tiktok, apple) inapp and banner ad audio combine with BGM. support the deploy on google play and app store HOW to apply. - please send me the FLUTTER APP URL on google play and app store and code screenshot of that App. (the proposal without the screenshot will be declined) - send me the laravel system URL ...

I'm in need of an experienced backend developer to create a mail parser with the following specifications: - **Email Protocol:** The mail parser should support SMTP, so proficiency in this area is a must. - **Primary Goal:** The primary function of this mail parser should be storing emails in a MySQL database. If you have experience with database integration, this would be a big plus. This project requires expertise in backend development, specifically with an understanding of how SMTP works. You should also be familiar with MySQL and have experience in integrating databases into applications. Please provide examples of similar projects you've worked on in your proposal. Thank you.

From Germany or Netherlands ...professionally with leaded solder. - Experience: The ideal candidate should have experience in PCB assembly and soldering. - Quality: It's crucial that the resistors are soldered correctly and with high quality, as the functionality of the prototype depends on this. - Quantity: I require 10 PCBs to be assembled in this manner. Shipping: Once the PCBs are soldered, they will need to be shipped via Express courier service. This means that the professional must also be able to handle the shipping requirement. If you have experience with prototype PCB assembly and are confident in your soldering abilities, I'd love to hear from you. Please provide details of your experience, and also let me know your expected timeline for completing the sol...

I'm looking for a talented Node.js/Express developer to help me with the backend of my website. The frontend is already set up, and now I need a skilled individual to take care of the backend, particularly for the contact page API. This is an exciting opportunity to showcase your skills and work on a project that's primed for success. Key Requirements: - Develop a secure and efficient contact form submission system. - Implement an intuitive email notification system for incoming messages. - Ensure the backend integrates seamlessly with the already established frontend. Ideal Candidate: - Proficient in Node.js and Express with a solid portfolio of past work to support your skills. - Experienced in developing contact forms and email notification systems. - Strong un...

I need a VA with Wix store experience, a keen eye for detail, and proficiency in spreadsheet management. You'll be tasked with: - Keyword Optimization: Adjust the product titles on my Wix store to ensure they are optimized for search engines. Experience with SEO would be beneficial for this. - Database Creation: Develop a comprehensive database for all my products. This will include attributes like Product names, Product prices, and Product URLs. - Formatting: The database should contain separate columns for each product attribute. Strong organizational skills and experience with data entry would be ideal. Ultimately, the goal is to streamline the management of my product listings for a smoother business operation. Prior experience with Wix and creating pro...

I'm seeking an experienced .NET developer with over 4 years of expertise in C# programming and SQL databases. Key Responsibilities: - Enhancing existing software application - Adding new functionalities The ideal candidate should possess: - Strong experience in C# programming - Solid knowledge and practical experience with SQL databases Be ready to dive into the project and help us bring significant functionality enhancements to our existing software. Your experience and skills in C# and SQL will be invaluable in this task.

I'm looking for a skilled individual who has a good understanding of Mechanical Engineering and Data Science to help me set up a database that records the live feed of on-board sensors in a car. Key Responsibilities: - Utilizing an On-Board Diagnostic Tool and an app to record the data - Implementing a database to store the collected sensor data - Analyzing the data primarily for predictive maintenance using statistical analysis Ideal Skills: - Mechanical Engineering background - Proficiency in working with On-Board Diagnostic Tools - Strong experience in statistical analysis - Knowledge of database management systems and data analysis tools - Experience in predictive maintenance is a plus This project requires attention to detail, analytical thinking, and the...

As a client, I'm in need of an experienced mobile app developer who can help me deploy a cross-platform app. The primary goal of the app is to facilitate online food delivery, catering to users across different platforms. Key Features: - User Registration and Login: The app should allow users to create accounts and log in securely, with options to save their preferences and order histories. - Restaurant Selection and Menu Browsing: Users should be able to browse through a list of restaurants, view their menus, and select items for their orders. - Order Tracking and Delivery Status Updates: The app must provide real-time order tracking and push notifications for delivery status updates, ensuring transparency and convenience for the users. Ideal Skills and Experience: - Profici...

I am searching for a Product Analyst who can apply their knowledge towards data analysis, market research, and performance monitoring. Its a small assignment This assignment involves diving into a snowflake database to explore how customers behave. The goal is to find useful information that can help the Product team make decisions to make the business grow. After you uncover insights, you'll suggest changes to the product, like adding new features, making current features better, or even getting rid of features that aren't working well. You need to do the analysis, create graphs to show your findings, share all the code you used, and also come up with a plan for an A/B test to try out one of your suggested changes. Note: Its a short assignment, not spend more than tw...

...approach ● Provide technical guidance and mentorship to less experienced team members ● Partner with Architecture and Engineering Director to design and implement solutions that align with the technology organization’s Technology Vision, Strategy, Standards, and Best Practices. Represent architecture on the delivery team. ● Work closely with the SRE Team to provision, deploy and maintain the underlying infrastructure through the use of IaaC managed by Terraform using GitLab pipelines ● Partner with the Delivery Manager to lead data-driven process improvements related to the DORA metrics, overall efficiency, and health of the system(s) that the team supports ● Identify, prioritize and breakdown work in the software deve...

...performing poorly with slow website loading times and database slowdowns, which is unacceptable as I regularly have more than 500 concurrent visitors. The primary focus of this project will be optimizing the server's Plesk settings, Postgres and MariaDB databases, and PHP 8.2 configuration. Key tasks will include, but are not limited to: - Configuring Plesk for optimal performance, including adjusting server pool size - Identifying and implementing improvements to Postgres and MariaDB settings to reduce slowdowns - Tuning PHP 8.2 to enhance website speed and performance Ideal candidates for this project will have: - Proven experience in optimizing dedicated servers, particularly with Plesk and Almalinux - A solid understanding of database optimization, including ...

I'm in search of a qualified developer to create a sniper bot. This complex trading bot should ideally have the following features: -most important function is a sniper bot function with the ability to snipe the contract based on the wallet of the creator or a name used to deploy it. Example all the contracts that use the name PEPE will be bought instantly on presets values. and if i select the option to follow certain wallet will buy everything this wallet launches on - Automatic buy and sell orders: This bot should be able to place trades on my behalf, minimizing manual intervention. - Real-time blockchain analysis on the Solana network - Customizable alert system: I want to be alerted with all PNL data for every trade executed in real time after trade has completed.

I am seeking a detail-oriented freelancer who can expertly transfer text data from PDF files into a database. The ideal candidate should possess the following skills and experience: - Proficiency in working with PDF files - Expertise in data entry tasks - Experience in formatting and structuring databases - Excellent attention to detail Suitable candidates need to handle copious amounts of text data, accurately convert the text-containing PDF files into a structured and organized database. This includes careful validation to ensure no data is lost or misrepresented during the data entry process.

Hi Ashish, this is for the tasks I emailed about.

I'm in search of a qualified developer to create a sniper bot. This complex trading bot should ideally have the following features: -most important function is a sniper bot function with the ability to snipe the contract based on the wallet of the creator or a name used to deploy it. Example all the contracts that use the name PEPE will be bought instantly on presets values. and if i select the option to follow certain wallet will buy everything this wallet launches on - Automatic buy and sell orders: This bot should be able to place trades on my behalf, minimizing manual intervention. - Real-time blockchain analysis on the Solana network - Customizable alert system: I want to be alerted with all PNL data for every trade executed in real time after trade has completed.

I'm searching urgently for an experienced PHP architect who can const...items. - Integrating an 'Add to cart and checkout' feature ensuring a simple and smooth transaction process. - Developing order management and inventory tracking system within the admin panel to help me keep track of orders and product stocks. Skills and Experience Required: - Proficient in PHP programming - Experience in developing e-commerce websites - Solid understanding of databases and SQL - Familiarity with different payment solutions Although there is no specific requirement for payment method integration at the moment, the ability to seamlessly add these in the future is essential. My project requires immediate attention and the chosen freelancer needs to be able to commit and delive...

We have a website where the homepage currently loads slowly due to multiple API calls. Despite implementing asynchronous API calls, the page load time is still not meeting our target. We are looking for a skilled developer to optimize the homepage to load within 1 second. we need some one who can : Optimized homepage that loads within 1 second. Cron job implementation for fetching and updating api data of tokens price/5%/24%//etc basically - i want to load data everything from DB only , rather than multiple api calls. thakns