Find Jobs
Hire Freelancers

Build Smartsheet PHP API interface

£10-20 GBP

Completed
Posted over 3 years ago

£10-20 GBP

Paid on delivery
Construct a PHP function to call the [login to view URL] and retrieve the contents of a smartsheet The login credentials to a live Smartsheet account will be provided to the successful bidder. The requirement is for a PHP function to be written that will retrieve the entire contents of a single smartsheet held on smartsheet.com. [login to view URL] have an API that allows this. The function should return an array or objects. Each object in the array will be one line of the smartsheet organised as ‘name/value’ pairs – the name being the header of each column and the value being the value in that column for that row. Columns on the smartsheet that are checkboxes are to be returned as ‘true/false’ values. Cell colours also the be returned as name value pairs – using the column name with a suffix of ‘-color’ – e.g. “name-color/colorvalue” Column names to be retrieve dynamically through the smartsheet API and used to create the array. If any PHP libraries are used these are also to be supplied. The API login credentials can be hard coded into the function for now. If subfunctions are needed this is fine but the one overall usage must be a single call to the main function and the fully populated array returned. A typical returned array would be: - [{“ColumnA”:”123”, “ColumnA-color”:” #123456”, “ColumnB”:”456”, “ColumnB-color”:” #234567”, “ColumnC”:”789”, “ColumnC-color”:” #345678”}, {“ColumnA”:”123”, “ColumnA-color”:” #123456”, “ColumnB”:”456”, “ColumnB-color”:” #234567”, “ColumnC”:”789”, “ColumnC-color”:” #345678”}, {“ColumnA”:”123”, “ColumnA-color”:” #123456”, “ColumnB”:”456”, “ColumnB-color”:” #234567”, “ColumnC”:”789”, “ColumnC-color”:” #345678”}] [ 1. { o “ColumnA”:”123”, o “ColumnA-color”:” #123456”, o “ColumnB”:”456”, o “ColumnB-color”:” #234567”, o “ColumnC”:”789”, o “ColumnC-color”:” #345678” }, 2. { o “ColumnA”:”123”, o “ColumnA-color”:” #123456”, o “ColumnB”:”456”, o “ColumnB-color”:” #234567”, o “ColumnC”:”789”, o “ColumnC-color”:” #345678” }, 3. { o “ColumnA”:”123”, o “ColumnA-color”:” #123456”, o “ColumnB”:”456”, o “ColumnB-color”:” #234567”, o “ColumnC”:”789”, o “ColumnC-color”:” #345678” } ]
Project ID: 27948304

About the project

6 proposals
Remote project
Active 4 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
Thank you for your posted project and hope you are doing great. I've read your project description carefully and would love to work on this project with my experience in the development activities. ******Please send me a message so that we can discuss more.****** Gladly waiting to serve you with my extensive skills. Thank you for reading my proposal.
£20 GBP in 1 day
4.8 (335 reviews)
7.2
7.2
6 freelancers are bidding on average £56 GBP for this job
User Avatar
Boa tarde Sou um programador PHP e Javascript especializado em uso de API e criaçao de bots e scripts automatizadores. Li a descrição do seu projecto e estou interessado em trabalhar nele. já trabalhei com a API da smartsheet e tenho dominio desta. Assim posso realizar o trabalho o mais rapido e com a maior qualidade possivel. I would love to work on this project with you greetings
£40 GBP in 3 days
5.0 (6 reviews)
3.7
3.7

About the client

Flag of UNITED KINGDOM
Bristol, United Kingdom
5.0
21
Payment method verified
Member since Dec 24, 2014

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.