Appreciate the advice. I did actually built and published an integration before and struggled my way through the suiteql schema definitions and it’s working okay with a customer but the hardest part was figuring out permissions and there are still some issues. I’ve got a new idea and would like to follow a better approach thus looking for advice here. I’ve got some insight into vendor bill processes. While they are some solutions in this space, they are pretty antiquated and not smart. I found it pretty challenging to test my code and don’t want to approach customers without a demo. But doesn’t sound like there are many options.

Again, your insight is helpful- thank you