We have a large amount of data currently stored in Excel sheets, we would like to reference this data in Creator and we're looking for the best service/method to do this.
Our stored data is fairly large (can be in excess of 100s columns and rows per sheet), split across multiple data-sets (sheets). We believe it is not suitable for storage within Creator because each data-set has a unique number of rows and columns that could not be easily laid out into a SubForm etc
So instead, we are thinking of using the Zoho API (or 3rd party integration) to fetch filtered data from an external source and use it within our Creator app.
Can anyone recommend an online storage service/method that our Zoho app could pull filtered data from? Could Zoho sheets work?
The data we need to reference is formatted in the following way
| Loc. A | |||||
| 2 | Loc. B | ||||
| 8 | 6 | Loc. C | |||
| 13 | 11 | 5 | Loc. D | ||
| 17 | 15 | 9 | 4 | Loc. E | |
| 24 | 17 | 16 | 6 | 7 | Loc. F |
For example, we would need to pull back the value of column 2, row 4.
Any suggestions would be greatly appreciated.