3. Tables that translate as Pandas dataframes. We support at most one table per sheet, at the tables must be contigious. If the formulas in a column are consistent, then we will try and translate this as a single pandas statement. We do not support: pivot tables or complex formulas. When we fail to translate these, we generate TODO statements. We also don’t support graphs or macros - and you won’t see these... - Source: Hacker News / 19 days ago

2. The report you're sending out for display is _expected_ in an Excel format. The two main reasons for this are just organizational momentum, or that you want to let the receiver conduct additional ad-hoc analysis (Excel is best for this in almost every org). The way we've sliced this problem space is by improving the interfaces that users can use to export formatting to Excel. You can see some of our (open-core)... - Source: Hacker News / 2 months ago

I'm building an open-core spreadsheet currently, and pivot tables are by far our number-one data transformation feature. By like 3x-1x. This is compared to even formulas (shockingly! But this is also a function of our audience). In the hundreds of data-science-in-Excel files I've seen, I can't think of a single one that doesn't make use of a pivot table in some way. ( - Source: Hacker News / 8 months ago

Swagger descriptor for REST API with nice Swagger UI console. Nowadays, it is a standard de facto. Microservices should be accessible via HTTP and operate with data in a human-readable JSON format. As a bonus, it is super easy to generate data types and API client code for the client side (it works well for a TypeScript-based front-end, for example). - Source: dev.to / about 2 months ago

Often used for cases where a project exposes a REST or other type of API service. Open API is a popular method of documenting such API services. It can also be used along side tools such as Swagger Codegen to produce boilerplate code for API interaction / testing purposes. There may also be support files for popular API testing tools such as Postman or Insomnia. This makes it easier at a glance to see what data is... - Source: dev.to / 5 months ago

Regarding the IO, there could also be low-code tools. Swagger could be taken as inspiration. Swagger codegen is a great tool that allows you to declaratively produce code to interact with APIs. - Source: dev.to / 11 months ago

Personally I would try to put as much business logic as possible into your API that runs on server. Use a format like swaggger (https://swagger.io/tools/swagger-codegen/) to auto generate the client SDKs for every platform you support. Source: 12 months ago

It sounds like you want an OpenAPI spec. This can be written by hand or partially generated using a crate like utoipia. Once you have an OpenAPI spec you can generate clients in a myriad of languages using the (swagger codgen)[https://swagger.io/tools/swagger-codegen/] tools. Source: about 1 year ago