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”
}
]
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
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