Is there an API for spreadsheet.com spreadsheets?

Santosh · June 9, 2021, 5:01am

I’m sure your use case can be handled, from what I understand. But I’ll let @matt confirm too.

Martin_Radley · June 9, 2021, 1:54pm

Thanks Santosh. Also, why must a post have at least 20 characters? (I just added this last part to get to 20 characters)

Santosh · June 9, 2021, 4:00pm

We are still tinkering with discourse settings (it has a ton of them). We will reconsider a post’s character limit.

hendrik · June 10, 2021, 1:54am

Dear @Santosh , with the increasing connected spreadsheets (like rows.com / actiondesk.io / airtable with datafetcher.io), I believe spreadsheet.com can conquer them all with easy to use API combined with recently released Automation.

Look forward to your API update!

matt · June 10, 2021, 3:48am

Welcome @Martin_Radley Based on your bulleted list I think we will be in good shape to handle your use case either in the initial beta release of the API or shortly after. If you are interested in being an early user of our API once its ready we’d love to have you as a beta user and would value your feedback.

matt · June 10, 2021, 3:50am

Thanks @hendrik, if you’d like to be a beta user of the API once it’s available we’ll make sure to connect with you then. Looking forward to your feedback

Martin_Radley · June 10, 2021, 5:16am

Thanks Matt. I’d love to be a beta tester. Please let me know next steps. Thanks

matt · June 10, 2021, 5:26am

Great! We’ll reach out to you about this as soon as we kick off beta access to the API

Martin_Radley · June 10, 2021, 2:27pm

Thanks Matt.xxxxxxxxx

Max_Ziebell · September 7, 2021, 6:48pm

Is there a way to load a spreadsheet as a JSON file yet?

matt · September 7, 2021, 7:56pm

Welcome @Max_Ziebell! We agree that this is a critical capability and it’s in high demand from early users. We’re currently working on v1 of our API now and will update this thread as we have a more definitive answer regarding when it will be available. Thanks for your interest.

hendrik · September 18, 2021, 11:40am

@matt , make sure to invite me as well. Cheers.

Have a nice weekend!

matt · September 18, 2021, 4:54pm

Will do @hendrik

Martin_Radley · November 2, 2021, 10:32pm

Hi Santosh,

Any update on when a REST API will be available?

Thanks

Martin

Murali_Mohan · November 3, 2021, 4:19pm

@Martin_Radley - REST API remains high priority in our short-medium term roadmap. I’m hopeful of a Q1-Q2 2022 rollout.

etienne_mermillod · November 16, 2021, 2:01am

Hi,

Speaking of API, are you planning on also enabeling custom UI/controls/workflows, more like a low coade platform ?

matt · November 16, 2021, 4:32am

Welcome @etienne_mermillod. Low-code capabilities are in our medium and long term plans, such as ability to write custom scripts that get invoked as automation actions. Allowing development of custom widgets is something we plan to consider, in addition to providing ways to build custom interfaces backed by Spreadsheet.com workbooks. No ETA to share yet on any of this.

etienne_mermillod · November 19, 2021, 2:39pm

Features like custom columns types, let’s say cutom custom country flags, or buttons would be a reason for me to switch to this platform compared to some other exsiting ones.
Cascading drop down is also mandatory.

matt · November 19, 2021, 3:31pm

The Button data type is currently on our roadmap.

A dropdown (Select or Multiselect) with Country flags can be created by using flag emojis icons today. We are also imminently releasing the ability to define Select and Multiselect options from a range or named range, allowing easy re-use of values in dropdowns from any range in any worksheet within a workbook (similar to how traditional spreadsheets allow data validation).

Regarding cascading drop-downs, do you have an example you can point us to? Curious to learn more about what you have in mind.

Murali_Mohan · November 2, 2022, 5:41am

@Martin_Radley - REST API → https://developer.spreadsheet.com/