Google BigQuery to work with Xero OAuth API
Budget: £750 – £1,500 GBP
We're currently setting up Google BigQuery to sync data from Xero for 1 of our clients. The data in BigQuery will then be used to create financial dashboards for this client in Google Data Studio.
We now want to expand this to all of our clients. Big Query will need to be store Xero data for each client in such a way that allows us to create a dashboard for each client in Data Studio.
Something like this -
that includes
- setup client by logging in using xero oauth
- a frontend & a hosted webapp to manage users/tenants
- database config’d for the client/users
- scheduler for picking up clients from the database and enqueing tasks
See - https://developer.xero.com/documentation/guides/oauth2/overview/
We now want to expand this to all of our clients. Big Query will need to be store Xero data for each client in such a way that allows us to create a dashboard for each client in Data Studio.
Something like this -
that includes
- setup client by logging in using xero oauth
- a frontend & a hosted webapp to manage users/tenants
- database config’d for the client/users
- scheduler for picking up clients from the database and enqueing tasks
See - https://developer.xero.com/documentation/guides/oauth2/overview/