quickbooks | QuickBooks API Wrapper

by activecollab PHP Version: 2.0.5 License: MIT

X-Ray Key Features Code Snippets(3)Community Discussions(10)Vulnerabilities Install Support

kandi X-RAY | quickbooks Summary

quickbooks is a PHP library. quickbooks has no bugs, it has no vulnerabilities, it has a Permissive License and it has low support. You can download it from GitHub.

QuickBooks API Wrapper

Support

Quality

Security

License

Reuse

Support

quickbooks has a low active ecosystem.

It has 13 star(s) with 10 fork(s). There are 12 watchers for this library.

It had no major release in the last 12 months.

There are 0 open issues and 3 have been closed. On average issues are closed in 0 days. There are no pull requests.

It has a neutral sentiment in the developer community.

The latest version of quickbooks is 2.0.5

Quality

quickbooks has no bugs reported.

Security

quickbooks has no vulnerabilities reported, and its dependent libraries have no vulnerabilities reported.

License

quickbooks is licensed under the MIT License. This license is Permissive.

Permissive licenses have the least restrictions, and you can use them in most projects.

Reuse

quickbooks releases are available to install and integrate.

Installation instructions are not available. Examples and code snippets are available.

Top functions reviewed by kandi - BETA

kandi has reviewed quickbooks and discovered the below as its top functions. This is intended to give you an instant insight into quickbooks implemented functionality, and help decide if they suit your requirements.

C Cc .
Sends a HTTP request .
Migrate OAuth1 to OAuth2 .
Get user details .
Get the data service .
Send a connection request .
Convert object to array
Get the base url .
Get an Iterator .
Get the client secret .

Get all kandi verified functions for this library.

quickbooks Key Features

No Key Features are available at this moment for quickbooks.

quickbooks Examples and Code Snippets

Usage,Sandbox

PHP

Lines of Code : 7

License : Permissive (MIT)

Copy

$sandbox = new ActiveCollab\Quickbooks\Sandbox(
    'example-consumer-key',
    'example-consumer-key-secret',
    'example-access-token',
    'example-access-token-secret',
    'example-realmId'
);

Usage,Querying API

PHP

Lines of Code : 7

License : Permissive (MIT)

Copy

$dataService = new ActiveCollab\Quickbooks\DataService(
    'example-consumer-key',
    'example-consumer-key-secret',
    'example-access-token',
    'example-access-token-secret',
    'example-realmId'
);

Usage,Authentication

PHP

Lines of Code : 5

License : Permissive (MIT)

Copy

$quickbooks = new ActiveCollab\Quickbooks\Quickbooks([
    'identifier'    => 'example-consumer-key',
    'secret'        => 'example-consumer-key-secret',
    'callback_uri'  => 'http://example.com'
]);

Community Discussions

Trending Discussions on quickbooks

How to add QBFC as a dependency in visual studio

Is it possible to store individual PostgreSQL databases in individual files/directories instead of a single central data repository with everything?

node-quickbooks reconnect method no longer gives expected response

Access a Multidimensional Array Value in Laravel Blade

How do I properly access Excel Files through Access VBA

Djanog app quickbooks authorization page from client

Where can I store the refresh and access token in django

Only grab new data from API using python

Sbt failed to run on visual studio code

How to get Quickbooks Desktop Web Connector to initiate a connection?

QUESTION

How to add QBFC as a dependency in visual studio

Asked 2021-Jun-10 at 18:51

I made a program that connects to QuickBooks to automate a task. And it relies on QBFC13 so how can I make sure that QBFC13 is installed before installing my program. Or is there a way to install it first?

...

ANSWER

Answered 2021-Apr-18 at 16:26

Not familiar with QBFC13 but why not use WiX and WiX Bootstrapper to build your installs and chain them together?

I just looked up this product and it looks like Intuit builds merge modules (MSM) for just your scenario. After installer their SDK I would find the specific merge module and then include that in your install.

Source https://stackoverflow.com/questions/67139357

QUESTION

