Project list in Google Sheets

[ant...@rosewood.us.com]

I would like to pull all the open projects for a particular company into a list in Google Sheets along with the Budgeted hours and Planned Start and Planned Due dates of the project to create a Gantt chart style report to see what all projects we have going and when for a particular client. 

Would someone be kind enough to give me some direction on this? I am new to APIs and would like some direction if possible. 

I just need help getting the data from Accelo. I am good with Google Sheets and scripts. 

Thanks!

[Ella Hansen]

Hey Anthony!

Here's an example Google Script project I made that pulls data from the Accelo API. It's not the exact data you're looking for, but it might be helpful to get started with authentication and various functions.

https://github.com/Ignition-IT/Accelo-Metrics

Thanks,

Ella Hansen // they, them, theirs
IT Tech

P: 415-854-0881 x 303
E: el...@ignitionit.com

Tech support —> 415-854-0881 or sup...@ignitionit.com

Luvvv us? Yelp us!

--
You received this message because you are subscribed to the Google Groups "Accelo Developers" group.
To unsubscribe from this group and stop receiving emails from it, send an email to accelo-devs...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/accelo-devs/5bd79bf4-e9ff-48af-8175-ac22e3297793n%40googlegroups.com.

[Daniel Webb]

Hi Ella,

Nice one! Thanks for sharing, I'll be certain to take a look at this script to see if we can use it to automate some of the data downloads we currently do using report downloads.

One quick question, are the credentials 'Service' application type?

Best Regards
Daniel Webb / Managing Director

Cobwebb Communications Ltd

T +44 (0) 1732 447 900 / M +44 (0) 7738 280 593

dw...@cobwebb.com / cobwebb.com

134 High Street / Tonbridge / TN9 1BB / UK / Registered in England No. 02029183

We strive to be the most enjoyable software company in the world.

Click on a face below to let us know how we are doing...

To view this discussion on the web visit https://groups.google.com/d/msgid/accelo-devs/CAA8KUdDTJUiombR1jqPXv4eU8FZ8X5umYYYqOTNOD7D8eYkLxw%40mail.gmail.com.