Comments (6)
You mean you'd like to be able to query a sheet and see what fields it has? Can you describe a scenario where you would need that? We've been assuming that for most uses the fields are fixed and you know what they are.
from api-docs.
Exactly that - would be useful for me to know some things about the columns (type, for example). Also, it would be great if they had an identifier independent from the column name.
Edit: same goes for the id column. We use "human readable" short ids in our sheets, so that when referencing a row from another sheet, we can identify the right row from its id (so the id is actually more like a short name or slug, in our case). This works nice when somebody edits a sheet. If I remember correctly, changing the id of a row also updates other rows referencing it. For an external service syncing sheets, though, it would be great to have stable ids for rows, so treating the id column in a sheet more like a unique, but mutable key.
from api-docs.
What's the scenario where the columns and types aren't fixed and known ahead of time? Can you describe the context around the use case?
Regarding stable ids for records: Each record should have an id
attribute which is a short integer ID. This is permanent. Note that if you have a column named "ID", that column will shadow the id
attribute. (We haven't solved the shadowing problem yet.)
from api-docs.
I can provide an example use case. We have a dialling system for our agents to call targets and engage with them / collect information, deliver sales pitches, etc. The system has a flexible metadata system for projects so that a project that, for example, targets the fleet sector can contain information about a company's fleet size and makeup but a project that targets prospects for loans would contain information about creditworthiness, turnover, employee counts, etc.
Our importer is able to deal with multiple data sources and does a good job of transforming information automatically - I'd love to be able to extend that to yank data in from FB in the same flexible way so an API endpoint to query column information would be a huge help there.
from api-docs.
This is done! Sheets and fields can now be retrieved using the Fieldbook metadata API: https://github.com/fieldbook/api-docs/blob/master/metadata.md
Thanks all for the feedback.
from api-docs.
@jasoncrawford This is great! 🎉
However, it doesn't look like linked columns specify which sheet they are linked to?
I would expect a field object to also contain a linkedSheet
property (or something similar) which is the id of sheet this field is linked to, if fieldType=link
EDIT: Opened a separate issue #24
from api-docs.
Related Issues (14)
- Deleting an item HOT 8
- Feature Request: Query by saved views HOT 4
- Access last or first item, Pagination or Sheet info HOT 2
- afterChange fired multiple times HOT 2
- Metadata API: Access the sheet to which a field/column is linked HOT 1
- Fetching image field and uploading to cloudinary fails HOT 1
- Return All Books HOT 3
- Formula data in responses HOT 1
- Add new fields to a sheet
- Feature Request: updated_at field HOT 3
- Feature Request: filter/query by list of items HOT 1
- Feature request: Eager loading related rows HOT 16
- Feature request: change notification via webhook HOT 2
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from api-docs.