Find Jobs
Hire Freelancers

PHP script to call API, Sum/Count items, then send email

$10-30 USD

Completed
Posted over 6 years ago

$10-30 USD

Paid on delivery
I need a PHP script that will: #1. Issue an API call and capture the return JSON response. #2. Sum ONE of the fields in each JSON “record”. #3. Count how many JSON “records” there are. #4. Send an email that says “This is the count” and then include the Sum from #2 above, and “This is how many records there are” then include the Count from #3 above. I will end up setting up this script as a CRON job that runs every day. DETAILS: For #1: I have tested and I am able to issue the API call via [login to view URL] and capture the returning JSON response. So I know the call works, and I can see the JSON response. When you build the script, you will have to change two variables (that control the date range of the request) in the API request every time the script runs. The starting date will be the CURRENT SYSTEM date and the ending date will be the CURRENT SYSTEM DATE plus 30 days. For #2. I have included a sample of the JSON response as an attachment (a 3 day range). The “field” that I am interested in summing for each record is the “number” field. IMPORTANT: The API will only let you retrieve 31 days of data, but I want 90, so you must issue the API call 3 times to get 90 days of data, and them sum across the 3 requests. For #3. Count the records. You can do this yourself, OR it is in the bottom of the API JSON response as “totalItems”. #4. Send an email via PHP to an email address. In the formatted email, “reservations” is the “number” (that you are summing) and “bookings” is the count of the records. See a sample of the email as an attachment. Finally, you will need to comment your code, so that if I need to make small changes in the future, I can understand what you are doing.
Project ID: 14965911

About the project

28 proposals
Remote project
Active 7 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
$20 USD in 0 day
5.0 (90 reviews)
5.6
5.6
28 freelancers are bidding on average $35 USD for this job
User Avatar
Hi! I'm interesting your project very well. i mastering PHP and HTML. And also I have many experience and good skill about web and android development. Let's go ahead with me Stay tuned, I'm still working on this proposal.
$25 USD in 1 day
4.9 (262 reviews)
7.9
7.9
User Avatar
Hello sir, I have gone through your project "PHP script to call API, Sum/Count items, then send email", I will complete your project today, LIFETIME error free guarantee and provide 365 days (ONE YEAR) support... I have right skills (PHP) to execute your esteemed project. Relevant Skills and Experience PHP
$37 USD in 1 day
5.0 (113 reviews)
6.7
6.7
User Avatar
I did read your requirement and willing to do this task. Relevant Skills and Experience I have extensive experience in Web Development. Joomla, Magento, PHP Framework(Yii2) etc. Proposed Milestones $111 USD - all
$111 USD in 2 days
5.0 (34 reviews)
5.6
5.6
User Avatar
I have 5 years experience about CMS ( WordPress, Joomla), PHP, HTML, CSS, Javascript, PSD to CMS, PSD to HTML. Stay tuned, I'm still working on this proposal.
$21 USD in 1 day
4.9 (55 reviews)
5.8
5.8
User Avatar
Hi there! I am experienced with building custom scripts with php and will be happy to solve your problem. Hope for hearing from you. Regards. Relevant Skills and Experience php Stay tuned, I'm still working on this proposal.
$25 USD in 1 day
5.0 (32 reviews)
5.6
5.6
User Avatar
A proposal has not yet been provided
$166 USD in 3 days
3.9 (28 reviews)
4.8
4.8
User Avatar
Dear sir, im interesting with your project. it will php script with php curl request 3 times to get data for next three month then send to email ( will using sendmail or phpmailer(smtp)). thank you Relevant Skills and Experience php cli, json parser, curl, Proposed Milestones $30 USD - delivery script with comment 1. how email will deliver using stmp, or sendmail( some hosting disable this features)?
$30 USD in 2 days
5.0 (6 reviews)
3.2
3.2
User Avatar
Hello, I can help you to process the Json File retrieved from the API call and create and send the email with your format. Relevant Skills and Experience PHP Wordpress JavaScript Jquery Html5 Proposed Milestones $30 USD - Process JSon Data and send information by email
$30 USD in 1 day
4.9 (12 reviews)
3.4
3.4
User Avatar
Hi, I am web developer experienced in designing and developing websites for my own projects as well as for clients. I have just graduated from Newcastle University studying Bsc Computer Science. I have seen your post on freelancer and I believe I have the knowledge and the experience to finish this project without any problems. These are the technological skills I have within the web development area: - HTML (covering all doctypes including HTML5) - CSS - JavaScript - JQuery - BootStrap (as well as some other frameworks such as YUI) - PHP (also ASP.Net) Drop me a message and we can talk about the project as well as the price since I am on this site to gain more experience as well as to share know knowledge within the area i am really passionate about. Kind Regards Jomin
$30 USD in 1 day
5.0 (6 reviews)
3.1
3.1
User Avatar
Hello sir, I have well experience in P.H.P, S.Q.L, J-Query, Ajax and J.S.O.N response handling and API. I m showing interest to work on this project. Interesting requirements and seem feasible for me. I can finish with in 4 days. You can leave message over chat-box to discuss further. Awaiting reply, Thank you.
$15 USD in 3 days
5.0 (3 reviews)
2.1
2.1
User Avatar
I have checked both the attached files and will do those as we are experts. Contact us for further details, our skyp is zeninfosolution Thanks Relevant Skills and Experience PHP, JSON Proposed Milestones $25 USD - Final Delivery
$25 USD in 1 day
4.9 (6 reviews)
1.7
1.7
User Avatar
I am professional web developer. I can perform this task to your satisfaction. As I progress through the assignment, I will keep you posted with regular updates. I hope to hear from you soon. Relevant Skills and Experience I am working on PHP since 2014. I have done this type of data fetching work before. So I can easily do it for you. Proposed Milestones $15 USD - Complete
$15 USD in 2 days
5.0 (1 review)
1.1
1.1
User Avatar
Hi, Thanks for open me. I've already make sense your project. I can give you Perfect result in a short period with my response ability and skills. I am ready for you. Hope you doing well. Regards. Relevant Skills and Experience Expert PHP Developer Proposed Milestones $25 USD - payment
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear Hiring Manager, My name is Alexander. I have been working as a software engineer/programmer for last 5+ years. I like this kind of programming tasks, and can finish it in 1 day or less. Relevant Skills and Experience PHP, Javascript, JSON, REST Proposed Milestones $2 USD - 1. Issue an API call, and output the results in console - to see that call actually works. $3 USD - 2. Add method, that extracts required fields from JSON repsonse and counts the amount. $6 USD - 3. Add method for composing, and sending an email. $2 USD - 4. Refactor code written, to make it clearly readable, and make it easy to maintain. Add comments. How many JSON “records” - Does that mean - how many 'bookingNumber'? What is the URL for API call?
$13 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I have worked on similar projects before.i can complete this as early as possible. Relevant Skills and Experience Php,html
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Southeast, United States
5.0
36
Payment method verified
Member since Jun 21, 2005

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.