Big Business API: Line Item Info
Big Business API is an Application Programming Interface that lets you read and write, update and insert, and add or delete data from Big Business using an available connection such as Middleware (MySQL), ODBC, SQL, or Web (HTTP or HTTPS).
Line Item Info is a structure for sending information about Line Items (e.g. items on Invoices) that you can Add or Update in Big Business.
This Solution provides details for Line Item Info. (6283)
UID - Big Business UID, automatically assigned
fUID - Big Business UID, if needed for finding Line Item to update
pUID - Big Business UID, if needed to identify Parent (Invoice) for Line Item
ItemCode - Big Business Item Code
Dsc1 - Description1, if needed to override Item's
Dsc2 - Description2, if needed to override Item's
Qty - Quantity, if needed to override default
Prc - Price, if needed to override Customer's pricing for Item
Taxable - (1 = Taxable), if needed for Sales Tax
Cmt - Line Item Comment, if needed to add to Item's Detail Description
ItemUID - Big Business UID, if needed for identifying Item
LocationCode - Big Business Warehouse Code, if needed for Multi-Warehouse
Disc - Discount percentage (20 = 20% off), if needed
BuildCode - Big Business BuildCode (4 = AutoBuilt), if needed
Action - Big Business Action (addinvli = add invoice line item), if needed
Token - security Token, if needed for authentication
ExtID - external ID, if needed for reference
ExtParentID - external ID for Parent, if needed for reference
Big Business API: Customer Info
Big Business API is an Application Programming Interface that lets you read and write, update and insert, and add or delete data from Big Business using an available connection such as Middleware (MySQL), ODBC, SQL, or Web (HTTP or HTTPS).
Customer Info is a structure for sending information about Customers to Add or Update in Big Business.
This Solution provides details for Customer Info. (6284)
UID - Big Business UID, automatically assigned
Action - Big Business Action, if needed
Token - security Token, if needed for authentication
ExtID - external ID, if needed for reference
fUID - Big Business UID, if needed for finding an existing Customer Card
The rest of the Fields are identical to those found in the Cust Table.
Big Business API: Contact Info
Big Business API is an Application Programming Interface that lets you read and write, update and insert, and add or delete data from Big Business using an available connection such as Middleware (MySQL), ODBC, SQL, or Web (HTTP or HTTPS).
Contact Info is a structure for sending information about Contacts and Customers.
This Solution provides details for Contact Info. (7560)
UUID - Universal Unique ID, automatically assigned
fUID - Big Business UID, if needed for finding Contact or Customer to update
Action - Big Business Action (updatecust), as needed
Listing, Company Name, Code, Salutation, First Name, Last Name, Title, Billing Name, Billing Address 1, Billing Address 2, Billing City, Billing State, Billing Zip, Billing Country, Phone 1, Phone 2, Email, Comment, User-Defined Date
Big Business 13.71 adds Price Level for updating from Trade Show iPad.
Big Business 13.63 adds Phone 3, Phone 4 for additional information in BizApp Orders.
Web API Response
The Web API sends a response to let you know the status of each entry submitted.
This Solution provides an example. (6531)
The Web API sends a response to let you know the status of each entry submitted.
This example is a Sales Order Line Item (SOLI) Import called "test" (see the escaped url on line 2). It successfully created Sales Order Numbers 8566 and 8567 (SONo on lines 8 and 16). It failed to create the third.
"id" is the submitted name/value that is mapped to Customer PO # or Order # (required to identify each order). If your request maps "web_order" the reply will contain "web_order".
"status" is the result of the nested transaction that handles each object--in this case an order. When the result is "Success" the response includes additional results--a unique id (UID), Sales Order Number (SONo), Customer Listing (CustLisg), and Total (Ttl). When the result is "Failure" there are no additional results.
"exceptions" are included where they occur--in the response or within objects.
"source" is the name and number of a Solution that explains where the exception comes from. With thousands of possible exceptions this is an import part to know first.
"text" is the exception message, including any error code [in brackets] and message--in this case what displays in an alert when an import cannot find an item to use.
Web API Import Settings
The Web API Import Settings use the standard Import Settings with a few additions:
• Fields/Notes lets you enter a list of Fields Available for Insertion and any Notes
• Fields/Notes lets you Paste sample JSON or XML to extract Fields automatically
• Fields Available for Insertion are listed in Xpath notation
• Web API Imports should be saved with a web-friendly name
This Solution provides details. (6531)
The Web API Import Settings use the standard Import Settings with a few additions:
• Fields/Notes lets you enter a list of Fields Available for Insertion and any Notes
• Fields/Notes lets you Paste sample JSON or XML to extract Fields automatically
• Fields Available for Insertion are listed in Xpath notation
• Web API Imports should be saved with a web-friendly name
To Create a New Web API Import:
1. Click the Web API tool on the Maintenance toolbar
2. Click the Fields/Notes button, paste sample JSON or a field list, and click OK
3. Map the Fields Available to Insertion Order by selecting and clicking Insert
4. Click Save As... to name and save the Import using a web-friendly name
Fields/Notes lets you Paste a sample JSON or XML file to extract Fields Available for Insertion. These are listed in Xpath notation like "/line_items/item/code". You can ignore repeat entries with counters ("/line_items/item[2]/code") unless specifically needed.
When you save your API Import its endpoint uses its web-friendly name. If you name your API Import, "test", it is available at "https://server_address:port/api/import/test". If you Post JSON matching your sample, it will be mapped and imported using the settings saved in "test". And "test" will be listed in the Web API tool if you need to make more changes.
Web API
Web API provides a REST API you can use from another application, like Magento, to send Orders to Big Business.
This Solution provides details. (6810)
Web API is an Option for Big Business Enterprise thet provides a REST API for sending Orders to Big Business.
Setup includes Mapping for order information.