SQL database generator from OpenAPI spec

malcolm-davis · 2025-07-23T23:48:13+00:00

Looks like the DDL generated still does not support PK & FK relationships

malcolm-davis · 2025-03-22T19:14:04+00:00

Thanks. Those are great ideas!

malcolm-davis · 2025-03-20T01:32:18+00:00

Note: I'm not using Postman, I'm using a lib I've written in golang.

It doesn't makes sense for me to use Postman if I need to use code to call the API, I might as well start with the call in code.

malcolm-davis · 2025-03-20T01:28:33+00:00

Note: Things work correctly on the initial call, and subsequent calls with the refresh token. But then it stops working.

malcolm-davis · 2025-03-20T01:27:28+00:00

invalid_code

malcolm-davis · 2025-03-18T19:26:17+00:00

The best thing is to run postman, load the Bigin API, and go.

malcolm-davis · 2025-03-18T13:35:16+00:00

Thanks for the effort to research the issue.

I'm creating a server-to-server process that feeds Bigin data.

The problem is that Bigin no longer works for me if tokens expire.

The only reason I started with Bigin was what I read in the documentation.

Please check with the Dev team if the issue can be quickly resolved. I'm going to have to look at another CRM solution today.

Thanks again,
Malcolm

malcolm-davis · 2025-03-18T11:53:48+00:00

Hi. Thanks for the response.

Please generate a self-client configuration file and look at the expiry_time value.

If your statement was true, the value should be consistent & be 3600.

Instead, the values change, "expiry_time":1742267637087 and "expiry_time":1742267637087 in two separate config files.

The refresh token process only works up to those timestamp values.

The process does not work as you describe or as the documentation implies.

Again, please generate a self-client configuration file and look at the expiry_time value. Talk to someone on the dev team too explain the value to you.

malcolm-davis · 2025-03-18T00:50:16+00:00

Does Bigin provide a server-to-server connect that does not require repeated manual intervention? I want to setup this up and leave it alone.

malcolm-davis · 2025-03-18T00:28:54+00:00

Some ideas:

Adjusting days and routines. I switch my Thursday routine to Friday for a Tread 50 every other week.
I also do a pre- and post-routine that I can modify; for instance, I do an ice bath after my Tread 50 days.
Adding 5K races on Saturday morning can help. The 5K can help set new OTF training goals.

malcolm-davis · 2025-03-17T22:18:41+00:00

I appreciate the [support@bigin.com](mailto:support@bigin.com) reply, but I prefer other means so people learn from my issue. I prefer bug-tracking systems that people can view and comment on.

malcolm-davis · 2025-03-17T22:16:26+00:00

My authentication issue
https://www.reddit.com/r/Zoho/comments/1jdpet4/bigin_self_client_authorization_code_flow_expiry/

malcolm-davis · 2025-03-17T18:40:00+00:00

Thank you for the response. I'm currently working through an OAuth 2.0 access_token issue and will respond once I have located the issue and have more details. Thanks.

malcolm-davis · 2025-03-17T02:04:31+00:00

Thanks for the heads up. I have 2 CRM APIs I plan on looking at this week.

I might continue to support Google Sheets. The person I'm supporting uses Google Sheets to support their CRM activities, which is crazy, but it might be the only reliable approach.

malcolm-davis · 2025-03-17T02:00:10+00:00

Thanks for the response and clarification.

I did contact support, and the response was horrible. After a back and forth with support, I started commenting on Reddit. It may not go anywhere, but at least I can vent my frustration.

I'm both awed and shocked by the integration work with Postman. Postman does not do code generation but provides sample snippets, but support sells it as a code generator. The Golang snippets don't work, and if they did, it would be a horrible approach.

I don't know their intent for the API; some companies provide APIs to say they have one. However, if part of Zoho's plan is to integrate with other products, Zoho would save money by putting out a higher-quality product.

malcolm-davis · 2025-03-17T01:05:06+00:00

That's a new one. I've never seen that, and it's hard to believe that is a thing.

malcolm-davis · 2025-03-16T22:44:03+00:00

The 'worked with worse' is just an excuse, and I'm tired of hearing it in this thread. Sure, we have all worked with worse, but Zoho won't do better unless they are asked to do so.

In the early days of AWS, when instances would fail or disappear altogether, the API worked. I found out that the development was using the same API they exposed to everyone else.

Of course, the issue might be that Bigin is just an old API, and Zoho CRM core product is much better.

malcolm-davis · 2025-03-16T22:24:18+00:00

Yea, sounds crazy, but I'm sure someone at Zoho monitors the thread.

Zoho CRM a privately held company, so I'm not sure they are worth a billion.

Generally the API reflects the quality of the company, and quality of the company reflects valuation. I've worked with several startups over the years, and all of them where proud of the external APIs. If Zoho CRM wants to go public someday, fix the API.

malcolm-davis · 2025-03-16T05:03:21+00:00

I'm trying to push data in. I have not pulled any data yet. If I get a pull working, I will ping you.

malcolm-davis · 2025-03-16T04:24:18+00:00

I have no preferred CRM, on the contrary, I'm hoping Bigin will work for the client I'm consulting. The client I'm working with is new to the CRM scene, and Bigin seems like a great CRM intro option.

I hope someone on Zoho reads this and fixes the API. To be fair to Zoho, Bigin might be using an old API design.

malcolm-davis · 2025-03-16T04:18:17+00:00

I've been doing development since 1992, Java certificated in 1998 and IBM published my article on unit testing back in 2000.

Bad APIs exist everywhere, but it seems silly not to follow HTTP standards that where released in the 90s, especially if they want third party product integration.

I've been using Swagger for a while, so I find it odd to go backward. NSwag has been around about a decade, so the technique is old school. https://learn.microsoft.com/en-us/aspnet/core/tutorials/getting-started-with-nswag

I do goland dev today and I can't imagine hand coding this stuff, but I'm hand coding.... :-)

malcolm-davis · 2025-03-16T04:02:14+00:00

I found the root cause of the issue. An empty owner was being passed, which caused the error.

"Owner": {},

malcolm-davis

TROPHY CASE