Is it possible to store individual PostgreSQL databases in individual files/directories instead of a single central data repository with everything?

Asked 2021-Mar-27 at 22:15

I am new to software development in general. My skills are probably best described as intermediate. I have done a lot of programming, but I have not mastered any particular language. I have much studying to do to learn all the skills necessary for this.

I want to develop a desktop accounting application like PeachTree or QuickBooks. All data is hosted on the local machine and there is no need for a web server. At some point, I may want to be able to host a local server on a network and access the app through clients on other computers. Also, there is no need to have multiple users access the same database at the same time. Both of these conditions may change in the future but are not necessary for me to address at this time (I don't believe).

Years ago, I built an accounting application using Microsoft Access (not sure if that would be considered an application) with a split database design. The entire database is contained within two files: mydb and mydb_be (front and back end). I have not used those other accounting apps in many years, but as I recall, the data was stored in either a single file or a single directory, but certainly NOT in a central repository nested deep within the database program's default file structure and data directory like it is with Postgres (and probably many/all of the others) with names like '16254' instead of 'MyBiz'.

In the case of my MS Access app, I can move, copy and delete mydb using the typical OS commands like cut/paste/delete and drag and drop. There is nothing to export or import. Again, as I recall, it was something similar with the commercial applications.

I may have 15 different databases, each for a different entity. I may want to change file structures for my "accounting" directory or copy to a usb drive and move it to another computer, open it there, or maybe back up to an external drive. The directory for each entity may contain files or folders (e.g. a directory for taxes) other than the database files and they all need to be kept together. I cannot expect my target users (maybe 10+ years old) to perform such database management tasks. Among other things, the app is designed to teach children how to do accounting, not database management.

So, the question is, is there a way to store individual Postgres databases in different locations in a packaged way where all the necessary data for an individual database is stored in a single file (like MS Access) or in a single directory, such that I can move the files around and open them from my application? In other words, clicking open file would allow me to navigate to ~/myaccounting/entity1/entity1db.file, or /entity2/entity2.file, or perhaps a directory instead of a file. Maybe my file extension would be 'kac' so I would double click on a file with the .kac extension to launch the app.

I plan to use PostgreSQL and Python to develop an interactive console app to start. Once I have proven the concept, I will develop the GUI.

Clearly, there are many concepts I haven't yet learned. I feel like I need to understand this before I get to deep into my application.

EDIT And if not, what else should I look into (thanks Adrian Klaver)? What keywords should I search or what concepts should I study?

Thanks for the help.

...

ANSWER

Answered 2021-Mar-27 at 22:15

Is it possible to store individual PostgreSQL databases in individual files

No. Postgres is designed to be a powerful reliable centralized database server for the enterprise. Postgres was never intended to be bundled within a desktop app.

Embedded database

What you are looking for is called an embedded database.

H2 Database Engine is one such product. H2 is a relational database, driven by SQL. Being compatible with Postgres is one of its goals. Built in pure Java, so it can run on many kinds of host operating systems. H2 can be run in embedded mode for access only by your app, or in server mode to accept connections from various apps simultaneously.

A comment mentioned SQLite. While that product is an embedded database, be aware that it is indeed “lite”. It’s creator intended the product to be a step up from simple files, not as a competitor to powerful database engines… to quote: “SQLite is not a replacement for PostgreSQL. SQLite is a replacement for fopen()” (source). While many people have done many projects successfully with SQLite, asking SQLite to support a full accounting package may be asking too much. Research carefully if you are considering this product.

Cloud

Another avenue is to use the Cloud. Many companies have started offering database as a service. Often called a “managed database” as you do not have full super user access for obvious security reasons, and because the service company handles back-ups, failover, software updates, and so on. Vendors include Digital Ocean, Heroku, Amazon AWS, Microsoft Azure, and more.

Postgres and MySQL are common offerings, with some offering Microsoft SQL Server or Oracle.

If you can reasonably expect users to have an internet connection while using your product, this might be viable. But I hesitate to recommend this route. While the internet connection need not have large throughput for your purpose, the internet connection does need to be reliable. But “reliable” and “internet connection” do not often go hand-in-hand.

In using a DBaaS, you would have to code your database to be very robust in the face of interrupted network access. Of course your should always do that. But in practice most of us get lax in that area, especially if we can count on very reliable connections. Such as when the database server is local to the same machine, or when the database server is connected to an app server nearby in a server room.

Another issue is that having different customers share a single database server raises problems of multitenancy.

Further discussion is really off-topic for Stack Overflow. I suggest two sister sites, Database Administrators Stack Exchange, and Software Recommendations Stack Exchange.

Source https://stackoverflow.com/questions/66833700

QUESTION

node-quickbooks reconnect method no longer gives expected response

Asked 2021-Mar-11 at 11:46

I am trying to get new access tokens before they expire using reconnect api endpoint, but the api call to https://appcenter.intuit.com/api/v1/Connection/Reconnect is being redirected to https://quickbooks.intuit.com/learn-support/en-us/do-more-with-quickbooks/third-party-app-security-requirements-updating-soon/01/428295, rather the expected response. Am i missing something here? Appreciate the help.

...

ANSWER

Answered 2021-Mar-11 at 11:46

According to Intuit's documentation, you're using the wrong URL:

https://developer.intuit.com/app/developer/qbo/docs/develop/authentication-and-authorization/oauth-2.0#refresh-the-token

Did you try using the correct URL?

From the docs:

Source https://stackoverflow.com/questions/66544474

QUESTION

Access a Multidimensional Array Value in Laravel Blade

Asked 2021-Feb-21 at 04:37

I am working with Laravel 8.0 with the Quickbooks API, When I run a quickbooks query to get all the customers, I get back a response that looks like this.

...

ANSWER

Answered 2021-Feb-21 at 04:00

Try this:

Source https://stackoverflow.com/questions/66298437

QUESTION

How do I properly access Excel Files through Access VBA

Asked 2021-Feb-13 at 09:35

I am a very novice coder and was writing a program to pull some data from an Access table and put that into an Excel Sheet. The Excel workbook creates properly, but when I go to save it, I get a

VBA Run-time error '1004' - Cannot access 'Checks and Transfers Import File 02122021.xlsx'.

When I try to open the file I get a message stating that someone is using the file but I can open it as "Ready Only". The problem is that no-one else is using the file. What am I doing wrong?

...

ANSWER

Answered 2021-Feb-13 at 09:35

You always must be extremely specific with Excel objects.

So, you may need to:

Source https://stackoverflow.com/questions/66178638

QUESTION

Djanog app quickbooks authorization page from client

Asked 2021-Feb-12 at 19:48

how can I have a page in my app in which I ask my clients to authorize my app to have access to my clients quickbooks?

I m ok to connect to quickbooks in my app but I add manually clients credentials. I would like to have template in my Django app that handle this. My client will use this template to authorize my app to have access to QBO?

...

ANSWER

Answered 2021-Feb-12 at 19:48

QuickBooks AuthClient has method get_authorization_url() which can generate auth URL for your app. Having this URL, you can redirect user to QuickBooks OAuth flow, which will redirect back to your web-site (URL you defined in settings) with auth_code as GET variable in URL. You can convert it to auth_token and save it to database.

Here you can find official documentation from QuickBooks:

Get started
Build your first app
python-quickbooks library with code examples

Source https://stackoverflow.com/questions/66177662

QUESTION

Where can I store the refresh and access token in django

Asked 2021-Feb-08 at 13:53

I'm using django and trying to integrate it with quickbooks online through python-quickbooks package and already did so and it works fine, but the problem is I don't want to store the tokens in the request session because I'm trying to access them outside the views, to be exact I'm trying to send an invoice each time an invoice(invoice model from django) object was made I want to send one to quickbooks and I'm doing this through django signals but I can't access the session from the signals so where is the best place to store them on the server side?

thanks in advance.

...

ANSWER

Answered 2021-Feb-08 at 13:53

You can create new Django model just for your integration and query it when you need to get tokens. Especially it can be useful if you plan to have multiple integrations, you can add relation from object (which is related to signal) to "integration object".

Source https://stackoverflow.com/questions/66045707

QUESTION

Only grab new data from API using python

Asked 2021-Jan-30 at 11:30

good morning,

I've recently wrote a programme to pull transaction data from stripe's API and save as a .CSV file so i can import all transactions into QuickBooks very easily. It works well and I'm very happy with it. However every time I run it, it will grab every transaction which i will then have to go through and delete all duplicate data in QuickBooks. What would be the best approach to make the programme only grab the newest transactions? would it be to give python a date to work from, or would it be to check if the data is already in the .CSV file and remove it?

this is my code:

...

ANSWER

Answered 2021-Jan-30 at 11:30

There are a couple of ways to do this based on how you have set up your extraction system.

Every time you pull data, find and store the latest transaction date in a file or table or elsewhere. For every subsequent API call, send that date so the API knows to filter out transactions that are <= that date. Make sure you update the stored latest transaction date every time the API runs.
If you cannot have persistent storage like above, your API query can also go into QuickBooks and get the latest transaction date before it queries Stripe. In the same way as point 1 above, you just the latest transaction date to do a filter.
Similar to point 2, instead of querying QuickBooks, your API could query your latest CSV file for the latest transaction date (if you are storing these CSV files somewhere).

Source https://stackoverflow.com/questions/65967374

QUESTION

Sbt failed to run on visual studio code

Asked 2021-Jan-18 at 12:24

I'm trying to configure visual studio code to run my java project which is using Play framework.

After installing Scala(Metal), there was an error:

...

ANSWER

Answered 2021-Jan-18 at 10:29

As described in your exception, com.lowagie:itext failed to resolve:

Source https://stackoverflow.com/questions/65772032

QUESTION

How to get Quickbooks Desktop Web Connector to initiate a connection?

Asked 2021-Jan-12 at 07:15

I'm trying to build a node service to pull information from Quickbooks Desktop. The most logical route seems to be the Quickbooks Desktop Web Connector.

I have tried with both quickbooks-js and creating a node-soap class from the wsdl and while the server runs fine, I don't see any logs about connections.

From the client side, I have been trying to connect to this nodejs service, but QBWC almost immediately stops responding. This is the full log for attempting to add my connection:

Log file initialized at Monday, January 11, 2021 - 7:44 AM UTC
Timestamp format used: YYYYMMDD.HH:MM:SS UTC QBWebConnector 2.2 has been initialized with its logging status to level = DEBUG. Please restart QBWebConnector for any change in log level to take effect. Use file menu to clear log.

20210111.07:44:08 UTC : QBWebConnector.RegistryManager.setUpdateLock() : HKEY_CURRENT_USER\Software\Intuit\QBWebConnector\UpdateLock has been set to False 20210111.07:44:08 UTC : QBWebConnector.RegistryManager.setUpdateLock() : ********************* Update session unlocked ********************* 20210111.07:44:09 UTC : QBWebConnector.RegistryManager.setUpdateLock() : HKEY_CURRENT_USER\Software\Intuit\QBWebConnector\UpdateLock has been set to False 20210111.07:44:09 UTC : QBWebConnector.RegistryManager.setUpdateLock() : ********************* Update session unlocked ********************* 20210111.07:44:09 UTC : QBWebConnector_Load() : QuickBooks Web Connector 2.3.0.198 has started. Monday, January 11, 2021 at 7:44:09 AM 20210111.07:44:09 UTC : QBWebConnector_Load() : QBWC Form Loaded 20210111.07:44:20 UTC : QWCReader.ParseQWC() : Contents of QWC file: - Troubleshoot access via QuickBooks
IDNTS_FS1
https://8001-XXX.ws-eu03.gitpod.io
Helps troubleshoot QBWebConnector for QuickBooks
https://8001-XXX.ws-eu03.gitpod.io
test
{A9A83089-7DA7-4d27-A08C-7E1626E9395A}
{AE931E67-4AA5-4374-A32D-8EA4BEC91981}
QBFS Document
0xF 20210111.07:44:20 UTC : QBWebConnector.WebServiceManager.ReadQWC(QWCReader QWC) : Parsing application configuration xml file to load its content to variables

From the client side, I have tried the Quickbooks testing connection, and received the following logfile (looks like it worked):

Log file initialized at Friday, January 8, 2021 - 12:25 PM UTC
Timestamp format used: YYYYMMDD.HH:MM:SS UTC QBWebConnector 2.2 has been initialized with its logging status to level = DEBUG. Please restart QBWebConnector for any change in log level to take effect. Use file menu to clear log.

20210108.12:25:31 UTC : QBWebConnector.RegistryManager.setUpdateLock() : HKEY_CURRENT_USER\Software\Intuit\QBWebConnector\UpdateLock has been set to False 20210108.12:25:31 UTC : QBWebConnector.RegistryManager.setUpdateLock() : ********************* Update session unlocked ********************* 20210108.12:25:31 UTC : QBWebConnector.RegistryManager.setUpdateLock() : HKEY_CURRENT_USER\Software\Intuit\QBWebConnector\UpdateLock has been set to False 20210108.12:25:31 UTC : QBWebConnector.RegistryManager.setUpdateLock() : ********************* Update session unlocked ********************* 20210108.12:25:31 UTC : QBWebConnector_Load() : QuickBooks Web Connector 2.3.0.198 has started. Friday, January 8, 2021 at 12:25:31 PM 20210108.12:25:31 UTC : QBWebConnector_Load() : QBWC Form Loaded 20210108.12:26:19 UTC : QWCReader.ParseQWC() : Contents of QWC file: - Troubleshoot access via QuickBooks
IDNTS_FS1
https://test.developer.intuit.com/QBWC/TroubleshootWebServiceFS/Service.asmx Helps troubleshoot QBWebConnector for QuickBooks
http://developer.intuit.com/QBWebConnector/
test
{A9A83089-7DA7-4d27-A08C-7E1626E9395A}
{AE931E67-4AA5-4374-A32D-8EA4BEC91981}
QBFS Document
0xF 20210108.12:26:19 UTC : QBWebConnector.WebServiceManager.ReadQWC(QWCReader QWC) : Parsing application configuration xml file to load its content to variables 20210108.12:26:30 UTC : QBWebConnector.RegistryManager.createRegKey() : Error creating registry key for appName = <> 20210108.12:26:30 UTC : QBWebConnector.RegistryManager.createRegKey() : Reason: Value cannot be null. Parameter name: name 20210108.12:26:30 UTC : QBWebConnector.SOAPWebService.SerializeToRegistry() : Error saving Troubleshoot access via QuickBooks to Registry: Object reference not set to an instance of an object. 20210108.12:26:30 UTC : QBWebConnector.SOAPWebService.ConnectToQB() : Connecting to QuickBooks... 20210108.12:26:52 UTC : QBWebConnector.SOAPWebService.ConnectToQB() : Connected., Session started 20210108.12:26:52 UTC : QBWebConnector.SOAPWebService.AddToQuickBooks() : Application name = Troubleshoot access via QuickBooks 20210108.12:26:52 UTC : QBWebConnector.SOAPWebService.AddToQuickBooks() : Querying company file to find if owner/file id exists. 20210108.12:26:52 UTC : QBWebConnector.SOAPWebService.findFileIDinQB() : Latest QBXML version supported = v14.0 20210108.12:26:52 UTC : QBWebConnector.SOAPWebService.findFileIDinQB() : Querying QuickBooks for existance of owner/file id 20210108.12:26:52 UTC : QBWebConnector.SOAPWebService.findFileIDinQB() : XML dump follows: -
onError="s......

20210108.12:26:53 UTC : QBWebConnector.SOAPWebService.findFileIDinQB() : XML dump follows: -
requestID="......

20210108.12:26:53 UTC : QBWebConnector.SOAPWebService.findFileIDinQB() : Status message: A query request did not find a matching object in QuickBooks 20210108.12:26:53 UTC : QBWebConnector.SOAPWebService.AddToQuickBooks() : FileID did not exist. Creating new FileID in company file 20210108.12:26:53 UTC : QBWebConnector.SOAPWebService.registerDataExtInQB() : Creating DataExtDef named FileID assigned to Company object for the ownerID = {A9A83089-7DA7-4d27-A08C-7E1626E9395A} 20210108.12:26:53 UTC : QBWebConnector.SOAPWebService.registerDataExtInQB() : XML dump follows: -
onError="s......

20210108.12:26:53 UTC : QBWebConnector.SOAPWebService.registerDataExtInQB() : XML dump follows: -
requestID="1"......

20210108.12:26:53 UTC : QBWebConnector.SOAPWebService.registerDataExtInQB() : Data extension definition has been created in QuickBooks for owner id. 20210108.12:26:53 UTC : QBWebConnector.SOAPWebService.AddToQuickBooks() : Registered FileID to company file successfully. 20210108.12:26:53 UTC : QBWebConnector.SOAPWebService.enterDataExtValueInQB() : XML dump follows: -
onError="s......

20210108.12:26:53 UTC : QBWebConnector.SOAPWebService.enterDataExtValueInQB() : XML dump follows: -
requestID="1" st......

20210108.12:26:53 UTC : QBWebConnector.SOAPWebService.enterDataExtValueInQB() : Data extension value has been created in QuickBooks for FileID 20210108.12:26:53 UTC : QBWebConnector.SOAPWebService.AddToQuickBooks() : Entered FileID value to company file successfully. 20210108.12:26:53 UTC : QBWebConnector.SOAPWebService.registerDataExtInQB() : Creating DataExtDef named AppLock assigned to Company object for the ownerID = {A9A83089-7DA7-4d27-A08C-7E1626E9395A} 20210108.12:26:53 UTC : QBWebConnector.SOAPWebService.registerDataExtInQB() : XML dump follows: -
onError="s......

20210108.12:26:54 UTC : QBWebConnector.SOAPWebService.registerDataExtInQB() : XML dump follows: -
requestID="1"......

20210108.12:26:54 UTC : QBWebConnector.SOAPWebService.registerDataExtInQB() : Data extension definition has been created in QuickBooks for owner id. 20210108.12:26:54 UTC : QBWebConnector.SOAPWebService.AddToQuickBooks() : Registered the AppLock to company file successfully. 20210108.12:26:54 UTC : QBWebConnector.CompanyFileLock.Send_DataExtDefAddRqXML() : XML dump follows: -
onError="s......

20210108.12:26:54 UTC : QBWebConnector.CompanyFileLock.Send_DataExtDefAddRqXML() : XML dump follows: -
requestID="1"......

I tried rolling my own XML connection file based on the spec but I eventually copy-pasta'd the spec and just swapped out the URLs. The only file I can get any log after the variable line for is the Quickbooks test one.

I feel like if I can fix logging, I can at least see what the problem is so I have something to work with. I'm using Quickbooks Pro 2021 if that helps.

Thanks for reading.

...

ANSWER

Answered 2021-Jan-12 at 07:15

So there seems to be some implied limit on the domain length. GitPod's domains are quite long and that seems to have caused the crash. It is undocumented to the best of my knowledge.

Source https://stackoverflow.com/questions/65663264

Community Discussions, Code Snippets contain sources that include Stack Exchange Network

Vulnerabilities

No vulnerabilities reported

Install quickbooks

You can download it from GitHub.
PHP requires the Visual C runtime (CRT). The Microsoft Visual C++ Redistributable for Visual Studio 2019 is suitable for all these PHP versions, see visualstudio.microsoft.com. You MUST download the x86 CRT for PHP x86 builds and the x64 CRT for PHP x64 builds. The CRT installer supports the /quiet and /norestart command-line switches, so you can also script it.

Support

For any new features, suggestions and bugs create an issue on GitHub. If you have any questions check and ask questions on community page Stack Overflow .

Find more information at: