Quickbooks Integration: Transactional Data Model
If you are integrating with Quickbooks (desktop version), here we have an example of the transactional data model of the objects that can be integrated. A customer object can have one or many transactions (Sales Order, Invoice, Sales Receipt) A transaction object can have one or many items. A Sales Order can be converted…
Read MoreDynamics GreatPlains Integration: Data Model
If you are integrating with Microsoft Dynamics GreatPlains, this is the high-level data model for the finance module: A customer object is a company. It doesn’t have an independent contact object. A customer can have many addresses. Inside each address, you can keep track of contact name. A customer can have many sales entries (Invoice…
Read MoreQuickBooks Integration: Transaction (Sales Order, Invoice) Counter
When creating a transaction in QuickBooks, a transaction number will be generated followed by the last transaction created. In most of the applications, transaction number has to be unique and is not allowed to be modified to prevent duplication and confusion. However, in QuickBooks, transaction number is allowed to be modified which means that when…
Read MoreMagento Integration: Synchronise Product Data
In Magento, one SKU can have different product names. For example: If you have two different store views, you can have your product name in two different languages English: Table Spanish: Silla To do this via the Magento Core API, you will need to: Create the product using the catalogProductCreate function (default values) Update…
Read MoreNetsuite Integration: Session Limits
A given standard Netsuite user login is limited to two sessions at the same time, one through the front-end (UI) and one through the web services. For example, if someone attempts to log in from two different browsers at a time by using the same login user, the login from the second browser will…
Read MoreAprimo Integration : Retrieving a Digital Asset
Aprimo has a sophisticated data model to handle Digital Asset. You can retrieve from the API directly. Before you do that, you should understand the following data structure: Activity Each activity can have one or more digital asset. You can add an existing digital asset or promote from existing attachment. AssetVersion Each…
Read MoreExtracting Data from MYOB : Total Sales
There are ways to extract data like total sales from MYOB (Database) and generate this data into useful information for the company. Here is one of the ways. First, we may need to query all the sales data from MYOB by filtering them by type of invoice. The next step, we can…
Read MoreMagento Integration: Access to web services
In order to access Magento web services API, you will need to do the following: Log in with a username and API key. This username is not the same as the username that you used to log in to the admin backend of the store. You will need to create an API user and role…
Read MoreVolusion Integration : API
Volusion has an interesting API. It allows you to somehow perform a “SQL query” in the URL. For example, if I want to query customer with the following SQL: SELECT CustomerID,BillingAddress1,City,CompanyName FROM Customer WHERE CompanyName=’WDCi’ I can achieve it with the following URL: https://<volusion_url>/net/WebService.aspx?Login=<login>&EncryptedPassword=<encrypted_password>&EDI_Name=Generic\Customers&SELECT_Columns=CustomerID,BillingAddress1,City,CompanyName&WHERE_Column=CompanyName&WHERE_Value=WDCi
Read MoreWDCi becomes one of the first certified Dell Boomi partners
Dell Boomi has just launched a certification program for their partners. If you’re asking yourself is this an attempt at shameless self-promotion, you’re right, WDCi is one of the first certified partners. Boomi announced the list of initial certified partners in their Spring Product Release announcement. Details on the certification program can be found…
Read More