Færdiggjort

Build Smartsheet PHP API interface

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”

}

]

Evner: PHP, API

Se mere: api interface ebay, build calculator php, php api meassaging, smartsheet api python examples, smartsheet api excel, smartsheet python, smartsheet api postman, smartsheet api token, smartsheet api github, smartsheet postman, smartsheet api php, build cms php mysql, ringtone website php api, php api google custom search engine, php api google authentication demo, shoppingcom php api sample code, freightquotecom php api, shopping website php api, php web interface edit xml file, build dynamic php website

Om arbejdsgiveren:
( 18 bedømmelser ) Bristol, United Kingdom

Projekt ID: #27948304

Tildelt til:

Max01

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 Flere

£20 GBP på 1 dag
(315 bedømmelser)
7.0

7 freelancere byder i gennemsnit £51 timen for dette job

maxpl

Hi, Hope you are fine. I am a full stack developer. I have 8+ years of experience in webdesign/development. I have seen the proj Flere

£80 GBP in 2 dage
(30 bedømmelser)
6.6
vipinjain1213

Hello, I have 10+ years of experience as Website Designer/Developer. I believe I will be suitable for this job and serving you with all my hard work, creativity and skills. I am well versed in Html, CSS, Bootstrap, Co Flere

£100 GBP in 5 dage
(20 bedømmelser)
5.1
arnoldb

Hi, Hope you are fine. I am an experienced web developer from Poland with over 8 years of experience. I have seen the project description and I Flere

£80 GBP in 2 dage
(11 bedømmelser)
5.4
sergeykhomyakf

Hello. How are you? I am very interested in working with you. I am a website developer from Ukrine who is talented. I have been developing websites and web applications for over last 5 years. In the past, I have deve Flere

£20 GBP in 7 dage
(5 bedømmelser)
4.0
Comentador

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 s Flere

£40 GBP in 3 dage
(6 bedømmelser)
3.7
vrushali9824

Hello sir/ Ma'am, I am a Software developer at Technoweb4U, Vadodara, Gujarat. I have more than 3 years in my personal experience in this field. I can help you to develop this type of project, in the below profession Flere

£15 GBP in 7 dage
(1 bedømmelse)
0.6