Skip to main content

New Developer

  • July 19, 2025
  • 16 replies
  • 238 views

JSpikowski
Jr Varsity II
Forum|alt.badge.img

Hi Everyone,

I joined the Acumatica forum as a resource for my external Acumatica application extensions using REST and the ScriptBasic application web server. Any good links to REST interfacing would be appreciated.

 

John

 

Excuse typo in the title., 🙄

16 replies

Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • July 19, 2025

Forum|alt.badge.img+1
  • Semi-Pro III
  • July 19, 2025

@JSpikowski 

Below is the link to REST API examples. You can also explore related topics and resources on the Acumatica Learning Portal under REST API Integration for Developers.

https://help.acumatica.com/(W(1))/Help?ScreenId=ShowWiki&pageid=bbb8b84b-07d7-4a69-adf8-33dc5d430b60

https://acumatica.litmos.com/home/LearningPath/78762?r=False&ts=638885136261864247


JSpikowski
Jr Varsity II
Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • July 19, 2025

Thanks for the links and guidance.

The 'Modern UI' seems similar to Bootstrap which I'm using. The plan is build an Acumatica template using modern UI CSS.

This is an example of using the Bootstrap UI framework and the ScriptBasic web server on my AWS Ubuntu instance. I use this demo to show QBO clients how their app will look.

https://sbqbo.org/home/qbo_main

Bootstrap is mobile centric so give the demo a try on your phone and laptop.


JSpikowski
Jr Varsity II
Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • July 20, 2025

Can the REST API be used to extend an existing Acumatica screen?


JSpikowski
Jr Varsity II
Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • July 21, 2025

From what I've read so far about Acumatica's REST API is it's similar to QBO's REST and web hook API.

I'm not a big .NET fan and was attracted to Acumatica's REST API and migration to a JavaScript driven UI.

 


JSpikowski
Jr Varsity II
Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • July 21, 2025

Thanks support for fixing the typo in the title.

What I have learned.

* Titles can't be edited after posting, only the body.

* Post can't be deleted to re-enter them

 


JSpikowski
Jr Varsity II
Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • July 22, 2025

I was able to get Acumatica installed and was able to login. There doesn't seem to be any accounting function access. Is there a demo company that needs to be installed?

 


JSpikowski
Jr Varsity II
Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • July 22, 2025

I figured it out. I needed to add the demo company in the Tenant Setup screen. Everything seems to be working now.

I decided to go with MySQL for the DB server. ScriptBasic has a C API extension module for MySQL which is lightning fast.

I looking forward to see what's under the covers and how I can seamlessly interface with Acumatica.


JSpikowski
Jr Varsity II
Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • July 22, 2025

Does Acumatica offer a MS SQL to MySQL conversion tool?

 


JSpikowski
Jr Varsity II
Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • July 22, 2025

 

The MySQL Workbench Migration Wizzard can convert a MS SQL DB.


JSpikowski
Jr Varsity II
Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • July 23, 2025

Why doesn't Acumaticatica use minimized JavaScript includes? Are they generated on the fly?

I was reviewing the Acumatica .css style sheet and it sure looks like an older version of Bootstrap which makes me think the library being used is a fork. It's still using jQuery.

My JSON extension module turns JSON into a multi-level associative arrays. It expects responses in unformatted JSON. Can I submit unformatted JSON?

 

 


JSpikowski
Jr Varsity II
Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • July 24, 2025

Not a Bootstap fork.

Aurelia.io is a modern JavaScript framework for building web, mobile, and desktop applications. Bootstrap, on the other hand, is a front-end framework for developing responsive, mobile-first websites using HTML, CSS, and JavaScript. 


JSpikowski
Jr Varsity II
Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • July 24, 2025

I'm running 2025 R1 which seems to be based on the new 'Modern UI'. The Aurelia.io UI framework that Acumatica is using is similar to Bootstrap. I'm still investigating how this UI can be customized by developers.

I'm focusing on a REST interface for a business logic interface and use a separate browser tab for the UI using Bootstrap and ScriptBasic web server. 


JSpikowski
Jr Varsity II
Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • July 24, 2025

Are all currently supported versions of Acumatica providing a REST interface? What version started supporting MySQL?


JSpikowski
Jr Varsity II
Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • July 25, 2025

I see the direction I'm taking with integrating with Acumatica being like what MYOB did. Use Acumatica as a business logic engine wrapped with custom UI presentation. ScriptBasic and Bootstrap is a natural for this effort.

 


JSpikowski
Jr Varsity II
Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • July 25, 2025

I wonder if it would be worthwhile to create a web based Sage 100 like UI  but use Acumatica as the backend?

Since Sage 100 is written in Business BASIC, migrating to ScriptBasic should be a easy transition for Sage developers.